# A data analysis using python and pandas to showcase trends in school performance.

## A data analysis to showcase trends in school performance using Pandas.

### District Summary

- District's key metrics, including:
- Total Schools
- Total Students
- Total Budget
- Average Math Score
- Average Reading Score
- % Passing Math (The percentage of students that passed math.)
- % Passing Reading (The percentage of students that passed reading.)
- % Overall Passing (The percentage of students that passed math
**and**reading.)

### School Summary

- Key metrics about each school, including:
- School Name
- School Type
- Total Students
- Total School Budget
- Per Student Budget
- Average Math Score
- Average Reading Score
- % Passing Math (The percentage of students that passed math.)
- % Passing Reading (The percentage of students that passed reading.)
- % Overall Passing (The percentage of students that passed math
**and**reading.)

### Top Performing Schools (By % Overall Passing)

- Top 5 performing schools based on % Overall Passing.
- School Name
- School Type
- Total Students
- Total School Budget
- Per Student Budget
- Average Math Score
- Average Reading Score
- % Passing Math (The percentage of students that passed math.)
- % Passing Reading (The percentage of students that passed reading.)
- % Overall Passing (The percentage of students that passed math
**and**reading.)

### Bottom Performing Schools (By % Overall Passing)

- Bottom 5 performing schools based on % Overall Passing.

### Math Scores by Grade**

- Average Math Score for students of each grade level (9th, 10th, 11th, 12th) at each school.

### Reading Scores by Grade

- Average Reading Score for students of each grade level (9th, 10th, 11th, 12th) at each school.

### Scores by School Spending

- School performances based on average Spending Ranges (Per Student).
- Average Math Score
- Average Reading Score
- % Passing Math (The percentage of students that passed math.)
- % Passing Reading (The percentage of students that passed reading.)
- % Overall Passing (The percentage of students that passed math
**and**reading.)

### Scores by School Size

Groups based on a reasonable approximation of school size (Small, Medium, Large).

### Scores by School Type

Groups based on school type (Charter vs. District).