Since there is some messiness to the situation due to 1. two indicators share the same columns with HUPRt now exists in both units_affordable and also rent_median so the final collate for output require to eliminate at least one 2. the mistake in the naming the HUPRt in the ami source data. There are essentially two steps taken to
Removing the units_renteroccu columns entirely from the units_affordable work entirely
add the pct and pct_moe columns into the rent_median
a little more details and explanations below for exactly what was done
units_affordable
apart from simply taking away, the biggest change in this part of the refactoring is also removing from the order_affordable function to ensure that the final columns ordering no longer has the units_renteroccu either.
rent_median
the only two steps required is first include the pct and pct_moe in the measurements given to the columns reordering functions to generate the appropriate and removing the dropna at the end to ensure they are included. Also two columns the total units_payingrent for 1519 are hardcoded to have 100 pct to impute values from ami source file.
Overview
Since there is some messiness to the situation due to 1. two indicators share the same columns with
HUPRtnow exists in bothunits_affordableand alsorent_medianso the final collate for output require to eliminate at least one 2. the mistake in the naming theHUPRtin the ami source data. There are essentially two steps taken tounits_renteroccucolumns entirely from theunits_affordablework entirelyrent_mediana little more details and explanations below for exactly what was done
units_affordableapart from simply taking away, the biggest change in this part of the refactoring is also removing from the
order_affordablefunction to ensure that the final columns ordering no longer has theunits_renteroccueither.rent_medianthe only two steps required is first include the
pctandpct_moein the measurements given to the columns reordering functions to generate the appropriate and removing thedropnaat the end to ensure they are included. Also two columns the totalunits_payingrentfor 1519 are hardcoded to have 100 pct to impute values from ami source file.