Pinned Loading

1. LEA-Budget-Balance-Tracking LEA-Budget-Balance-Tracking Public

   Data extraction, cleaning, and manipulation to track budget line items and campus budgets from PDFs exported from accounting software using the tabula-py package for an LEA.

   Jupyter Notebook

2. LEA-SIS-Data-Pipeline LEA-SIS-Data-Pipeline Public

   Establishing an API connection with LEA SIS to perform ETL and create a data pipeline to BigQuery to automate reporting workflows.

   Jupyter Notebook

3. LEA-Attendance-Data-Reporting LEA-Attendance-Data-Reporting Public

   End to end ETL attendance staff data reporting on a weekly, monthly, and quarterly cadence.

4. LEA-Enrollment-Calculator LEA-Enrollment-Calculator Public

   Enrollment calculator to find the days of enrollment for transfer students from an LEA for state reporting for the FY 25

   Jupyter Notebook

5. LEA-State-Testing-Data-Upload LEA-State-Testing-Data-Upload Public

   Python scripts to format raw testing data for upload into the LEA's SIS

   Jupyter Notebook

6. LEA-Transportation-Milage-Project LEA-Transportation-Milage-Project Public

   Using the Google Maps API to find the walking distance between a student's home address and the school they are attending to determine their eligibility for transportation in the upcoming school year

   Jupyter Notebook