Message-ID: <171E292C-79D2-4431-8109-C5B52CE5FCDC@me.com>
Date: 2009-11-17T18:36:31Z
From: Marc Schwartz
Subject: how to merge two data.frames – only complete observations
In-Reply-To: <94517E3E-A5C9-4FDA-9E47-7A7E91EF914A@googlemail.com>
On Nov 17, 2009, at 12:20 PM, Martin Batholdy wrote:
> Hi,
>
>
> I have two data-frames like:
>
> A:
> USA 3.2
> Canada 4.7
> Austria 1.5
> Iran 0.3
> China 3.8
> Japan 3.0
>
> B:
> Austria 17
> Iran 22
> Angola 29
> Japan 32
> England 11
>
>
> Now I want to merge this two data.frames to one -
> but I only want entries for the countries I have complete
> observations for;
>
> so the final data.frame should look like this:
>
> C:
> Austria 1.5 17
> Iran 0.3 22
> Japan 3.0 32
>
>
> How can I do this?
See ?merge
> A
V1 V2
1 USA 3.2
2 Canada 4.7
3 Austria 1.5
4 Iran 0.3
5 China 3.8
6 Japan 3.0
> B
V1 V2
1 Austria 17
2 Iran 22
3 Angola 29
4 Japan 32
5 England 11
> merge(A, B, by = "V1")
V1 V2.x V2.y
1 Austria 1.5 17
2 Iran 0.3 22
3 Japan 3.0 32
HTH,
Marc Schwartz