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.
?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!
Hello,
Try the following.
data.frame1 <- read.table(text = "
cu.nr. name value
A 1 Evo 100
B 1 Mer 80
C 2 Ford 50
", header = TRUE)
data.frame2 <- read.table(text = "
cu.nr. name
A 33 Evo
B 1 Mer
C 1 Pold
", header = TRUE)
merge(data.frame2, data.frame1, all.x = TRUE)
Hope this helps,
Rui Barradas
Em 13-02-2013 14:39, Mat escreveu:> 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.
>
thank you, this code works:
library(plyr)
join(dat1,dat2,by=c("cu.nr.","name"),type="right")
but my dat2 frame has a lot of columns, which i don't want to match.
How can i say, that only the column "value" should be match to dat1 ?
Thank you.
Mat
--
View this message in context:
http://r.789695.n4.nabble.com/match-in-dependence-of-2-columns-tp4658405p4658508.html
Sent from the R help mailing list archive at Nabble.com.