[R] (no subject)

Peter Dalgaard P.Dalgaard at biostat.ku.dk
Mon Feb 16 17:06:07 CET 2009

```Uwe Ligges wrote:
>
>
> Vincze Orsolya wrote:
>> There are three columns, I was just careless.
>> I succeed to merge the two tables. But:
>> 1) in the first table there were rows, which were not present in the
>> second
>> table, these rows were deleted from the merged table too, but I need
>> them.
>> 2) If i want to import from the second table just a certain column,
>> not all
>> that is missing from the first, how can i do that?
>> 3) How can I save the generated table?
>>
>> Sorry about the banal questions.... I'm beginner.
>> And thanks for the help...
>> Have a nice day
>
>

What makes you think that, Uwe? I don't see a teacher asking merge()
questions to a rank beginner (I wouldn't).

1) look at the documentation: all.x=TRUE
2) use the usual subsetting mechanisms to work with only the relevant
set of columns, e.g. merge(x, y[,c(1,2,6)], ....)
3) assign using z <- merge(x,y,....), then save() (or maybe write.table())

-pd

>>
>> 2009/2/15 Peter Dalgaard <p.dalgaard at biostat.ku.dk>
>>
>>> 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
>>>
>>
>>     [[alternative HTML version deleted]]
>>
>>
>>
>> ------------------------------------------------------------------------
>>
>> ______________________________________________
>> R-help at r-project.org mailing list
>> https://stat.ethz.ch/mailman/listinfo/r-help
>> http://www.R-project.org/posting-guide.html
>> and provide commented, minimal, self-contained, reproducible code.
>
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.

--
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

```