Hello togehter,
i have a little problem. Maybe anyone can help me.
I have 2 data.frames, which look like as follows:
First:
NAME MONTH BONUS
1 Andy 2014-10 100
2 Pete 2014-10 200
3 Marc 2014-10 300
4 Andy 2014-11 400
Second:
NAME MONTH BONUS_2
1 Andy 2014-10 150
2 Pete 2014-11 180
3 Jason 2014-10 190
4 Paul 2014-10 210
5 Andy 2014-11 30
How can I merge this 2 data.frames, if I want the following result:
NAME MONTH BONUS BONUS_2
1 Andy 2014-10 100 150
2 Pete 2014-11 180
3 Marc 2014-10 300
4 Andy 2014-11 400 30
5 Pete 2014-10 200
6 Jason 2014-10 190
7 Paul 2014-10 210
The important thing is, that for every accordance in the Columns
"NAME" and "MONTH" I get a new line.
Thanks for your help.
Best regards.
Mat
________________________________
This e-mail may contain trade secrets, privileged, undisclosed or otherwise
confidential information. If you have received this e-mail in error, you are
hereby notified that any review, copying or distribution of it is strictly
prohibited. Please inform us immediately and destroy the original transmittal.
Thank you for your cooperation.
Diese E-Mail kann Betriebs- oder Geschaeftsgeheimnisse oder sonstige
vertrauliche Informationen enthalten. Sollten Sie diese E-Mail irrtuemlich
erhalten haben, ist Ihnen eine Kenntnisnahme des Inhalts, eine Vervielfaeltigung
oder Weitergabe der E-Mail ausdruecklich untersagt. Bitte benachrichtigen Sie
uns und vernichten Sie die empfangene E-Mail. Vielen Dank.
[[alternative HTML version deleted]]
On 13/11/2014 14:02, Matthias Weber wrote:> Hello togehter, > > i have a little problem. Maybe anyone can help me.I think you might find ?merge enlightening Indeed given that the word merge occurs in your subject line and your text it is surprising you have not already found it.> > I have 2 data.frames, which look like as follows: > First: > > NAME MONTH BONUS > 1 Andy 2014-10 100 > 2 Pete 2014-10 200 > 3 Marc 2014-10 300 > 4 Andy 2014-11 400 > > Second: > > NAME MONTH BONUS_2 > 1 Andy 2014-10 150 > 2 Pete 2014-11 180 > 3 Jason 2014-10 190 > 4 Paul 2014-10 210 > 5 Andy 2014-11 30 > > How can I merge this 2 data.frames, if I want the following result: > > NAME MONTH BONUS BONUS_2 > 1 Andy 2014-10 100 150 > 2 Pete 2014-11 180 > 3 Marc 2014-10 300 > 4 Andy 2014-11 400 30 > 5 Pete 2014-10 200 > 6 Jason 2014-10 190 > 7 Paul 2014-10 210 > > The important thing is, that for every accordance in the Columns "NAME" and "MONTH" I get a new line. > > Thanks for your help. > > Best regards. > > Mat > > ________________________________ > This e-mail may contain trade secrets, privileged, undisclosed or otherwise confidential information. If you have received this e-mail in error, you are hereby notified that any review, copying or distribution of it is strictly prohibited. Please inform us immediately and destroy the original transmittal. Thank you for your cooperation. > > Diese E-Mail kann Betriebs- oder Geschaeftsgeheimnisse oder sonstige vertrauliche Informationen enthalten. Sollten Sie diese E-Mail irrtuemlich erhalten haben, ist Ihnen eine Kenntnisnahme des Inhalts, eine Vervielfaeltigung oder Weitergabe der E-Mail ausdruecklich untersagt. Bitte benachrichtigen Sie uns und vernichten Sie die empfangene E-Mail. Vielen Dank. > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help at r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. > > > ----- > No virus found in this message. > Checked by AVG - www.avg.com > Version: 2015.0.5557 / Virus Database: 4213/8566 - Release Date: 11/13/14 > >-- Michael http://www.dewey.myzen.co.uk
Hello,
See ?merge, in particular the argument 'all'.
dat1 <- read.table(text = "
NAME MONTH BONUS
1 Andy 2014-10 100
2 Pete 2014-10 200
3 Marc 2014-10 300
4 Andy 2014-11 400
", header = TRUE, stringsAsFactors = FALSE)
dat2 <- read.table(text = "
NAME MONTH BONUS_2
1 Andy 2014-10 150
2 Pete 2014-11 180
3 Jason 2014-10 190
4 Paul 2014-10 210
5 Andy 2014-11 30
", header = TRUE, stringsAsFactors = FALSE)
merge(dat1, dat2, all = TRUE)
Hope this helps,
Rui Barradas
Em 13-11-2014 14:02, Matthias Weber escreveu:> Hello togehter,
>
> i have a little problem. Maybe anyone can help me.
>
> I have 2 data.frames, which look like as follows:
> First:
>
> NAME MONTH BONUS
> 1 Andy 2014-10 100
> 2 Pete 2014-10 200
> 3 Marc 2014-10 300
> 4 Andy 2014-11 400
>
> Second:
>
> NAME MONTH BONUS_2
> 1 Andy 2014-10 150
> 2 Pete 2014-11 180
> 3 Jason 2014-10 190
> 4 Paul 2014-10 210
> 5 Andy 2014-11 30
>
> How can I merge this 2 data.frames, if I want the following result:
>
> NAME MONTH BONUS BONUS_2
> 1 Andy 2014-10 100 150
> 2 Pete 2014-11 180
> 3 Marc 2014-10 300
> 4 Andy 2014-11 400 30
> 5 Pete 2014-10 200
> 6 Jason 2014-10 190
> 7 Paul 2014-10 210
>
> The important thing is, that for every accordance in the Columns
"NAME" and "MONTH" I get a new line.
>
> Thanks for your help.
>
> Best regards.
>
> Mat
>
> ________________________________
> This e-mail may contain trade secrets, privileged, undisclosed or otherwise
confidential information. If you have received this e-mail in error, you are
hereby notified that any review, copying or distribution of it is strictly
prohibited. Please inform us immediately and destroy the original transmittal.
Thank you for your cooperation.
>
> Diese E-Mail kann Betriebs- oder Geschaeftsgeheimnisse oder sonstige
vertrauliche Informationen enthalten. Sollten Sie diese E-Mail irrtuemlich
erhalten haben, ist Ihnen eine Kenntnisnahme des Inhalts, eine Vervielfaeltigung
oder Weitergabe der E-Mail ausdruecklich untersagt. Bitte benachrichtigen Sie
uns und vernichten Sie die empfangene E-Mail. Vielen Dank.
>
> [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>
merge(df1, df2, all=TRUE) Bill Dunlap TIBCO Software wdunlap tibco.com On Thu, Nov 13, 2014 at 6:02 AM, Matthias Weber < Matthias.Weber at fntsoftware.com> wrote:> Hello togehter, > > i have a little problem. Maybe anyone can help me. > > I have 2 data.frames, which look like as follows: > First: > > NAME MONTH BONUS > 1 Andy 2014-10 100 > 2 Pete 2014-10 200 > 3 Marc 2014-10 300 > 4 Andy 2014-11 400 > > Second: > > NAME MONTH BONUS_2 > 1 Andy 2014-10 150 > 2 Pete 2014-11 180 > 3 Jason 2014-10 190 > 4 Paul 2014-10 210 > 5 Andy 2014-11 30 > > How can I merge this 2 data.frames, if I want the following result: > > NAME MONTH BONUS BONUS_2 > 1 Andy 2014-10 100 150 > 2 Pete 2014-11 180 > 3 Marc 2014-10 300 > 4 Andy 2014-11 400 30 > 5 Pete 2014-10 200 > 6 Jason 2014-10 190 > 7 Paul 2014-10 210 > > The important thing is, that for every accordance in the Columns "NAME" > and "MONTH" I get a new line. > > Thanks for your help. > > Best regards. > > Mat > > ________________________________ > This e-mail may contain trade secrets, privileged, undisclosed or > otherwise confidential information. If you have received this e-mail in > error, you are hereby notified that any review, copying or distribution of > it is strictly prohibited. Please inform us immediately and destroy the > original transmittal. Thank you for your cooperation. > > Diese E-Mail kann Betriebs- oder Geschaeftsgeheimnisse oder sonstige > vertrauliche Informationen enthalten. Sollten Sie diese E-Mail irrtuemlich > erhalten haben, ist Ihnen eine Kenntnisnahme des Inhalts, eine > Vervielfaeltigung oder Weitergabe der E-Mail ausdruecklich untersagt. Bitte > benachrichtigen Sie uns und vernichten Sie die empfangene E-Mail. Vielen > Dank. > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help at r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide > http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. >[[alternative HTML version deleted]]