Stack Overflow
Stack Overflow

Questions tagged [census]

187 questions
1
vote
1 answer

How can I convert FIPS Code to GISJOIN for census tracts

I have two datasets from two different agencies that report census tracts in two different ways, namely FIPSCode and GISJOIN. I have to frequently interchange these two and hence looking for a way to see if anyone knows how to effectively do it as…
Tathagato
  • 348
  • 1
  • 11
1
vote
1 answer

Calculate new sums/values for a column based on field name patterns in R

I'm working with census data and I need to calculate total values based on a selection of block groups (rows) for a large number of fields that are grouped together with similar starting patterns. Unfortunately these new calculations aren't all sums…
Keren Crum
  • 11
  • 2
1
vote
0 answers

Combine All USA Block Group Census Shapefiles together

As the title suggests, I'm trying to load in all the SHP files from the Census found here (https://www2.census.gov/geo/tiger/TIGER2019/BG/), and merge them all together as 1 large shp file for the entire US overcoming issues with duplicate…
a_swoosh
  • 23
  • 7
1
vote
1 answer

SQL on US Census - Null values return

I am trying to get data from the US Census on SQL Server Studio for analysis (trade data at port level). I have downloaded a JSON file for now from their API (ideally, I will do a call from SQL studio later). I then read the file with OPEN ROW SET…
Alex
  • 13
  • 2
1
vote
0 answers

get_decennial() returns error for 2020 data?

I've been working with census data from 2000, 2010, and 2020 for a local geography. My pulls for 2000 and 2010 work with no problem, but I get an error when I try to pull 2020 data. vars = c("P001001", #Total population "H013001", #Total…
Nissim
  • 11
  • 1
1
vote
1 answer

Get US State for given location coordinates

I want to figure out which state a lat long belongs to. And for this I am using the shape files provided by US Census and shapely library. This is what I tried so far: import pandas as pd import geopandas as gpd from shapely.geometry import…
Ank
  • 1,864
  • 4
  • 31
  • 51
1
vote
0 answers

Question concerning merging American Community Survey person and household files in R using RStudio

I am interested in joining person and household data using the SERIALNO variable from the 2019 5-year ACS for Texas. Here is my code for this action using RStudio Version 1.4.1106: # Load Person and Household data for 2019 ACS pums2019pop <-…
Rafael Gonzalez
  • 11
  • 1
1
vote
1 answer

ACS 1 and 5-year block groups in tidycensus

Is block group level data available for the ACS 5-year survey before 2013 through the tidycensus R package? I am trying to collect consecutive years of population data for Gettysburg, PA, but I keep getting an error that block group level is an…
wellma01
  • 11
  • 1
1
vote
1 answer

Referring to returned output from function that splits up a dataframe

I'm trying to build a small program that uses the censusgeo package to interact with the US Census Bureau API address batch facility. The API has a limit of 10,000 addresses in any single call but my dataframe has approx. 3 million rows. As such I…
C.Robin
  • 1,085
  • 1
  • 10
  • 23
1
vote
1 answer

Census Goecoding Issue

I am trying to do a simple geocode operation that I have been able to do many times in the past. This simple code no longer works, because it returns this output. {'States': [], 'Counties': [], '2020 Census Blocks': [], 'Census Tracts': []}. What…
Data Science Acolyte
  • 195
  • 2
  • 15
1
vote
0 answers

How do I get census data of a particular zip code?

https://api.census.gov/data/2013/acs/acs5?get=NAME,B01001_001E&for=place:51000&in=state:36&key=key123 That is the query I attempted to use. I only get the data for New York City population, but I want the population of that zip code, and if…
darren z
  • 3,051
  • 3
  • 13
  • 28
1
vote
1 answer

Call Data Profile (DP) tables in r using acs package

I want to call the Data Profile tables in R using the acs package but I am not sure that it is possible. My code is below. I have used the code to call B tables with no problem. I think the issue is that I am not giving the correct information in…
knesse
  • 185
  • 1
  • 6
1
vote
1 answer

Census Data Using an API on R studio

So, I am new to using R, so sorry if the questions seem a little basic! But my work is asking me to look through census data using an API and identify some variables in each tract, then create a csv file they can look at. The code is fully written…
onedayatatime
  • 11
  • 3
1
vote
3 answers

Is there a way to rename the columns of a dataframe in r using another table that has the original and new column name?

I have data from ACS Census that has a metadata and tables with coded column names, I need to have the column names changed to the one in the metadata so it makes sense when read. Is there a way to replace the coded column name to actual by linking…
Pream
  • 517
  • 4
  • 10
1
vote
0 answers

FPC for Survey design in Brazilian Demographic Census 2010

So, I need to analyze data about Brazilian Censo 2010 using R, and I'm having troubles to use the survey package. At ASDF, you may see how Brazilian Censo data works: http://asdfree.com/brazilian-censo-demografico-censo.html But, there is this…
Igor Mendonça
  • 159
  • 9
1 2 3
…
12 13