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

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

GitHub

GitHub - jfaccioli/school-performance-pandas: A data analysis to showcase trends in school performance.
A data analysis to showcase trends in school performance. - GitHub - jfaccioli/school-performance-pandas: A data analysis to showcase trends in school performance.