[R] Finding values in one column and

Steven Ranney steven.ranney at gmail.com
Tue Nov 27 23:28:57 CET 2012


Thanks.

Soon after I posted this question, I discovered merge().

Steven H. Ranney


On Tue, Nov 27, 2012 at 3:26 PM, John Kane <jrkrideau at inbox.com> wrote:
> Have a look at ?merge
>
> John Kane
> Kingston ON Canada
>
>
>> -----Original Message-----
>> From: steven.ranney at gmail.com
>> Sent: Tue, 27 Nov 2012 15:17:58 -0700
>> To: r-help at r-project.org
>> 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.
>
> ____________________________________________________________
> Publish your photos in seconds for FREE
> TRY IM TOOLPACK at http://www.imtoolpack.com/default.aspx?rc=if4
>
>




More information about the R-help mailing list