[acs-r] Creating 3-digit ZCTA data

[Campbell, Ron (NBCUniversal)]

I’m sure there’s a simple answer to this. My attempts so far have crashed and burned.

I’m trying to create ACS estimates of population from Table B01003 for 3-digit ZCTAs nationwide. I need these as a basis for measuring per capita rates of some other data that is available only at the 3-digit ZCTA level.

I have a data frame of 33,000 5-digit ZCTAs with total estimated population, the margin of error and the 3-digit ZCTA (a substring of the 5-digit ZCTA). I want to create a new data frame consisting of 3-digit ZCTAs with their estimated populations and margin of error.

I tried to do this using variations on the geo.make() function:

> census2 = geo.make(substring(census1$ZCTA5,1,3))
Error: evaluation nested too deeply: infinite recursion / options(expressions=)?

And

> census2 = geo.make(census1, combine=TRUE, combine.term='ZCTA3')
Error in (function (us, region, division, state, county, county.subdivision,  :
  (list) object cannot be coerced to type 'double'

Any ideas?

Thanks.

Ronald Campbell
Data Editor
NBC Owned Television Stations
1411 N. Batavia St., Suite 113
Orange, CA 92867
cell: 818-232-2585
ron.campbell at nbcuni.com<mailto:ron.campbell at nbcuni.com>
@campbellronaldw

[cid:52D6227E-0DE0-49AE-8C1C-A333D62934F6]
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.mit.edu/pipermail/acs-r/attachments/20170321/1b428c46/attachment.html
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 7C556B6E-DC38-4F5E-BDFC-D1CD239B18AD[8].png
Type: image/png
Size: 6496 bytes
Desc: 7C556B6E-DC38-4F5E-BDFC-D1CD239B18AD[8].png
Url : http://mailman.mit.edu/pipermail/acs-r/attachments/20170321/1b428c46/attachment.png