NYCPlanning / db-equitable-development-tool

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

Change NAN to zero in `nycha_tenants` and `nycha_units` #280

Closed mbh329 closed 2 years ago

mbh329 commented 2 years ago

The source data for nycha_units indicator did not provide us with data for PUMA's that did not have nycha units so in the indicator level output there are only 40 pumas (rows of data). In the collate step, the values for the other non reported pumas populate as nan. This PR addresses those issues by filling the nans with zero, pretty simple stuff and used some already established processes (i.e. create empty dataframe of pumas and concat)