HI,
If the dataset is similar to this:
dat1<- read.table(text="
cu.nr. name value
A 1 Evo 100
B 1 Mer 80
C 2 Ford 50
",sep="",header=TRUE,stringsAsFactors=F)
dat2<- read.table(text="
cu.nr. name value2 value3
A 33 Evo 60 120
B 1 Mer 40 90
C 1 Pold 20 30
",sep="",header=TRUE,stringsAsFactors=F)
library(plyr)
join(dat1,subset(dat2,select=c("cu.nr.","name")),by=c("cu.nr.","name"),type="right")
# cu.nr. name value
#1 33 Evo NA
#2 1 Mer 80
#3 1 Pold NA
#or
join(dat1,dat2[,c("cu.nr.","name")],by=c("cu.nr.","name"),type="right")
A.K.
----- Original Message -----
From: Mat <matthias.we...@fnt.de>
To: r-help@r-project.org
Cc:
Sent: Thursday, February 14, 2013 2:03 AM
Subject: Re: [R] match in dependence of 2 columns
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.
______________________________________________
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.
