Skip to content

An introduction to Pandas and Jupyter Notebook and using those tools to clean raw data.

Notifications You must be signed in to change notification settings

benpeyton76/School_District_Analysis

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

8 Commits
 
 
 
 
 
 
 
 

Repository files navigation

School District Analysis

Overview:

The purpose of this analysis is to see if grades that had been altered in the 9th grade class of Thomas High School would affect the scores within the grades, school, and district. Due to the incorrect math and reading scores that were listed were changed to "NaN" (not-a-number). It was found that 461 student records were changed. An analysis was initiated to see if budget per student, size, and type of school has any correlation to the overall percentage of grades of the schools.

Results:

1. How is the district summary affected? Screen Shot 2022-04-06 at 3 26 28 PM

There is no change.

2. How is the school summary affected? Screen Shot 2022-04-06 at 3 29 44 PM

With Thomas High only losing approximately 0.3% of the overall passing percentage, it did not change the summary in terms of ranking.

3. How does replacing the ninth graders’ math and reading scores affect Thomas High School’s performance relative to the other schools? Screen Shot 2022-04-06 at 3 36 12 PM

There was no change.

4. How does replacing the ninth-grade scores affect the following:

  • Math and reading scores by grade:

Math:

Screen Shot 2022-04-06 at 3 39 01 PM

Reading:

Screen Shot 2022-04-06 at 3 43 55 PM

There was no change statistically. The only change is that the scores that are being scrutinized are represented with NaN.

  • Scores by school spending:

Screen Shot 2022-04-06 at 3 48 17 PM

There was no change.

  • Scores by school size:

Screen Shot 2022-04-06 at 3 50 28 PM

There was no change.

  • Scores by school type:

Screen Shot 2022-04-06 at 3 52 17 PM

There was no change.

Summary:

Besides minute changes in scores and percentages, the math, reading, and overall scores and percentages did not change. There was no change in the rank of the schools within the district. Overall, removing the test scores in question did not change any aspect of this research.

About

An introduction to Pandas and Jupyter Notebook and using those tools to clean raw data.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published