Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ACS5 income missing many values in 2015 #114

Open
ppolonik2 opened this issue Mar 17, 2022 · 2 comments
Open

ACS5 income missing many values in 2015 #114

ppolonik2 opened this issue Mar 17, 2022 · 2 comments

Comments

@ppolonik2
Copy link

Hello,

When I try to download median income ('B06011_001E') for 2015 there are tons of missing values. Here is an example using California ('06') tracts, but this happens in other states too.

from census import Census
c = Census("<KEY>",year=2015)
outst = c.acs5.get(('B01003_001E','B06011_001E'),{'for':'tract:*','in':'state:06 county:*'})
inc = pd.DataFrame([o['B06011_001E'] for o in outst])
np.sum(np.isnan(inc))

This returns 2611 NaNs for me, out of 8057 tracts. The same is not true for total population (the other variable here). And the same is not true when changing the year to any other year in 2010-2019.

I'd appreciate any insight! Thanks!

@ppolonik2
Copy link
Author

Still hoping someone will look into this. I like this package but randomly missing data seems like a big problem.

@nvenkat94
Copy link

It give correct data. this is api endpoint for 2015 https://api.census.gov/data/2015/acs/acs5?for=tract:*&in=state:06&get=NAME,GEO_ID,B06011_001E. I think you had checked otherthan 2015. 2021 has more data than 2015.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants