Re: [R] Efficient way to do a merge in R

2011-10-04 Thread Matthew Dowle
"Joshua Wiley" wrote in message news:canz9z_kopuwkzb-zxr96pvulhhf2znxntxso9xnyho-_jum...@mail.gmail.com... > On Tue, Oct 4, 2011 at 12:40 AM, Rainer Schuermann > wrote: >>> Any comments are very welcome, >> >> 3. If that fails, and nobody else has a better idea, I would consider >> using a dat

Re: [R] Efficient way to do a merge in R

2011-10-04 Thread Joshua Wiley
On Tue, Oct 4, 2011 at 12:40 AM, Rainer Schuermann wrote: >> Any comments are very welcome, > So I give it a shot, although I don't have answers but only some ideas which > avenues I would explore, not being an > expert at all: > > 1. I would try to be more restrictive with the columns used for m

Re: [R] Efficient way to do a merge in R

2011-10-04 Thread Rainer Schuermann
> Any comments are very welcome, So I give it a shot, although I don't have answers but only some ideas which avenues I would explore, not being an expert at all: 1. I would try to be more restrictive with the columns used for merge, trying something like m1 <- merge( x, y, by.x = "V1", by.y =

[R] Efficient way to do a merge in R

2011-10-03 Thread Aurélien PHILIPPOT
Dear all, I am new in R and I have been faced with the following problem, that slows me down a lot. I am short of ideas to circumvent it. So, any help would be highly appreciated: I have 2 dataframes x and y. x is very big (70 million observations), whereas y is smaller (30 observations). Al