R help - May 2009 - Read many .csv files into an R session automatically, without specifying filenames

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

I really dont know hot to use it - but have a look at ?source

On Mon, May 11, 2009 at 10:37 PM, Mark Na <mtb954@gmail.com> 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
>
> ______________________________________________
> R-help@r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
> http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>
	[[alternative HTML version deleted]]

Hi,

Something like this perhaps:

files <- dir( pattern  = "\\.csv$" )
for( x in files){
    assign( sub( "\\.csv$", "", x ) , read.csv(x), envir =
.GlobalEnv )
}

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
>   

-- 
Romain Francois
Independent R Consultant
+33(0) 6 28 91 30 30
http://romainfrancois.blog.free.fr