Hello all, Apologize for the newbie question. What's the easiest way to do a SQL inner table join in R? Say I have a table containing column names A, B, C and another which has columns named C, D, E. I would like to do an inner table join on C and produce a table A, B, C, D, E. thanks a lot, N. -- View this message in context: http://www.nabble.com/THE-EQUIVALENT-OF-SQL-INNER-TABLE-JOIN-IN-R-tp23238179p23238179.html Sent from the R help mailing list archive at Nabble.com.
1. ?merge 2. sqldf package whose home page is at: http://sqldf.googlecode.com On Sat, Apr 25, 2009 at 9:15 PM, Nigel Birney <nan23 at cam.ac.uk> wrote:> > Hello all, > > Apologize for the newbie question. What's the easiest way to do a SQL inner > table join in R? > > Say I have a table containing column names A, B, C and another which has > columns named C, D, E. I would like to do an inner table join on C and > produce a table A, B, C, D, E. > > thanks a lot, > > N. > -- > View this message in context: http://www.nabble.com/THE-EQUIVALENT-OF-SQL-INNER-TABLE-JOIN-IN-R-tp23238179p23238179.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > R-help at 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. >
Nigel Birney wrote:> Hello all, > > Apologize for the newbie question. What's the easiest way to do a SQL inner > table join in R? > > Say I have a table containing column names A, B, C and another which has > columns named C, D, E. I would like to do an inner table join on C and > produce a table A, B, C, D, E.merge(), perhaps? Otherwise describe what an inner table join does. -pd -- O__ ---- Peter Dalgaard ?ster Farimagsgade 5, Entr.B c/ /'_ --- Dept. of Biostatistics PO Box 2099, 1014 Cph. K (*) \(*) -- University of Copenhagen Denmark Ph: (+45) 35327918 ~~~~~~~~~~ - (p.dalgaard at biostat.ku.dk) FAX: (+45) 35327907