Overview
Fictional PyCity School District currently has 15 high schools. The school board recently reviewed standardized test scores for math and reading. It was determined that scores for the 9th graders at Thomas High School had been altered. The extent of academic dishonesty is not known. Therefore, the school board wants all Thomas High 9th grade students' scores to be changed to NaN's and a repeat of the initial analysis. This will be done with Jupyter Notebooks and Python's Pandas library.
Analysis
Removing these scores did not have significant impact on the average scores for the district. However, as could be expected, the percentage of passing students at Thomas High dropped from percentages in the 90s to the 60s. There were less students included in the analysis with passing grades at this point. Thomas High went from being one of the best performing schools to among the worst. This could lead to less funding being provided to the school.
Summary
Replacing incorrect data with NaN's is one way to deal with this situation. However, I would prefer to conduct further research to see if corrected data could be obtained, and only use this as a last resort. In the case of Thomas High, waiting until an investigation was complete would have been preferable. This could help determine which scores needed adjustment instead of just removing the scores of all 9th graders.
For chart views and code see my GitHub page: https://github.com/two-suns/School_District_Analysis . Please contact me with any questions or concerns. If you liked this please connect on LinkedIn, thank you.
Comments