Message-ID: <1360867204.90290.YahooMailNeo@web142601.mail.bf1.yahoo.com>
Date: 2013-02-14T18:40:04Z
From: arun
Subject: match in dependence of 2 columns
In-Reply-To: <1360825417356-4658508.post@n4.nabble.com>
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.weber at fnt.de>
To: r-help at 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 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.