Re: [R] reading multiple files

From: Uwe Ligges <ligges_at_statistik.uni-dortmund.de>
Date: Wed 25 May 2005 - 18:05:43 EST

Dave Evens wrote:

> Dear All,
>
>
> How do I read in multiple data frames or matrices in a
> loop, e.g.
>
> for (i in 1:n) {
> channel <- odbcConnectExcel("filenames")
> file[i] <- as.data.frame(sqlFetch(channel,
> "sheet"))
> }
>
> I would like file[i] to be the name of the data.frame
> (i.e. file[1], file[2], file[3],...etc) rather than a
> vector.

The terminology you are using re. R objects seems to be rather confused.

Quite probably you want a list of data frames such as using the filenames as names for the list elements along the follwoing lines:

library(RODBC)
dataframes <- vector(mode="list", length=length(filenames)) names(dataframes) <- filenames
for(i in filenames){

   channel <- odbcConnectExcel(i)
   dataframes[[i]] <- sqlFetch(channel, "sheet")    close(channel)
}

Uwe Ligges

> Thanks in advance for any help.
>
> Dave
>
> ______________________________________________
> 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



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 Received on Wed May 25 18:12:07 2005

This archive was generated by hypermail 2.1.8 : Fri 03 Mar 2006 - 03:32:03 EST