Is there anyone out there who can suggest a way to solve this problem? Thanks, Esben
On Sun, Apr 24, 2011 at 8:53 PM, Jeff Newmiller <jdnew...@dcn.davis.ca.us> wrote: > Merge only lets you combine two tables at a time, but it does have a > "suffix" argument that is intended to address your concern, but only for > variable names that would conflict. > > In your example, the id variables are all sequenced exactly the same, so you > could actually use cbind rather than merge. > > However, whether you use merge or cbind, I think the most direct route to > your desired result is to rename the data columns before you combine them, > using the names function on the left hand side of an assignment with a > vector of new names on the right. > --------------------------------------------------------------------------- > Jeff Newmiller The ..... ..... Go Live... > DCN:<jdnew...@dcn.davis.ca.us> Basics: ##.#. ##.#. Live Go... > Live: OO#.. Dead: OO#.. Playing > Research Engineer (Solar/Batteries O.O#. #.O#. with > /Software/Embedded Controllers) .OO#. .OO#. rocks...1k > --------------------------------------------------------------------------- > Sent from my phone. Please excuse my brevity. > > Eric Fail <eric.f...@gmx.com> wrote: >> >> Dear R-list, >> >> Here is my simple question, >> >> I have n data frames that I would like to merge, but I can't figure out >> how to add information about the origin of the variable(s). >> >> Here is my problem, >> >> DF.wave.1 <- data.frame(id=1:10,var.A=sample(letters[1:4],10,TRUE)) >> DF.wave.2 <- data.frame(id=1:10,var.M=sample(letters[5:8],10,TRUE)) >> DF.wave.3 <- data.frame(id=1:10,var.A=sample(letters[5:8],10,TRUE)) >> >> Now; I would like to merge the three dataframes into one, but append a >> suffix to the individual variables names about thir origin. >> >> DF.wave.all <- merge(DF.wave.1,DF.wave.2,DF.wave.3,by="id", [what to do >> here]) >> >> In other words, I would like it to loook like this. >> >> DF.wave.all >> id var.A.wave.1 var.M.wave.2 var.A.wave.3 >> 1 1 c h j >> 2 2 c e j >> 3 3 c g k >> 4 4 c e j >> 5 5 c g i >> 6 6 d e k >> 7 7 c h k >> 8 8 b g j >> 9 9 b f i >> 10 10 d h i >> >> >> Is there a command I can use directly in merge? 'suffixes' isn't really >> handy here. >> >> Thanks, >> Eric >> ________________________________ >> 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. > ______________________________________________ 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.
