This analysis is about
- Replacing the 9th-grade data scores at Thomas High School on the other hand analyzing other data.
- Assembling data into DataFrame.
- Arranging Scores by School Spending, Size, and Type
- Determining the top five schools. and the bottom 5 schools
- The set of columns we have are, The total school budget, per student capita, average math and reading score, the passing percent for math and reading, and the overall passing percentage.
What we have done is fixing small portion of data math and reading scores for 9th graders at Thomas High School and we can tell the highest performing schools first Cabrera High School, second Thomas High School and third Griffin High School and Low Performing Schools are Rodriguez High School, Figueroa High School, and Huang High School
Overall, the change we Have made affects the averages and percentages at Thomas High School where the math and reading scores for 9th graders were removed.
This Analysis helped us to get the right number of students counted at Thomas High School, the average math and reading scores, and the percentages in Passing Math and reading at Thomas High School. Which we can see a difference in average scores and score percentages, and also we can tell the highest performing schools and Low Performing Schools