Re: [R] merging pre-sorted data frames

2015-01-14 Thread Alex Fun
package dplyr's full_join, left_join, right_join, inner_join are also comparable in speed to data table. The syntax is also more like merge's. On Thu, Jan 15, 2015 at 2:17 PM, Mike Miller mbmille...@gmail.com wrote: Thanks, Jeff. You really know the packages. I search and I guess I didn't

Re: [R] merging pre-sorted data frames

2015-01-14 Thread Mike Miller
Thanks, Jeff. You really know the packages. I search and I guess I didn't use the right terms. That package seems to do exactly what I wanted. Mike On Tue, 13 Jan 2015, Jeff Newmiller wrote: On Tue, 13 Jan 2015, Mike Miller wrote: I have many pairs of data frames each with about 15

[R] merging pre-sorted data frames

2015-01-13 Thread Mike Miller
I have many pairs of data frames each with about 15 million records each and about 10 million records in common. They are sorted by two of their fields and will be merged by those same fields. The fact that the data are sorted could be used to greatly speed up a merge, but I have the

Re: [R] merging pre-sorted data frames

2015-01-13 Thread Jeff Newmiller
On Tue, 13 Jan 2015, Mike Miller wrote: I have many pairs of data frames each with about 15 million records each and about 10 million records in common. They are sorted by two of their fields and will be merged by those same fields. The fact that the data are sorted could be used to greatly