Excel to Interactive Census Map
I have been experimenting with spatial data and looking at ways to combine data objects to get different views and perspectives. This post has the following objectives: Import and load data direct to R without manually saving files to a local directory, so that the end to end process is reproducible. Use vectors to efficiently clean the Excel sheet, reducing manual steps where possible so that the process could be leveraged to clean other Excel sheets in the Census data.