Re: [R] Efficient ways of merging data frames

Hi: On Sun, Sep 12, 2010 at 11:39 AM, Anyi Zhu 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 comprising the key

Re: [R] Efficient ways of merging data frames

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 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

[R] Efficient ways of merging data frames

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 not