search

cristinafurlong / roadscholarnyc

map platform for NYC school pedestrian safety
0 stars 0 forks source link

Problem with demographic data #1

Open cristinafurlong opened 9 years ago

cristinafurlong commented 9 years ago

The data we downloaded from this page includes four years, and we just want to use the last school year. http://schools.nyc.gov/Accountability/data/default.htm

jueyang commented 9 years ago

Actual link to data: http://schools.nyc.gov/NR/rdonlyres/77954FB0-FD24-476B-AB81-3E9BBE8655D9/183200/DemographicSnapshot201011to201415Public_FINAL.xlsx

We need: the most recent year (aka, the last data row of each school). Working on a script that would eliminate the first three rows of respective schools.

jueyang commented 9 years ago

Here's the dropbox link to the dataset that has only 2014-15 enrollment. You should be able to join this with the school location based on the DBN (in the school points dataset, it is the ats_code column).

https://www.dropbox.com/s/wr1i3fkupld082q/enrollment_2014.csv?dl=0

To use CartoDB for joining and merging data, follow the tutorial on this link:

http://docs.cartodb.com/tutorials/merging_data.html

You don't have to write SQL following the tutorial above. If you prefer writing SQL, check out this tutorial instead:

http://docs.cartodb.com/tutorials/joining_data.html