franziskatoll
commented
2 months ago - [x] Download the data as a xlsx
- [x] insert data to VSCode for borough and whole NYC
- [x] clean data
- [x] concat boroughs and whole NYC
- [x] upload to Server for everyone to use
- [x] load into Tableau
- [x] combine with crime data
Got the data via link from: Elena Volovelsky Principal Economist Labor Market Analyst – New York City Region New York State Department of Labor | Brooklyn elena.volovelsky@labor.ny.gov
https://dol.ny.gov/local-area-unemployment-statistics
Scroll down past the Tableau dashboard to the bottom of the page - it's the laus.zip file that's linked at the very end. In the unzipped archive, open the Excel spreadsheet and filter for the values you need - the boroughs are on the first tab of the spreadsheet (Bronx, Kings, New York, Queens, Richmond are the official names for the boroughs). For the NYC as a whole, switch to the second tab and filter for New York City.