What do you want to happen when there are duplicates? A: ID X 1 a 2 b 3 c
B: ID Y 1 x 2 y 2 z What happens to ID 1? 2? 3? in your desired output? The all.x and all.y options might be of use. Sarah On Wed, Aug 25, 2010 at 8:00 AM, Mangalani Peter Makananisa <pmakanan...@sars.gov.za> wrote: > I want to merge data set A and B, by merge(A,B, by = "ID"), however I am > getting error massages, because the some ID's in A repeat themselves several > time in data set B. Even if the ID's in B repeat themselves I want to be able > to merge the two dataset and retrieve the intersection. > > Please help. > > -----Original Message----- > From: Sarah Goslee [mailto:sarah.gos...@gmail.com] > Sent: 25 August 2010 01:52 PM > To: Mangalani Peter Makananisa > Cc: r-help@r-project.org > Subject: Re: [R] Merging two data set in R, > > First you need to clarify what you'd like to happen when the ID in B > is not unique. What do you want the resulting dataframe to look > like? > > Some possible answers involve using different options for merge() or > using unique() to remove duplicates from B before merging. But > at least to me, "merge or retrieve the common ones" isn't clear > enough to be able to say which. > > Sarah > > On Wed, Aug 25, 2010 at 5:35 AM, Mangalani Peter Makananisa > <pmakanan...@sars.gov.za> wrote: >> Dear R Gurus, >> >> >> >> I am currently working on the two dataset ( A and B), they both have the >> same fields: ID , REGION, OFFICE, CSTART, CEND, NCYCLE, STATUS and >> CB. >> >> I want to merge the two data set by ID. The problem I have is that the >> in data A, the ID's are unique. However in the data set B, the ID's are >> not unique, thus some repeat themselves. >> >> >> >> How do I the merge or retrieve the common ones? >> >> Please advise. >> >> >> >> Kind Regards >> >> >> >> Peter >> > -- Sarah Goslee http://www.functionaldiversity.org ______________________________________________ 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.
