Hi there I have two dataframes Dataframe_1 column_1 colum_2 121 12345 145 1675 167 2765 Dataframe_2 column_1 column2 121 abc 345 lmn 167 efg I want a resulting dataframe 121 12345 abc 167 2765 efg how do i go abt it Ramya -- View this message in context: http://n4.nabble.com/Dataframe-help-tp947934p947934.html Sent from the R help mailing list archive at Nabble.com.
On Dec 3, 2009, at 2:47 PM, Ramya wrote:> > Hi there > > I have two dataframes > Dataframe_1 > column_1 colum_2 > 121 12345 > 145 1675 > 167 2765 > > Dataframe_2 > > column_1 column2 > 121 abc > 345 lmn > 167 efg > > I want a resulting dataframe > > 121 12345 abc > 167 2765 efg > > how do i go abt it?merge> > Ramya > -- > View this message in context: http://n4.nabble.com/Dataframe-help-tp947934p947934.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > 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.David Winsemius, MD Heritage Laboratories West Hartford, CT
Try this: both <- merge(left, right, by.x="column1", by.y="column1") left dataset column1 column2 121 12345 145 1675 167 2765 right datset column1 column3 121 abc 345 lmn 167 efg HTH, Peng On Thu, Dec 3, 2009 at 2:47 PM, Ramya <ramya.victory@gmail.com> wrote:> > Hi there > > I have two dataframes > Dataframe_1 > column_1 colum_2 > 121 12345 > 145 1675 > 167 2765 > > Dataframe_2 > > column_1 column2 > 121 abc > 345 lmn > 167 efg > > I want a resulting dataframe > > 121 12345 abc > 167 2765 efg > > how do i go abt it > > Ramya > -- > View this message in context: > http://n4.nabble.com/Dataframe-help-tp947934p947934.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > 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<http://www.r-project.org/posting-guide.html> > and provide commented, minimal, self-contained, reproducible code. >[[alternative HTML version deleted]]