Is this what you want: > x1$names <- rownames(x1) > x1 Apples Oranges Pears names A 5 6 7 A B 5 3 4 B C 8 9 10 C D 11 13 14 D E 15 3 8 E F 1 4 5 F > x2$names <- rownames(x2) > x2 Apples Oranges Pears names A 5 3 9 A B 3 2 1 B C 3 4 5 C E 8 1 4 E G 3 2 1 G > merge(x1, x2, by='names', all=TRUE) names Apples.x Oranges.x Pears.x Apples.y Oranges.y Pears.y 1 A 5 6 7 5 3 9 2 B 5 3 4 3 2 1 3 C 8 9 10 3 4 5 4 D 11 13 14 NA NA NA 5 E 15 3 8 8 1 4 6 F 1 4 5 NA NA NA 7 G NA NA NA 3 2 1 >
On Fri, Jan 8, 2010 at 4:21 PM, MRKidd <clistkorae...@yahoo.com> wrote: > > Let's say that I have a bunch of matrices. > > They look like this (pardon using fruit for examples, my actual data tables > are far too enormous): > > Matrix1 > > Apples Oranges Pears > A 5 6 7 > B 5 3 4 > C 8 9 10 > D 11 13 14 > E 15 3 8 > F 1 4 5 > > > Matrix2 > > Apples Oranges Pears > A 5 3 9 > B 3 2 1 > C 3 4 5 > E 8 1 4 > G 3 2 1 > > > I cannot use cbind or rbind, because I have different rows in each matrix > (e.g. - F & D are missing for Matrix2 and G is missing from Matrix1). > > What I would like to have in the end is this > > Apples Oranges Pears Apples Oranges Pears > A 5 6 7 5 3 9 > B 5 3 4 3 2 1 > C 8 9 10 3 4 5 > D 11 13 14 NA NA NA > E 15 3 8 8 1 4 > F 1 4 5 NA NA NA > G NA NA NA 3 2 1 > > I have experimented with the merge() cmd, but my trial and error efforts > have failed miserably. If anyone knows of a way to combine these matrices > other than manually editing them together, please let me know. > > p.s. > The way I have organized the matrices is such that they all have the same > column names. So Matrix 1 and Matrix 2 will have the exact same column > names > - but I want the newly combined matrix to keep the columns separate. So, as > in my final example, there would be one column titled "Apples" for each > Matrix that I add in. > > > -- > View this message in context: > http://n4.nabble.com/How-to-Merge-based-on-Rows-tp1010000p1010000.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > R-help@r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide > http://www.R-project.org/posting-guide.html<http://www.r-project.org/posting-guide.html> > and provide commented, minimal, self-contained, reproducible code. > -- Jim Holtman Cincinnati, OH +1 513 646 9390 What is the problem that you are trying to solve? [[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org 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.
