Displaying 1 result from an estimated 1 matches for "seekig".
Did you mean:
seeking
2009 Aug 20
1
Read and merge a number of .xls files into one dataframe
...e and merge the columns with
the same name into a single dataframe.
here is what I have thus far (on Mac OS X 10.5.2. for R 2.8.0):
# Define the directory where the data is
path="/Users/home/mydata/"
# Make a list of the filenames (they are all .xls so no need for a regular
expression seekig out ones ending in .xls )
files=list.files(path="/Users/home/mydata/")
# Read them into a list called data
data=tapply(paste(path,files,sep=""),files[1:length(files)],read.xls)
This gives the data in a list. What I want is a dataframe. I can turn it
into a matrix with as.ma...