Thanks David,
I tried 'cbind" as you suggested: but did not work. Here are the example
> T1=matrix(1:16, ncol=4)
> rownames(T1)=rep(c("A","B","C","D"))
> colnames(T1)=rep(c("X","Y","Z","XX"))
> T2=matrix(1:9, ncol=3)
> rownames(T2)=rep(c("A1","B1","C1"))
> colnames(T2)=rep(c("X","Y","XX"))
> T1
X Y Z XX
A 1 5 9 13
B 2 6 10 14
C 3 7 11 15
D 4 8 12 16
> T2
X Y XX
A1 1 4 7
B1 2 5 8
C1 3 6 9
> T1T2<-cbind(T1,T2)
Error in cbind(T1, T2) :
number of rows of matrices must match (see arg 2)
I want to have the following table (probably you noticed that column Z in Table
1 is not in Table 2)
X Y XX
A 1 5 13
B 2 6 14
C 3 7 15
D 4 8 16
A1 1 4 7
B1 2 5 8
C1 3 6 9
any suggestions? this is just an example, I have very big files (~1700 columns,
and ~2500 rows)
Kristi
> CC: [email protected]
> From: [email protected]
> To: [email protected]
> Subject: Re: [R] Combine two tables by row with different columns
> Date: Wed, 9 May 2012 21:47:48 -0400
>
>
> On May 9, 2012, at 9:21 PM, Kristi Glover wrote:
>
> >
> > Hi R user,
> > I could not combine two tables. Would any one help me on how I can
> > combine with following example tables?
>
> You do realize that tables in R are not dataframes. They are a type of
> matrix.
>
> >
> >> T1
> > X Y Z XX
> > A 1 5 9 13
> > B 2 6 10 14
> > C 3 7 11 15
> > D 4 8 12 16
> >
> >> T2
> > X Y XX
> > a 1 4 7
> > b 2 5 8
> > c 3 6 9
> >
> > I want to get the following table
> > cT
> > X Y XX
> > A 1 5 13
> > B 2 6 14
> > C 3 7 15
> > D 4 8 16
> > A1 1 4 7
> > B1 2 5 8
> > C1 3 6 9
>
> Assuming you will accept the rownames as they stand, then try this:
>
> cT <- cbind(T1,T2) # works for table, matrices, and dataframes
>
> >
> > [[alternative HTML version deleted]]
> Plain text, please.
>
> --
> David Winsemius, MD
> West Hartford, CT
>
[[alternative HTML version deleted]]
______________________________________________
[email protected] 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.
