Project Name: Exploring-NYC-Public-School-Test-Result-Scores

Description:

This Jupyter Notebook analyzes SAT scores data for schools. It performs several calculations and filters to derive insights from the dataset. The main functionalities include:

1. Calculating the percentage of the math score for each school.
2. Filtering schools with a math percentage greater than or equal to 80% and sorting them by their average math score.
3. Calculating the total SAT score for each school.
4. Selecting the top 10 schools with the highest total SAT scores.
5. Grouping the data by borough and calculating standard deviation, mean, and count of total SAT scores for each borough.
6. Identifying the borough with the highest standard deviation in SAT scores.

Instructions:

1. Ensure you have Jupyter Notebook installed on your system.
2. Install required dependencies using pip install pandas numpy.
3. Download the dataset file named schools.csv and place it in the same directory as the Jupyter Notebook file.
4. Open the Jupyter Notebook file notebook.ipynb.
5. Execute each cell in the notebook to perform the analysis.
6. View the output which includes information on schools with high math scores, top 10 schools with the highest total SAT scores, and the borough with the largest standard deviation in SAT scores.

Dependencies:

• pandas
• numpy

Dataset:

The analysis is performed on the dataset schools.csv. This dataset contains information about schools including average math scores, average reading scores, average writing scores, and borough information.

Output:

The notebook generates insights such as schools with high math scores, top 10 schools with the highest total SAT scores, and the borough with the largest standard deviation in SAT scores.