I think you want this: merge(a,b, by = "d", all = FALSE)
Type ?merge to see all the options to merge available to you, Best, Michael On Mon, May 21, 2012 at 9:31 AM, Belay Gebregiorgis <belay...@gmail.com> wrote: > Hi Everyone, > > I am merging two data frames that have different number of rows. But I end > up having rows a lot more than both rows combined. I tried the following > but the duplicate bit does not change anything. Can anyone suggest to me > how I can handle this? > > Regards, > Belay > > > x <-c(1, 2, 3, 4,5, NA, NA,NA,NA,10) > y <-c( NA, 4,NA,5,2, 10, 7, 1, 8, 9) > d<-1:10 #### this one belongs to the data frame a > d<-1:5 #### this one belongs to the data frame b > s1<-1:5 > s2<-6:10 > > a<-data.frame(x,y,d) > b<- data.frame(s1,s2,d) > > c<-merge(a, b, by=c("d")) > > c[!duplicated(c[,c("x","y")]),] > > [[alternative HTML version deleted]] > > ______________________________________________ > 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. ______________________________________________ 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.