Hello Community,
I'm trying to create a file having US Census data from data.census.gov website. After going through the website, I have realized that there are separate tables for the demographic data that I'm looking for (The data to be retrieved is at a zip code level), such as, population, land area, number of houses, owned or rented property, mean income, etc. One way is to download separate files for each of these demographic variables, do a vlookup on the zip code and combine them, however, I'm trying to find a solution (if possible), to be able to pull to pull them together in a single file or from a single table. Could someone please let me know if such a solution exists?
Thank you!
Linking based on GeoID works but can be cumbersome. There are ways to write code to download the summary files and process them using a statistical package, or to use open-source tools to write code using…
Some other websites provide Census & ACS data in ways that make it easy to combine many tables in one file. The site I manage, IPUMS NHGIS, allows you to select any number of tables from a single dataset…
Linking based on GeoID works but can be cumbersome. There are ways to write code to download the summary files and process them using a statistical package, or to use open-source tools to write code using the API.
Summary files option: https://www.census.gov/programs-surveys/acs/library/handbooks/summary-file.html
Open source options: https://www.census.gov/programs-surveys/acs/guidance/statistical-software.html