Household indexing is confusing

[replicahq]

Household indexing is confusing

[alexeisw]

From a user perspective it'd be great to turn households['serial_number'] + '-' + households['repeat_index'] into a count. Then households['tract'] + '-' + household['count'] would give clear idea on the index/total number of synthetic HHs within a tract.

[alexeisw]

For persons, it'd be great to see a readable ID of 'Tract'-'HH_in_a_tract_idx'-'Person_in_a_household_idx'

[katbusch]

@alexeisw @DavidOry what do you think of just adding a column called household_id to both tables.
something like this:

households['household_id'] = households['tract'] + '-' + households['serial_number'] + '-' + households['repeat_index']
persons['household_id'] = persons['tract'] + '-' + persons['serial_number'] + '-' + persons['repeat_index']