merge(df1, df2, all=TRUE)
Bill Dunlap TIBCO Software wdunlap tibco.com On Thu, Nov 13, 2014 at 6:02 AM, Matthias Weber < matthias.we...@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@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]] ______________________________________________ R-help@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.
