Also see the sqldf package which lets you do this using SQL within R. http://sqldf.googlecode.com
On Sun, Feb 15, 2009 at 3:43 PM, Peter Dalgaard <p.dalga...@biostat.ku.dk> wrote: > Vincze Orsolya wrote: >> >> Dear all,I had just started to learn R. So my question may sound a bit >> stupid for you. >> Is that possible to match and merge two tables in R? I mean I have two >> tables, in the first I have two columns: RING NUMBER, WEIGHT and CAPTURE > > Err, ... for large values of "two"? Or is one of the three a rowname? > >> DATE, in the second RING NUMBER, SEX and CAPTURE DATE. >> 1) First I want to see, if to the ring numbers are the same, the capture >> dates are too? >> 2) And second if ring numbers are the same, to import the sex from the >> second table in the first. >> >> Is that possible? > > Yes. It's a job for merge() > > -- > 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.dalga...@biostat.ku.dk) FAX: (+45) 35327907 > > ______________________________________________ > 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. > ______________________________________________ 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.
