Hi there, The command for merging is: merge Can you please clarify by which variable you wish to merge by? Can you maybe use ?dput function in order to give a self contained R code example of your data - and the output you wish to get?
Best, Tal ----------------Contact Details:------------------------------------------------------- Contact me: tal.gal...@gmail.com | 972-52-7275845 Read me: www.talgalili.com (Hebrew) | www.biostatistics.co.il (Hebrew) | www.r-statistics.com (English) ---------------------------------------------------------------------------------------------- On Tue, Jan 31, 2012 at 8:51 PM, freezhu8 <freez...@gmail.com> wrote: > Suppose I have two data frames A and B > A has three variables and B also has three variables. > I would like to merge these two database but the requirement to merge > is that the value of the second column in database A is less than the > value of the second column in database B. Is there a R code to do > this? Thanks > > Dataframe A: V1a V2a V3a > 1 2 3 5 > 2 3 4 6 > 3 > Dataframe B: V1b V2b V3b > 1 2 5 9 > 2 9 2 7 > Dataframe C should be: V1a V2a V3a V1b V2b V3b > 1 2 3 5 2 5 9 > > -- > View this message in context: > http://r.789695.n4.nabble.com/question-of-merging-two-dataframes-tp4345469p4345469.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 > 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.