[R] Finding values in one column and

[Steven Ranney]

Once I figured out the syntax of join() with the plyr package, it
worked like a charm.

Thanks again.

SR
Steven H. Ranney


On Tue, Nov 27, 2012 at 3:49 PM, John Kane <jrkrideau at inbox.com> wrote:
> Come to think of it the plyr package and the data.table packages also offer similar tools.  For large merges (joins) I think the data.table package is much faster.
>
> John Kane
> Kingston ON Canada
>
>
>> -----Original Message-----
>> From: steven.ranney at gmail.com
>> Sent: Tue, 27 Nov 2012 15:28:57 -0700
>> To: jrkrideau at 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 <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
>>>
>>>
>
> ____________________________________________________________
> FREE 3D MARINE AQUARIUM SCREENSAVER - Watch dolphins, sharks & orcas on your desktop!
> Check it out at http://www.inbox.com/marineaquarium
>
>