[R] match in dependence of 2 columns

[John Kane]

?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.weber at fnt.de
> Sent: Wed, 13 Feb 2013 06:39:57 -0800 (PST)
> To: r-help at 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 at 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!