This assignment utilizes Pandas and Jupyter Notebook to create a report displaying trends using data as it relates to a hypothetical city school district in order to provide assistance in strategic decisions.
The report uses the following key metrics:
- Total schools
- Total students
- Total budget
- Average math score
- Average reading score
- % passing math (the percentage of students who passed math)
- % passing reading (the percentage of students who passed reading)
- % overall passing (the percentage of students who passed math AND reading)
By using the data provided, the above key metrics are calculated to show the following results:
- District Summary
- School Summary
- Highest-Performing Schools (by % Overall Passing)
- Lowest-Performing Schools (by % Overall Passing)
- Math Scores by Grade
- Reading Scores by Grade
- Scores by School Spending
- Scores by School Size
- Scores by School Type
- Jupyter Notebook that contains report generated from Python script
- Data files provided by assignment