[R] Merge

[Farnoosh]

Thanks a lot:)

Sent from my iPad

On Apr 16, 2013, at 10:15 PM, arun <smartpink111 at yahoo.com> wrote:

> Hi Farnoosh,
> YOu can use either ?merge() or ?join()
> DataA<- read.table(text="
> ID     v1     
> 1     10
> 2     1 
> 3     22
> 4     15
> 5     3 
> 6     6 
> 7     8 
> ",sep="",header=TRUE)
> 
> DataB<- read.table(text="
> ID v2
> 2 yes
> 5 no
> 7 yes
> ",sep="",header=TRUE,stringsAsFactors=FALSE)
> 
> merge(DataA,DataB,by="ID",all.x=TRUE)
> #  ID v1   v2
> #1  1 10 <NA>
> #2  2  1  yes
> #3  3 22 <NA>
> #4  4 15 <NA>
> #5  5  3   no
> #6  6  6 <NA>
> #7  7  8  yes
>  library(plyr)
>  join(DataA,DataB,by="ID",type="left")
> #  ID v1   v2
> #1  1 10 <NA>
> #2  2  1  yes
> #3  3 22 <NA>
> #4  4 15 <NA>
> #5  5  3   no
> #6  6  6 <NA>
> #7  7  8  yes
> A.K.
> 
> 
> 
> 
> 
> ________________________________
> From: farnoosh sheikhi <farnoosh_81 at yahoo.com>
> To: "smartpink111 at yahoo.com" <smartpink111 at yahoo.com> 
> Sent: Wednesday, April 17, 2013 12:52 AM
> Subject: Merge
> 
> 
> 
> Hi Arun,
> 
> I want to merge a data set with another data frame with 2 columns and keep the sample size of the DataA.
> 
> DataA  DataB  DataCombine 
> ID v1  ID V2  ID v1 v2 
> 1 10  2 yes  1 10 NA 
> 2 1  5 no  2 1 yes 
> 3 22  7 yes  3 22 NA 
> 4 15     4 15 NA 
> 5 3     5 3 no 
> 6 6     6 6 NA 
> 7 8     7 8 yes 
> 
> 
> Thanks a lot for your help and time.