Skip to content

match in dependence of 2 columns

3 messages · Mat, Rui Barradas, arun

Mat
# 
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.
Rui Barradas
# 
Hello,

You can do something like this:


join(dat1, dat2[, c("cu.nr", "name", "value")], 
by=c("cu.nr.","name"),type="right")


Hope this helps,

Rui Barradas
Em 14-02-2013 07:03, Mat escreveu:
arun
# 
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.