[R] Efficient ways of merging data frames

2010-09-12 Thread Anyi Zhu
Hi all, I am just wondering if there is a more efficient way of merging two large datasets based on the values of multiple columns, some of which are not numerical. The default merge function in dataframe is very inefficient and the merge function in data.table seems to be faster, but it does

Re: [R] Efficient ways of merging data frames

2010-09-12 Thread jim holtman
Have you tried 'pasting' the values together and then using this as the key for the join? On Sun, Sep 12, 2010 at 2:39 PM, Anyi Zhu anyi@gmail.com wrote: Hi all, I am just wondering if there is a more efficient way of merging two large datasets based on the values of multiple columns,

Re: [R] Efficient ways of merging data frames

2010-09-12 Thread Dennis Murphy
Hi: On Sun, Sep 12, 2010 at 11:39 AM, Anyi Zhu anyi@gmail.com wrote: Hi all, I am just wondering if there is a more efficient way of merging two large datasets based on the values of multiple columns, some of which are not numerical. As noted in your previous post, the variables