/4_Pandas_Homework

Primary LanguageJupyter Notebook

4 Pandas Homework

Rice University Data Analytics and Visualization Boot Camp 2020

This repository contains the following scenario:

PyCitySchools

In this notebook, we analyze the district-wide standardized test results. The dataset gives access to every student's math and reading scores, as well as various information on the schools they attend. By using Pandas, we aggregate the data and showcase obvious trends in school performance.

A written description of three observable trends based on the data is available at PyCitySchools Report

The notebook includes each of the following:

District Summary

  • A table with the 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

  • A table with 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)

  • A table with the top 5 performing schools based on % Overall Passing, 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.)

Bottom Performing Schools (By % Overall Passing)

  • A table with the bottom 5 performing schools based on % Overall Passing. Include all of the same metrics as above.

Math Scores by Grade**

  • A table with the average Math Score for students of each grade level (9th, 10th, 11th, 12th) at each school.

Reading Scores by Grade

  • A table with the average Reading Score for students of each grade level (9th, 10th, 11th, 12th) at each school.

Scores by School Spending

  • A table that breaks down school performances based on average Spending Ranges (Per Student), including:
    • 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

  • A table that breaks down school performances based on an approximation of school size (Small, Medium, Large).

Scores by School Type

  • A table that breaks down school performances based on school type (Charter vs. District).