Project Overview
You are the new Chief Data Scientist for your city's school district. In this capacity, you'll be helping the school board and mayor make strategic decisions regarding future school budgets and priorities. As a first task, you've been asked to analyze the district-wide standardized test results. You'll be given access to every student's math and reading scores, as well as various information on the schools they attend. Your task is to aggregate the data to showcase obvious trends in school performance.
Instructions
Using Pandas and Jupyter Notebook, create a report that includes the following data in the District and School Summary. Your report must include a written description of at least two observable trends based on the data.
District Summary
Perform the necessary calculations and then create a high-level snapshot of the district's key metrics in a DataFrame. Include the following: 1) Total number of unique schools 2) Total students 3) Total budget 4) Average math score 5) Average reading score 6) % passing math (the percentage of students who passed math) 7) % passing reading (the percentage of students who passed reading) 8) % overall passing (the percentage of students who passed math AND reading).
School Summary
Perform the necessary calculations and then create a DataFrame that summarizes key metrics about each school. Include the following: 1) School name 2) School type 3) Total students 4) Total school budget 5) Per student budget 6) Average math score 7) Average reading score 8) % passing math (the percentage of students who passed math) 9) % passing reading (the percentage of students who passed reading) 10) % overall passing (the percentage of students who passed math AND reading).