Package index • ALprekDB

Budget Module

Per-classroom funding data processing

budget_read(): Read Pre-K Budget Data
budget_detect_format(): Detect Budget File Format
budget_clean(): Clean Budget Data to Long Format
budget_to_long(): Convert Master/Panel to Long Format
budget_validate(): Validate Budget Data Quality
budget_transform(): Transform Budget Data to Wide Format with Derived Variables
budget_bind_years(): Combine Multiple Years into a Panel Dataset
budget_process(): Run Complete Budget Processing Pipeline
budget_process_years(): Run Complete Pipeline for Multiple Years
budget_config(): Create a Budget Processing Configuration
budget_track_classrooms(): Track Classroom Presence Across Years
budget_yoy_summary(): Summarize Year-Over-Year Changes
budget_summary_stats(): Calculate Summary Statistics by Group
budget_export_csv(): Export Budget Data to CSV
budget_export_excel(): Export Budget Data to Excel
budget_export_parquet(): Export Budget Data to Parquet
budget_export_rds(): Export Budget Data to RDS
budget_export_stata(): Export Budget Data to Stata (.dta)

Classroom Module

Classroom characteristics, teacher demographics, geography

classroom_read(): Read Pre-K Classroom Detail Data
classroom_detect_format(): Detect Classroom File Format
classroom_clean(): Clean Classroom Detail Data
classroom_validate(): Validate Cleaned Classroom Data
classroom_bind_years(): Combine Multiple Years into a Classroom Panel Dataset
classroom_process(): Run Complete Classroom Processing Pipeline
classroom_process_years(): Run Complete Pipeline for Multiple Years
classroom_config(): Create a Classroom Processing Configuration
classroom_track(): Track Classroom Presence Across Years
classroom_summary_stats(): Summary Statistics for Classroom Data
classroom_export_csv(): Export Classroom Data to CSV
classroom_export_excel(): Export Classroom Data to Excel
classroom_export_parquet(): Export Classroom Data to Parquet
classroom_export_rds(): Export Classroom Data to RDS
classroom_export_stata(): Export Classroom Data to Stata (.dta)

Student Module

Student demographics, assessments, services

student_read(): Read Pre-K Student/Child Detail Data
student_detect_format(): Detect Student File Format
student_clean(): Clean Student/Child Detail Data
student_validate(): Validate Cleaned Student Data
student_transform(): Derive Advanced Analysis Variables for Student Data
student_bind_years(): Combine Multiple Years into a Student Panel Dataset
student_process(): Run Complete Student Processing Pipeline
student_process_years(): Run Complete Pipeline for Multiple Years
student_config(): Create a Student Processing Configuration
student_track(): Track Student Presence Across Years
student_summary_stats(): Summary Statistics for Student Data
student_export_csv(): Export Student Data to CSV
student_export_excel(): Export Student Data to Excel
student_export_parquet(): Export Student Data to Parquet
student_export_rds(): Export Student Data to RDS
student_export_stata(): Export Student Data to Stata (.dta)

Linkage Module

Cross-module joins and master datasets

linkage_classroom_budget(): Join Classroom and Budget Data
linkage_student_classroom(): Join Student and Classroom Data
linkage_aggregate_students(): Aggregate Student Data to Classroom Level
linkage_create_master(): Create Master Linked Dataset
linkage_validate(): Validate Linkage Results
linkage_summary_stats(): Summary Statistics for Linkage Data
linkage_export_csv(): Export Linkage Data to CSV
linkage_export_excel(): Export Linkage Data to Excel
linkage_export_parquet(): Export Linkage Data to Parquet
linkage_export_rds(): Export Linkage Data to RDS
linkage_export_stata(): Export Linkage Data to Stata (.dta)

Database Module

DuckDB persistent storage and SQL queries

db_init(): Initialize ALprekDB DuckDB Database
db_close(): Close ALprekDB DuckDB Connection
db_write_panel(): Write Panel Data to DuckDB
db_write_master(): Write Master Linked Dataset to DuckDB
db_write_year(): Append Single Year to Existing Database Table
db_read_panel(): Read Panel Data from DuckDB
db_read_master(): Read Master Linked Dataset from DuckDB
db_list_tables(): List User Tables in ALprekDB Database
db_table_info(): Get Column Metadata for a Database Table
db_query(): Execute SQL Query on ALprekDB Database

Codebooks & Mappings

Data-driven reference tables

alprek_category_groups(): Load Budget Category Groups Codebook
alprek_delivery_types(): Load Delivery Type Codes
alprek_county_codes(): Load Alabama County Codes
alprek_degree_patterns(): Load Degree Classification Patterns
alprek_race_mapping(): Load Race/Ethnicity Mapping
alprek_language_mapping(): Load Classroom Language Mapping
alprek_student_race_mapping(): Load Student Race/Ethnicity Mapping
alprek_student_delivery_mapping(): Load Student Delivery Type Mapping

Synthetic Data

Generators for examples and vignettes

alprek_synthetic_budget(): Generate Synthetic Budget Panel Data
alprek_synthetic_classroom(): Generate Synthetic Classroom Panel Data
alprek_synthetic_student(): Generate Synthetic Student Panel Data

Utilities

Classroom code parsing and helpers

parse_classroom_code(): Parse a Single Classroom Code
parse_classroom_codes(): Parse Multiple Classroom Codes
alprek_infer_school_year(): Infer School Year from File Path
alprek_school_year_to_start(): Convert School Year to Start Year

S3 Print Methods

Display methods for ALprekDB objects

print(<alprek_budget_config>): Print method for alprek_budget_config
print(<alprek_budget_long>): Print method for alprek_budget_long
print(<alprek_budget_master>): Print method for alprek_budget_master
print(<alprek_budget_panel>): Print method for alprek_budget_panel
print(<alprek_budget_raw>): Print method for alprek_budget_raw
print(<alprek_budget_validation>): Print method for alprek_budget_validation
print(<alprek_classroom_clean>): Print method for alprek_classroom_clean
print(<alprek_classroom_config>): Print method for alprek_classroom_config
print(<alprek_classroom_panel>): Print method for alprek_classroom_panel
print(<alprek_classroom_raw>): Print method for alprek_classroom_raw
print(<alprek_classroom_validation>): Print method for alprek_classroom_validation
print(<alprek_linkage_classroom>): Print method for alprek_linkage_classroom
print(<alprek_linkage_master>): Print method for alprek_linkage_master
print(<alprek_linkage_student>): Print method for alprek_linkage_student
print(<alprek_linkage_validation>): Print method for alprek_linkage_validation
print(<alprek_student_clean>): Print method for alprek_student_clean
print(<alprek_student_config>): Print method for alprek_student_config
print(<alprek_student_panel>): Print method for alprek_student_panel
print(<alprek_student_raw>): Print method for alprek_student_raw
print(<alprek_student_validation>): Print method for alprek_student_validation