?merge If I have not reversed the data sets this should work With data sets called dat1 and dat2
merge(dat1,dat2, all.y = TRUE) John Kane Kingston ON Canada > -----Original Message----- > From: matthias.we...@fnt.de > Sent: Wed, 13 Feb 2013 06:39:57 -0800 (PST) > To: r-help@r-project.org > Subject: [R] match in dependence of 2 columns > > Hello, > > i want to match a column of one data.frame to another, my problem is, > that i > only want to match the data, if 2 columns are equal. > > i have a example: > > data.frame1 > cu.nr. name value > A 1 Evo 100 > B 1 Mer 80 > C 2 Ford 50 > > And now i want to match the value to data.frame 2 in dependence of cu.nr. > and name. > > data.frame2 > cu.nr. name > A 33 Evo > B 1 Mer > C 1 Pold > > as you can see, there is only one row with equal cu.nr. and name. How can > i > match the data as desired? > The solution has to look like this one: > > cu.nr. name Value > A 33 Evo > B 1 Mer 80 > C 1 Pold > > thanks. > > Mat > > > > -- > View this message in context: > http://r.789695.n4.nabble.com/match-in-dependence-of-2-columns-tp4658405.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > 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. ____________________________________________________________ FREE 3D EARTH SCREENSAVER - Watch the Earth right on your desktop! ______________________________________________ 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.
