Thanks a lot:) Sent from my iPad
On Apr 16, 2013, at 10:15 PM, arun <smartpink...@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...@yahoo.com> > To: "smartpink...@yahoo.com" <smartpink...@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. ______________________________________________ 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.
