R help - Nov 2008 - Combining many files into one

I have a few hundred .csv files in a folder on my hard drive, and I would like
to combine them all into one file.  They are all the same data, but the program
that collected the data saved a file every 4 hours.  I can combine the files one
at a time using rbind, but am having a problem automating it in a for
loop.  The loop runs for a while, and finally gives an error message "no
lines available in input".  I would appreciate any help you can give.  What
I have so far is below.  Thanks!  Tim
 
 
files<-list.files(mydir)                               #List of every file in
the working directory
 
for (i in 1:length(files))                             #Loops through files
 {
 dat <- read.csv(files[i], header=T)          #Reads one file at a time
 all.dat<-rbind(dat)                                  #Binds the file just
read to the end of all.dat
 }



      
	[[alternative HTML version deleted]]

The error message might mean that you have an empty file.  It is
probably better to use a list for reading in the data and then combine
them at the end.  "try" may also catch your errors:

all.dat <- lapply(list.files(mydir), function(.file){
    try(read.csv(.file))
})
all.dat <- do.call(rbind, all.dat)


On Mon, Nov 3, 2008 at 9:17 PM, t c <mudiver1200 at yahoo.com>
wrote:
> I have a few hundred .csv files in a folder on my hard drive, and I would
like to combine them all into one file.  They are all the same data, but the
program that collected the data saved a file every 4 hours.  I can combine the
files one at a time using rbind, but am having a problem automating it in a for
loop.  The loop runs for a while, and finally gives an error message "no
lines available in input".  I would appreciate any help you can give.  What
I have so far is below.  Thanks!  Tim
>
>
> files<-list.files(mydir)                               #List of every
file in the working directory
>
> for (i in 1:length(files))                             #Loops through files
>  {
>  dat <- read.csv(files[i], header=T)          #Reads one file at a time
>  all.dat<-rbind(dat)                                  #Binds the file
just read to the end of all.dat
>  }
>
>
>
>
>        [[alternative HTML version deleted]]
>
>
> ______________________________________________
> 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.
>
>


-- 
Jim Holtman
Cincinnati, OH
+1 513 646 9390

What is the problem that you are trying to solve?