Skip to content
Back to formatted view

Raw Message

Message-ID: <CAA99HCyqULLzW2aodnwZ2epPWP+MSX+Q6-TGM6tRk5Ro=D-EaQ@mail.gmail.com>
Date: 2015-05-27T07:53:38Z
From: William Michels
Subject: Problem merging data frames and duplicates
In-Reply-To: <CAAbnQ5gJ_B-pqz2+z15+yCXGqBobje0aOVMkSOgQVxVuacMnNg@mail.gmail.com>

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:

https://github.com/ggrothendieck/sqldf

Best Regards,

William (Bill) Michels, Ph.D.



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