Message-ID: <200610050730.14257.sdavis2@mail.nih.gov>
Date: 2006-10-05T11:30:14Z
From: Sean Davis
Subject: example using R to aggregate data from multiple Excel files
In-Reply-To: <3bb44c6e0610050105s201251a1ycdd961333426c1fd@mail.gmail.com>
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