NYCPlanning / db-equitable-development-tool

Data Repo for the equitable development tool (EDDT)
MIT License
0 stars 0 forks source link

Add HSQ Indicators (housing tenure) from 2000 Census PUMS #226

Closed mbh329 closed 2 years ago

mbh329 commented 2 years ago

pums_2000_hsq_housing_tenure.py

Pretty straightforward script and very similar to the 2000_census_demographics and 2000_census_economic. Updated the tags to follow the newest conventions laid out in today's meeting with OSE. Moved the global dictionaries to convert DCP population race codes and stat suffix mappers and the load data step to the utils/dcp_population_excel_helpers.py. This script ONLY ingests/aggregates 2000 housing tenure PUMS data: occupied_units, occupied_units_owner, occupied_units_renter

aggregation_helpers.py

Updated this function to handle the newest tag conventions.

utils/dcp_population_excel_helpers.py As mentioned above, added two global dictionaries race_suffix_mapper which converts the convention DCP population uses in the column names to indicate race to the race suffix used for EDDT and converts the stat convention used by dcp population to our conventions (i.e. e to count)

internal_review Wrote files following what was laid out in the issue/epic for this indicator.

Things to check:

mbh329 commented 2 years ago

@SashaWeinstein Do I need to make any additional changes to the reordering? Based on your comments, I think everything is properly ordred?

mbh329 commented 2 years ago

I made a new commit to update a comment in the utils to avoid confusion