
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: r-help@r-project.org
> From: dwinsemius@comcast.net
> To: kristi.glover@hotmail.com
> 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]]

