[R] Merge 10 data frames with 3 id columns that are common to all data frames

[baptiste auguie]

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 at 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 at 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 at 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