[R] Finding values in one column and

[arun]

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.