Re: [R] Doubt in simple merge

2014-01-17 Thread PIKAL Petr
-Original Message- From: r-help-boun...@r-project.org [mailto:r-help-bounces@r- project.org] On Behalf Of kingsly Sent: Friday, January 17, 2014 6:14 AM To: r-help@r-project.org Subject: Re: [R] Doubt in simple merge Thank you dear friends. You have cleared my first doubt. My second

Re: [R] Doubt in simple merge

2014-01-17 Thread Marc Schwartz
On Jan 16, 2014, at 11:14 PM, kingsly ecoking...@yahoo.co.in wrote: Thank you dear friends. You have cleared my first doubt. My second doubt: I have the same data sets Elder and Younger. Elder - data.frame( ID=c(ID1,ID2,ID3), age=c(38,35,31)) Younger - data.frame(

[R] Doubt in simple merge

2014-01-16 Thread kingsly
Dear R community I have a two data set called Elder and Younger. This is my code for simple merge. Elder - data.frame(   ID=c(ID1,ID2,ID3),   age=c(38,35,31)) Younger - data.frame(   ID=c(ID4,ID5,ID3),   age=c(29,21,31)) mer - merge(Elder,Younger,by=ID, all=T) Output I am expecting: ID 

Re: [R] Doubt in simple merge

2014-01-16 Thread Adams, Jean
You are telling it to merge by ID only. But it sounds like you would like it to merge by both ID and age. merge(Elder, Younger, all=TRUE) Jean On Thu, Jan 16, 2014 at 6:25 AM, kingsly ecoking...@yahoo.co.in wrote: Dear R community I have a two data set called Elder and Younger. This is

Re: [R] Doubt in simple merge

2014-01-16 Thread Frede Aakmann Tøgersen
No I think the OP wants mer - merge(Elder, Younger) Br. Frede Oprindelig meddelelse Fra: Adams, Jean Dato:16/01/2014 15.45 (GMT+01:00) Til: kingsly Cc: R help Emne: Re: [R] Doubt in simple merge You are telling it to merge by ID only. But it sounds like you would like

Re: [R] Doubt in simple merge

2014-01-16 Thread Frede Aakmann Tøgersen
Ups, sorry that should have been mer - rbind(Elder, Younger) /frede Oprindelig meddelelse Fra: Frede Aakmann Tøgersen Dato:16/01/2014 15.54 (GMT+01:00) Til: Adams, Jean ,kingsly Cc: R help Emne: Re: [R] Doubt in simple merge No I think the OP wants mer - merge(Elder

Re: [R] Doubt in simple merge

2014-01-16 Thread Marc Schwartz
meddelelse Fra: Frede Aakmann Tøgersen Dato:16/01/2014 15.54 (GMT+01:00) Til: Adams, Jean ,kingsly Cc: R help Emne: Re: [R] Doubt in simple merge No I think the OP wants mer - merge(Elder, Younger) Br. Frede Oprindelig meddelelse Fra: Adams, Jean Dato:16

Re: [R] Doubt in simple merge

2014-01-16 Thread kingsly
Thank you dear friends.  You have cleared my first doubt.   My second doubt: I have the same data sets Elder and Younger. Elder - data.frame(   ID=c(ID1,ID2,ID3),   age=c(38,35,31)) Younger - data.frame(   ID=c(ID4,ID5,ID3),   age=c(29,21,NA))  Row ID3 comes in both data set. It has a