Read many .csv files into an R session automatically, without specifying filenames
Romain Francois wrote:
Hi,
Something like this perhaps:
files <- dir( pattern = "\\.csv$" )
for( x in files){
assign( sub( "\\.csv$", "", x ) , read.csv(x), envir = .GlobalEnv )
}
or maybe
csvs = Map(read.csv, dir(pattern='\\.csv$'))
possibly with a correction of list item names
names(csvs) = sub('\\.csv$', '', names(csvs))
which is optional, since the content of foo.csv can be accessed as
csvs$foo (or as csvs[['foo', exact=FALSE]]) instead of csvs$foo.cvs even
without such a correction.
vQ
Romain Mark Na wrote:
Hi R-helpers,
I would like to read into R all the .csv files that are in my working
directory, without having to use a read.csv statement for each file.
Each .csv would be read into a separate dataframe which would acquire
the filename of the .csv.
As an example:
Mark<-read.csv("Mark.csv")
...but the code (or command) would do this automatically for every
.csv in the working directory without my specifying each file.
I'd appreciate any help or ideas you might have.
Thanks!
Mark Na