[R] Problem merging data frames and duplicates

William Michels wjm1 at caa.columbia.edu
Wed May 27 09:53:38 CEST 2015

Hi Frank,

It looks like you're very close. I think you want:

unique(merge(x, y, by = 1, all=T))

Gabor Grothendieck's sqldf package is very useful if you're more
comfortable with SQL-type syntax, see:


Best Regards,

William (Bill) Michels, Ph.D.

On Tue, May 26, 2015 at 5:12 PM, Frank Burbrink
<burbrink666 at gmail.com> wrote: <SNIP>

More information about the R-help mailing list