Dear Dennis, Thank you for your reply. I can use the dplyr/data.table packages to aggregate - its the matching FIPS codes to their states that I am having trouble. Thanks again. Sincerely, Milu On Sun, May 1, 2016 at 6:20 PM, Dennis Murphy <djmuser at gmail.com> wrote:> Hi: > > Several such packages exist. Given the size of your data, it's likely > that the dplyr and data.table packages would be worth investigating. > Both are well documented. > > Dennis > > On Sun, May 1, 2016 at 8:30 AM, Miluji Sb <milujisb at gmail.com> wrote: > > Dear all, > > > > I have the following data by US FIPS code. Is there a package to > aggregate > > the data by State and Census divisions? > > > > temp <- dput(head(pop1,5)) > > structure(list(FIPS = c("01001", "01003", "01005", "01007", "01009" > > ), death_2050A1 = c(18.19158, 101.63088, 13.18896, 10.30068, > > 131.91798), death_2050A2 = c(22.16349, 116.58387, 15.85324, 12.78564, > > 155.20506), death_2050B1 = c(21.38906, 76.23018, 21.38218, 17.14269, > > 151.64466), death_2050B2 = c(23.43543, 81.39378, 22.96802, 18.76926, > > 161.86404), death_2050BC = c(21.89947, 93.88002, 18.60352, 15.1032, > > 152.43414)), .Names = c("FIPS", "death_2050A1", "death_2050A2", > > "death_2050B1", "death_2050B2", "death_2050BC"), row.names = c(NA, > > 5L), class = "data.frame") > > > > Thank you! > > > > Sincerely, > > > > Milu > > > > [[alternative HTML version deleted]] > > > > ______________________________________________ > > R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see > > https://stat.ethz.ch/mailman/listinfo/r-help > > PLEASE do read the posting guide > http://www.R-project.org/posting-guide.html > > and provide commented, minimal, self-contained, reproducible code. >[[alternative HTML version deleted]]
David Winsemius
2016-May-01 19:52 UTC
[R] Aggregate FIPS data to State and Census divisions
> On May 1, 2016, at 9:30 AM, Miluji Sb <milujisb at gmail.com> wrote: > > Dear Dennis, > > Thank you for your reply. I can use the dplyr/data.table packages to > aggregate - its the matching FIPS codes to their states that I am having > trouble. Thanks again.So post some example code that demonstrate you paid attention to the answer given. Both dplyr and data.table not limited for aggregation. They do several versions of matching. So does the base function `merge`. We do not yet know what sort of efforts you have made. r-help at r-project.org is not an online code-writing service. -- David> > Sincerely, > > Milu > > On Sun, May 1, 2016 at 6:20 PM, Dennis Murphy <djmuser at gmail.com> wrote: > >> Hi: >> >> Several such packages exist. Given the size of your data, it's likely >> that the dplyr and data.table packages would be worth investigating. >> Both are well documented. >> >> Dennis >> >> On Sun, May 1, 2016 at 8:30 AM, Miluji Sb <milujisb at gmail.com> wrote: >>> Dear all, >>> >>> I have the following data by US FIPS code. Is there a package to >> aggregate >>> the data by State and Census divisions? >>> >>> temp <- dput(head(pop1,5)) >>> structure(list(FIPS = c("01001", "01003", "01005", "01007", "01009" >>> ), death_2050A1 = c(18.19158, 101.63088, 13.18896, 10.30068, >>> 131.91798), death_2050A2 = c(22.16349, 116.58387, 15.85324, 12.78564, >>> 155.20506), death_2050B1 = c(21.38906, 76.23018, 21.38218, 17.14269, >>> 151.64466), death_2050B2 = c(23.43543, 81.39378, 22.96802, 18.76926, >>> 161.86404), death_2050BC = c(21.89947, 93.88002, 18.60352, 15.1032, >>> 152.43414)), .Names = c("FIPS", "death_2050A1", "death_2050A2", >>> "death_2050B1", "death_2050B2", "death_2050BC"), row.names = c(NA, >>> 5L), class = "data.frame") >>> >>> Thank you! >>> >>> Sincerely, >>> >>> Milu >>> >>> [[alternative HTML version deleted]] >>> >>> ______________________________________________ >>> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see >>> https://stat.ethz.ch/mailman/listinfo/r-help >>> PLEASE do read the posting guide >> http://www.R-project.org/posting-guide.html >>> and provide commented, minimal, self-contained, reproducible code. >> > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code.David Winsemius Alameda, CA, USA