[datatable-help] misc join questions

[Johann Hibschman]

You're absolutely right.  I just upgraded to 1.6 last week, and I hadn't
reviewed the list of changes or the help page for merge yet.

I'll have to give that a try; that seems like that I want.

Thanks,
Johann

Steve Lianoglou <mailinglist.honeypot at gmail.com> writes:

> Ugh, sorry -- I mistakenly said that the latest version of data.table
> is 1.5.3  which is incorrect, it's 1.6.
>
> -steve
>
> On Wed, Jun 1, 2011 at 2:29 PM, Steve Lianoglou
> <mailinglist.honeypot at gmail.com> wrote:
>> Hi,
>>
>> I'm a bit cramped for time right now, so I can't comment on all your
>> points, but:
>>
>>
>> On Wed, Jun 1, 2011 at 1:40 PM, Johann Hibschman <jhibschman+r at gmail.com> wrote:
>> [snip]
>>
>>> Alternatively, since I'm used to the merge.data.frame syntax, if we
>>> could expand merge.data.table to allow "merge(x, y, by="date",
>>> all.x=TRUE)" for arbitrary data tables, creating keys as needed, that
>>> would also help.  Perhaps add a "autokey.x" option to enable the
>>> creation of needed keys.
>>
>> It actually does this already -- you can pass in your own column names
>> to act as keys for the merge operation.
>>
>> Is that not working for you? Are you using the latest version of
>> data.table (1.5.3)?
>>
>> If the answers to the two questions above are "no" and "yes"
>> (respectively), then there is likely a bug ... please let me know.
>>
>> -steve
>>
>> --
>> Steve Lianoglou
>> Graduate Student: Computational Systems Biology
>>  | Memorial Sloan-Kettering Cancer Center
>>  | Weill Medical College of Cornell University
>> Contact Info: http://cbio.mskcc.org/~lianos/contact
>>