R devel - Oct 2006 - example using R to aggregate data from multiple Excel files

Hi,

I have a project to analyse the various Web server statistics for a
server on a weekly basis for the past year using data maintained in
about 20 excel files per week. I need to go through these files and
aggregate the data, obviously the excel files are pretty simple 2
column affairs (I say obviously because otherwise why was the data
maintained in 20 files for web site usage per week if the files
themselves were not very simple) I am looking for examples of going
over a bunch of excel files with R, extracting the data and then
aggregating for analysis.

Cheers,
Bryan Rasmussen

On Thursday 05 October 2006 04:05, bryan rasmussen
wrote:
> Hi,
>
> I have a project to analyse the various Web server statistics for a
> server on a weekly basis for the past year using data maintained in
> about 20 excel files per week. I need to go through these files and
> aggregate the data, obviously the excel files are pretty simple 2
> column affairs (I say obviously because otherwise why was the data
> maintained in 20 files for web site usage per week if the files
> themselves were not very simple) I am looking for examples of going
> over a bunch of excel files with R, extracting the data and then
> aggregating for analysis.
You probably want to write to the R-help list, not the R-devel list.  That 
said, you probably want to look at the dir() command and read.xls() from the 
gdata/gtools/gplots packages (you need to install all three).  Alternatively, 
you can look at using ODBC to connect to the files.

Sean