Message-ID: <1354056256.2298.YahooMailNeo@web142604.mail.bf1.yahoo.com>
Date: 2012-11-27T22:44:16Z
From: arun
Subject: Finding values in one column and
In-Reply-To: <CANDt99qDP83BfQi_6MbUeOOD3_79ChvJ8tdqf30vSRzaeoskjg@mail.gmail.com>
Hi,
Try ?merge(), ?join() from library(plyr)
data.a<-read.table(text="
ID??? valueA??? valueB
6??? 12??? 12
17??? 15??? 14
58??? 18??? 16
98??? 11??? 12
73??? 19??? 20
84??? 19??? 14
58??? 20??? 14
24??? 11??? 12
81??? 15??? 16
21??? 15??? 14
62??? 14??? 12
67??? 13??? 14
78??? 13??? 17
35??? 10??? 13
13??? 11??? 15
14??? 17??? 18
85??? 16??? 15
35??? 13??? 9
18??? 15??? 16
",sep="",header=TRUE)
data.b<-read.table(text="
ID??
6??????
84??????
21??????
78??????
14???????
",sep="",header=TRUE)
library(plyr)
join(data.a,data.b,by="ID",type="inner")
#? ID valueA valueB
#1? 6???? 12???? 12
#2 84???? 19???? 14
#3 21???? 15???? 14
#4 78???? 13???? 17
#5 14???? 17???? 18
A.K.
----- Original Message -----
From: Steven Ranney <steven.ranney at gmail.com>
To: r-help at r-project.org
Cc:
Sent: Tuesday, November 27, 2012 5:17 PM
Subject: [R] Finding values in one column and
All -
I have a data frame
data.a
ID??? valueA??? valueB
6??? 12??? 12
17??? 15??? 14
58??? 18??? 16
98??? 11??? 12
73??? 19??? 20
84??? 19??? 14
58??? 20??? 14
24??? 11??? 12
81??? 15??? 16
21??? 15??? 14
62??? 14??? 12
67??? 13??? 14
78??? 13??? 17
35??? 10??? 13
13??? 11??? 15
14??? 17??? 18
85??? 16??? 15
35??? 13??? 9
18??? 15??? 16
and a data frame
data.b
ID??? valueA??? valueB
6??? ???
84??? ???
21??? ???
78??? ???
14??? ???
I'd like to have R find the data.b$ID in data.a$ID and insert the
corresponding data.a$valueA and data.a$valueB into the appropriate
columns in data.b.
How can I do this?
Thanks for you help.
SR
Steven H. Ranney
______________________________________________
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.