PROJECT-NYC_Public_School_Test_Result_Analysis

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! :)

Project Description:

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

Table Preview

schools

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