Hello, a have two matrices of data as below. I would like to add-up the duplicate in terms of pair of names in rows, and then merge the values in the second matrix to the pairs as two new variables x3 and x4. Input ,x1,x2 jane.mike,31,43 jane.steve,32,2 jane.steve,5,3 jim.mike,76,5 jane.steve,4,4 mike.steve,54,7 mike.steve,5,7 jane.mike,7,8 and ,y jane,0.3 jim,0.4 mike,0.1 carl,0.5 john,0.9 steve,0.4 dirk,0.2 Output: ,x1,x2,x3,x4 jane.mike,38,51,0.3,0.1 jane.steve,41,9,0.3,0.4 jim.mike,76,5,0.4,0.1 mike.steve,59,14,0.1,0.4 Any help appreciated, Serguei [[alternative HTML version deleted]]
Hello, for the first task change the names if they are character into a factor and have a look at ?by For the merge you will need strsplit() on character vectors (so be carefull to change the factor back to character) and merge() Regards, Winfried -----Original Message----- From: r-help-bounces at stat.math.ethz.ch [mailto:r-help-bounces at stat.math.ethz.ch] On Behalf Of Serguei Kaniovski Sent: Monday, February 26, 2007 12:14 PM To: r-help at stat.math.ethz.ch Subject: [R] Add-up duplicates and merge Hello, a have two matrices of data as below. I would like to add-up the duplicate in terms of pair of names in rows, and then merge the values in the second matrix to the pairs as two new variables x3 and x4. Input ,x1,x2 jane.mike,31,43 jane.steve,32,2 jane.steve,5,3 jim.mike,76,5 jane.steve,4,4 mike.steve,54,7 mike.steve,5,7 jane.mike,7,8 and ,y jane,0.3 jim,0.4 mike,0.1 carl,0.5 john,0.9 steve,0.4 dirk,0.2 Output: ,x1,x2,x3,x4 jane.mike,38,51,0.3,0.1 jane.steve,41,9,0.3,0.4 jim.mike,76,5,0.4,0.1 mike.steve,59,14,0.1,0.4 Any help appreciated, Serguei [[alternative HTML version deleted]] ______________________________________________ R-help at stat.math.ethz.ch mailing list stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.