Hi, Russell, Here is a piece of code and you might need to tweak it a little. MERGE 2 DATA FRAMES####################################### # MERGE 2 DATA FRAMES: # # INNER JOIN, LEFT JOIN, RIGHT JOIN, # # FULL JOIN, & CARTESIAN PRODUCT # #######################################
data1<-data.frame(id1 = 1:10, x = rnorm(length(1:10))); data2<-data.frame(id2 = seq(1, 20, by = 2), y = rnorm(length(seq(1, 20, by = 2)))); # INNER JOIN inner.join<-merge(data1, data2, by.x = "id1", by.y = "id2"); # LEFT JOIN left.join<-merge(data1, data2, by.x = "id1", by.y = "id2", all.x = TRUE); # RIGHT JOIN right.join<-merge(data1, data2, by.x = "id1", by.y = "id2", all.y = TRUE); # FULL JOIN full.join<-merge(data1, data2, by.x = "id1", by.y = "id2", all = TRUE); # CARTESIAN PRODUCT cartesian<-merge(data1, data2); On 9/14/06, Geoff Russell <[EMAIL PROTECTED]> wrote: > > I have a table: > > C1 > RowName1 3 > RowName2 2 > > and another table: > > C2 > RowName1 5.6 > RowName1a 4.3 > RowName2 NA > > I want to join join the tables with matching rows: > > C1 C2 > RowName1 3 5.6 > RowName2 2 NA > > I'm thinking of something like: > > T1$C2=T2$C2[index-expression-to-pullout the matching ones] > > Any ideas would be appreciated. > > Cheers, > Geoff Russell > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help@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. > -- WenSui Liu (http://spaces.msn.com/statcompute/blog) Senior Decision Support Analyst Health Policy and Clinical Effectiveness Cincinnati Children Hospital Medical Center [[alternative HTML version deleted]] ______________________________________________ R-help@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.
