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.ran...@gmail.com> To: r-help@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@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. ______________________________________________ R-help@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.
