R help - Apr 2011 - merge with origin information in new variable names

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

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:<jdnewmil@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.fail@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.


	[[alternative HTML version deleted]]