Investigating The Relationship Between Housing Value and SAT Scores in New York City

A short project exploring the relationship between housing value (as an indicator of wealth) and SAT scores (as an indicator of academic success & prospects) by ZIP code in New York City

Environment & Stack:

I am using Python 3.12.0 with a list of packages that can be found in requirements.txt. I am also using Jupyter. I prefer to use VS Code to edit and view them.

If you would like to run this project yourself, execute the following commands in your shell:

$ git clone https://github.com/johnmays/wealth-and-SAT-NYC.git
$ cd wealth-and-SAT-NYC
wealth-and-SAT-NYC $ python3.12 -m pip install virtualenv
wealth-and-SAT-NYC $ python3.12 -m virtualenv .venv
wealth-and-SAT-NYC $ source .venv/bin/activate
(.venv) wealth-and-SAT-NYC $ pip install -r requirements.txt
(.venv) wealth-and-SAT-NYC $ mkdir data

then, download the requisite data from the NYC OpenData website into the /data directory and the notebook should run!

Data:

• SAT (College Board) 2010 School Level Results OpenData Dataset as .csv
• NYC Citywide Annualized Calendar (Property) Sales OpenData Dataset as .xls (listed as .csv)
• Modified Zip Code Tabulation Areas (MODZCTA) OpenData Dataset as .geojson
• 2014 - 2015 DOE High School Directory OpenData Dataset as .csv

Results:

See notebook.

Resources:

• NYC OpenData Database Website
• NYC DOE School District Map Tool

Statistical Faults:

See final section of notebook