From sdavis2 at mail.nih.gov  Thu Oct  5 13:30:14 2006
From: sdavis2 at mail.nih.gov (Sean Davis)
Date: Thu, 5 Oct 2006 07:30:14 -0400
Subject: [Rd] example using R to aggregate data from multiple Excel files
In-Reply-To: <3bb44c6e0610050105s201251a1ycdd961333426c1fd@mail.gmail.com>
References: <3bb44c6e0610050105s201251a1ycdd961333426c1fd@mail.gmail.com>
Message-ID: <200610050730.14257.sdavis2@mail.nih.gov>

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




[Rd] example using R to aggregate data from multiple Excel files
Sean Davis