/School_District_Analysis

Cleaning data in data frames to improve analytical accuracy

Primary LanguageJupyter Notebook

School_District_Analysis

Overview

A review of student grades data has shown sign of academic dishonesty as the reading and the math grades have been altered. We are replaced the reading and math grades for Thomas High School with NaNs. The rest of the data will be kept as is.

After the aforementioned grades have been replaced with NaNs, we will repeat the school district analysis and explain the effect of those changes on the overall analysis.

Full Code can ba accessed here

Results

District Summary Data Frame

School Summary

After

Before

Affect of replacing the ninth graders’ math and reading scores for Thomas High School’s performance relative to the other schools

Replacing the ninth graders’ math and reading scores with NaN resulted in decreasing the Percentage Passing Math, Percentage Passing Reading and the Percentage Overall Passing.

Affect of replacing the ninth-grade scores on:

Math and reading scores by grade

Math After

Math Before

Reading After

Reading Before

Scores by school spending

Spening After

Scores by school size

Size Before

Scores by school type

Type Before

Summary

Replacing the ninth graders’ math and reading scores with NaN resulted in decreasing the Percentage Passing Math, Percentage Passing Reading and the Percentage Overall Passing.