SQL Analytical Project (Data Manipulation, SQL Programming, Data Cleaning)

Final Work: https://github.com/ob-cheng/PROJECT-NYC_Public_School_Test_Result_Analysis/blob/main/NY%20HS%20Analysis_notebook.ipynb

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).