Thanks it worked!!! i was trying to use %in% and matching it. Ramya
On Thu, Dec 3, 2009 at 2:06 PM, Peng Cai [via R] < ml-node+947950-541874...@n4.nabble.com<ml-node%2b947950-541874...@n4.nabble.com> > wrote: > 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 <[hidden > email]<http://n4.nabble.com/user/SendEmail.jtp?type=node&node=947950&i=0>> > 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. > > > > ______________________________________________ > > [hidden > > email]<http://n4.nabble.com/user/SendEmail.jtp?type=node&node=947950&i=1>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]] > > ______________________________________________ > [hidden > email]<http://n4.nabble.com/user/SendEmail.jtp?type=node&node=947950&i=2>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. > > > ------------------------------ > View message @ http://n4.nabble.com/Dataframe-help-tp947934p947950.html > To unsubscribe from Dataframe help, click here< (link removed) ==>. > > > -- View this message in context: http://n4.nabble.com/Dataframe-help-tp947934p947960.html Sent from the R help mailing list archive at Nabble.com. [[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.
