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

[Pele]

Perfect - many thanks!!!


baptiste auguie-2 wrote:
> 
> 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
> 
> ______________________________________________
> 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-tp22402493p22404961.html
Sent from the R help mailing list archive at Nabble.com.