[R] Append/merge

Mark Myatt mark at myatt.demon.co.uk
Fri Jul 20 13:47:10 CEST 2001


Debra Taylor <debrat at bestweb.net> writes:
>    I have a question about stacking datasets. 
>
>    I have 40 stata datasets that have exactly the same number of 
>    variables, with the same names (~420k rows, 8 columns). 
>
>    The datasets are relatively large ~ 15 megs. 
>
>    If they were text files a linux "cat file1 file2 >> combo" sort of 
>    strategy would work. 

[Snip]

>    Does somebody have an R solution in mind? 

Read each data file in as a data frame then use the rbind() function.
Something like:

        a <- read.table("file1", header = T)
        b <- read.table("file2", header = T)
        my.data <- rbind(a, b)
        #
        # remove the excess 15MB ...
        #
        rm(b)
        a <- read.table("file3", header = T)
        my.data <- rbind(ab, a)
        #
        # and so on ... finally removing the excess 15MB ...
        #
        rm(a)

Mark


--
Mark Myatt


-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._



More information about the R-help mailing list