example using R to aggregate data from multiple Excel files
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