Re: [R] Finding values in one column and

2012-11-28 Thread Berend Hasselman
On 28-11-2012, at 08:00, Berend Hasselman wrote: > . >> 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? > > > data.b <- data.a[which(data.a$ID %in% data.b$

Re: [R] Finding values in one column and

2012-11-27 Thread Berend Hasselman
On 27-11-2012, at 23:17, Steven Ranney wrote: > All - > > I have a data frame > > data.a > IDvalueA valueB > 6 12 12 > 1715 14 > 5818 16 > 9811 12 > 7319 20 > 8419 14 > 5820 14 > 2411 12 > 8115 16 > 2115

Re: [R] Finding values in one column and

2012-11-27 Thread Steven Ranney
(joins) I think the data.table package is > much faster. > > John Kane > Kingston ON Canada > > >> -Original Message- >> From: steven.ran...@gmail.com >> Sent: Tue, 27 Nov 2012 15:28:57 -0700 >> To: jrkrid...@inbox.com >> Subject: Re: [R] Fin

Re: [R] Finding values in one column and

2012-11-27 Thread John Kane
:57 -0700 > To: jrkrid...@inbox.com > Subject: Re: [R] Finding values in one column and > > Thanks. > > Soon after I posted this question, I discovered merge(). > > Steven H. Ranney > > > On Tue, Nov 27, 2012 at 3:26 PM, John Kane wrote: >> Have a look

Re: [R] Finding values in one column and

2012-11-27 Thread arun
t;,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 To: r-help@r-project.org Cc: Sent: Tuesday, November 27, 2012 5:17 PM Subject: [R] Findi

Re: [R] Finding values in one column and

2012-11-27 Thread Steven Ranney
> Sent: Tue, 27 Nov 2012 15:17:58 -0700 >> To: r-help@r-project.org >> Subject: [R] Finding values in one column and >> >> All - >> >> I have a data frame >> >> data.a >> IDvalueA valueB >> 6 12 12 >> 1715

Re: [R] Finding values in one column and

2012-11-27 Thread John Kane
Have a look at ?merge John Kane Kingston ON Canada > -Original Message- > From: steven.ran...@gmail.com > Sent: Tue, 27 Nov 2012 15:17:58 -0700 > To: r-help@r-project.org > Subject: [R] Finding values in one column and > > All - > > I have a data frame

[R] Finding values in one column and

2012-11-27 Thread Steven Ranney
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