Message-ID: <1360934119.39016.YahooMailNeo@web142605.mail.bf1.yahoo.com>
Date: 2013-02-15T13:15:19Z
From: arun
Subject: match a task No. to a few person-IDs
In-Reply-To: <1360921526818-4658646.post@n4.nabble.com>
Hi,
Try this:
dat1<- read.table(text="
????? Task_No????? Team??
A??? 49397??????? 1????????
B??? 49396??????? 1
",sep="",header=TRUE)
dat2<- read.table(text="
??? ID??????? Team
A 5019??? 1
B 472??? 1
C 140??? 1
D 5013??? 1
",sep="",header=TRUE)
?res1<- as.matrix(merge(dat1,dat2,by="Team"))
?row.names(res1)<-LETTERS[match(res1[,2],dat1[,1])]?
library(plyr)
res2<- as.matrix(join(dat1,dat2,by="Team"))
?row.names(res2)<-LETTERS[match(res2[,1],dat1[,1])]
?res2
#? Task_No Team?? ID
#A?? 49397??? 1 5019
#A?? 49397??? 1? 472
#A?? 49397??? 1? 140
#A?? 49397??? 1 5013
#B?? 49396??? 1 5019
#B?? 49396??? 1? 472
#B?? 49396??? 1? 140
#B?? 49396??? 1 5013
A.K.
----- Original Message -----
From: Mat <matthias.weber at fnt.de>
To: r-help at r-project.org
Cc:
Sent: Friday, February 15, 2013 4:45 AM
Subject: [R] match a task No. to a few person-IDs
hello together,
i have a task No. in a data.frame
? ? ? Task_No? ? ? Team? ?
A? ? 49397??? ? ? 1??? ? ? ?
B? ? 49396??? ? ? 1? ???
and now i want to match my Person-IDs to each Task_No. My Person Ids look
like this one:
? ? ID? ? ? ? Team
A 5019??? 1
B 472??? 1
C 140??? 1
D 5013??? 1
The solution should be this:
? ? ? Task_No? ? ? Team? ? ID
A? ? 49397??? ? ? 1??? ? ? ? ? ? 5019
A? ? 49397??? ? ? 1??? ? ? ? ? ? 472
A? ? 49397??? ? ? 1??? ? ? ? ? ? 140
A? ? 49397??? ? ? 1??? ? ? ? ? ? 5013
B? ? 49396??? ? ? 1? ??? ? 5019
B? ? 49396??? ? ? 1? ? ? ? ? ? 472
B? ? 49396??? ? ? 1? ? ? ? ? ? 140
B? ? 49396??? ? ? 1? ? ? ? ? ? 5013
perhabs anyone can help me.
Thank you
Mat
--
View this message in context: http://r.789695.n4.nabble.com/match-a-task-No-to-a-few-person-IDs-tp4658646.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.