SQL Analytical Project (Data Manipulation, SQL Programming, Data Cleaning)
Thanks to George Boorman, the dataset is available to download in this repository at the following link: https://github.com/ob-cheng/PROJECT-NYC_Public_School_Test_Result_Analysis/blob/main/dataset/schools_modified.csv
If you have any question, please don't be hesitate to leave me a message. I will respond ASAP! :)
Analysis how performance varies by borough, identify how many schools fail to report information, and find the top ten performing schools across the New York city.
The project is divided into 9 sub-tasks. You can find futher details in the Jupyter notenook I uploaded (https://github.com/ob-cheng/PROJECT-NYC_Public_School_Test_Result_Analysis/blob/main/NY%20HS%20Analysis_notebook.ipynb).
| column | type | description |
|---|---|---|
school_name |
varchar |
Name of school |
borough |
varchar |
Borough that the school is located in |
building_code |
varchar |
Code for the building |
average_math |
int |
Average math score for SATs |
average_reading |
int |
Average reading score for SATs |
average_writing |
int |
Average writing score for SATs |
percent_tested |
numeric |
Percentage of students completing SATs |