Dear R-Helpers, I have following problem: I do have two data frames dat1 and dat2 with a commen column BNUM (long integer). dat1 has a larger number of BNUM than dat2 and different rows of dat2 have equal BNUM. The numbers of rows in dat1 and dat2 is not equal. I applied the tapply-function to dat2 with BNUM as index. I would like to add the columns from dat1 to the results of b.sum <- tapply(dat2, BNUM, sum). However the BNUM of b.sum are only a subset of the dat1. Does anybody knows a elegant way to solve the problem? Thanks in advance Thomas H.
merging dataframes with diffent rownumbers
3 messages · Thomas Hoffmann, Michael Dewey, Petr Klasterecky
At 09:09 18/06/2007, Thomas Hoffmann wrote:
Dear R-Helpers, I have following problem: I do have two data frames dat1 and dat2 with a commen column BNUM (long integer). dat1 has a larger number of BNUM than dat2 and different rows of dat2 have equal BNUM. The numbers of rows in dat1 and dat2 is not equal. I applied the tapply-function to dat2 with BNUM as index. I would like to add the columns from dat1 to the results of b.sum <- tapply(dat2, BNUM, sum). However the BNUM of b.sum are only a subset of the dat1. Does anybody knows a elegant way to solve the problem?
If I understand you correctly ?merge should help you here
Thanks in advance Thomas H.
Michael Dewey http://www.aghmed.fsnet.co.uk
No easy to understand what exactly you mean, but try ?merge ?cbind ?rbind Petr Thomas Hoffmann napsal(a):
Dear R-Helpers, I have following problem: I do have two data frames dat1 and dat2 with a commen column BNUM (long integer). dat1 has a larger number of BNUM than dat2 and different rows of dat2 have equal BNUM. The numbers of rows in dat1 and dat2 is not equal. I applied the tapply-function to dat2 with BNUM as index. I would like to add the columns from dat1 to the results of b.sum <- tapply(dat2, BNUM, sum). However the BNUM of b.sum are only a subset of the dat1. Does anybody knows a elegant way to solve the problem? Thanks in advance Thomas H.
______________________________________________ R-help at stat.math.ethz.ch mailing list 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.
Petr Klasterecky Dept. of Probability and Statistics Charles University in Prague Czech Republic