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).