Re: [R] Automatic File Reading [Broadcast]

From: Wensui Liu <liuwensui_at_gmail.com>
Date: Sun 29 Oct 2006 - 02:46:55 GMT

Andy,

First of all, thanks for your solution.

When I test your code, it doesn't work. I am not sure if I miss something.

Here is the code I tested:
flist<-list.files(path = file.path(, "c:\\"),pattern="[.]csv$")
csvlist<-lapply(flist, read.csv, header = TRUE)

Here is the error:
Error in file(file, "r") : unable to open connection In addition: Warning message:
cannot open file 'test1.csv', reason 'No such file or directory'

Thank you so much!

On 10/18/06, Liaw, Andy <andy_liaw@merck.com> wrote:
> Works on all platforms:
>
> flist <- list.files(path=file.path("somedir", "somewhere"),
> pattern="[.]csv$")
> csvlist <- lapply(flist, read.csv, header=TRUE)
> whateverList <- lapply(csvlist, whatever)
>
> Andy
>
> From: Richard M. Heiberger
> >
> > Wensui Lui asks:
> > > is there a similar way to read all txt or csv files with same
> > > structure from a folder?
> >
> >
> >
> > On Windows I use this construct to find all files with the
> > specified wild card name.
> > I used the "\\" in the file paths with the translate=FALSE,
> > because the "/" in
> > the DOS switches "/w/B" must not be translated. On Windows
> > this picks up
> > both lower and upper case filenames
> >
> > A similar construct can be written for Unix.
> >
> > tmp <- shell('dir c:\\HOME\\rmh\\tmp\\*.R /w/B', intern=TRUE,
> > translate=FALSE) ##msdos
> > for (i in tmp) source(paste("c:\\HOME\\rmh\\tmp\\", i, sep=""))
> >
> > ______________________________________________
> > R-help@stat.math.ethz.ch 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.
> >
> >
> >
>
>
> ------------------------------------------------------------------------------
> Notice: This e-mail message, together with any attachment...{{dropped}}



R-help@stat.math.ethz.ch 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. Received on Sun Oct 29 13:59:14 2006

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.1.8, at Sun 29 Oct 2006 - 04:30:13 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.