[R] (no subject)

[Gabor Grothendieck]

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.dalgaard at 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.dalgaard at biostat.ku.dk)              FAX: (+45) 35327907
>
> ______________________________________________
> 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.
>