with the new information we have on those two final health indicators (#91 #95 ) we should be able to wrap things up. Work is very simple now with the new clean spreadsheets.
PUMA
The only wrinkle in this work is the casting from CD provided in the spreadsheet into pumas. Our community_district_to_PUMA works but it takes additional steps to format the CD column into the borough code + digit(s). Also since the information is actually provided on PUMA level just rewrapped as CDs, a drop duplicate is needed to get to the final puma output. I did spot checks for all duplicate puma and results seem fine.
Improvement
The two functions for each indicators are largely identical since they all come from identical spreadsheets. I can make arguments for both sides to either keep as it is for easy to access from the export function or reduce redundancy in this file.
Overview
with the new information we have on those two final health indicators (#91 #95 ) we should be able to wrap things up. Work is very simple now with the new clean spreadsheets.
PUMA
The only wrinkle in this work is the casting from CD provided in the spreadsheet into pumas. Our
community_district_to_PUMAworks but it takes additional steps to format the CD column into the borough code + digit(s). Also since the information is actually provided on PUMA level just rewrapped as CDs, a drop duplicate is needed to get to the final puma output. I did spot checks for all duplicate puma and results seem fine.Improvement
The two functions for each indicators are largely identical since they all come from identical spreadsheets. I can make arguments for both sides to either keep as it is for easy to access from the export function or reduce redundancy in this file.