The function expects a list of data.frames as a first argument but you
provided a data.frame instead, the others are interpreted as optional
arguments to merge_recurse(). Try this instead,
merge_recurse(list(DF1,DF2,DF3,DF4))
var1 x y t u d e f o
1 a 1.39679 2 -1.18377 2 -0.041194 31 -1.05526 11
2 b -0.20453 2 0.22777 2 -0.543270 31 1.45777 11
3 c -0.91446 2 -0.97843 2 -1.279132 31 1.88759 11
4 d -1.18069 2 -0.23963 2 -0.064799 31 -0.85747 11
5 e -1.24802 2 1.43072 2 0.183317 31 2.50352 11
HTH,
baptiste
On 8 Mar 2009, at 23:40, Pele wrote:
I tried using merge_all as shown below but I am getting an error ...
can
anyone tell me what I am doing wrong? The result table below is
what I am
looking for.
DF1 <- data.frame(var1 = letters[1:5], x = rnorm(5), y =2)
DF2 <- data.frame(var1 = letters[1:5], t = rnorm(5), u =2)
DF3 <- data.frame(var1 = letters[1:5], d = rnorm(5), e =31)
DF4 <- data.frame(var1 = letters[1:5], f = rnorm(5), o =11)
DF_all <- merge_all(DF1, DF2, DF3, DF4, by="var1" )
Error in fix.by(by.x, x) :
'by' must specify column(s) as numbers, names or logical
Results I would like
var1 x y d e
t u x
a -1.725155 2 -0.48097 31
0.032968 2 -1.725155
b 0.799983 2 2.32965 31
-0.385364 2 0.799983
c -1.387224 2 0.61761 31
0.977404 2 -1.387224
d 0.645946 2 0.46152 31
1.334591 2 0.645946
e 0.058783 2 -0.25312 31
0.631676 2 0.058783
baptiste auguie-2 wrote:
Hi,
Try this:
DF1 <- data.frame(var1 = letters[1:5], x = rnorm(5), y =2)
DF2 <- data.frame(var1 = letters[3:7], x = rnorm(5), y=3)
DF3 <- data.frame(var1 = letters[6:10], x = rnorm(5), y=0)
# ... DF10 if you wish
( result <- merge_all(list(DF1, DF2, DF3) ))
save( result, file ="merged.rda")
I didn't know of this function, thanks. Similar solutions using base
functions were proposed recently on
http://wiki.r-project.org/rwiki/doku.php?id=tips:data-frames:merge
and i've now added this for reference.
baptiste
On 8 Mar 2009, at 20:23, Pele wrote:
Hi R users,
Can anyone share some example code using merge_all (from the reshape
package) to merge 10 data frames into 1 file.
Thanks in advance for any help!
--
View this message in context:
http://www.nabble.com/Merge-10-data-frames-with-3-id-columns-that-are-common-to-all-data-frames-tp22402493p22402493.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.
_____________________________
Baptiste Auguié
School of Physics
University of Exeter
Stocker Road,
Exeter, Devon,
EX4 4QL, UK
Phone: +44 1392 264187
http://newton.ex.ac.uk/research/emag
______________________________________________
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.
--
View this message in context:
http://www.nabble.com/Merge-10-data-frames-with-3-id-columns-that-are-common-to-all-data-frames-tp22402493p22404595.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.
_____________________________
Baptiste Auguié
School of Physics
University of Exeter
Stocker Road,
Exeter, Devon,
EX4 4QL, UK
Phone: +44 1392 264187
http://newton.ex.ac.uk/research/emag
______________________________________________
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.
