[R] Read many .csv files into an R session automatically, without specifying filenames

Rolf Turner r.turner at auckland.ac.nz
Mon May 11 23:13:08 CEST 2009


On 12/05/2009, at 8:41 AM, Andreas Christoffersen wrote:

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

	No; ``source'' is irrelevant here.
>
> On Mon, May 11, 2009 at 10:37 PM, Mark Na <mtb954 at 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.


datalist <- list()
files <- list.files(pattern="\\.csv$")
	for(file in files) {
	stem <- gsub("\\.csv$","",file)
	datalist[[stem]] <- read.csv(file)
}

The foregoing does things the *right* way, putting the resulting data  
sets together
into a list whereby they can be accessed in an organized fashion.  If  
you wrong-headedly
*insist* on putting the data sets separately into your workspace then  
do:

files <- list.files(pattern="\\.csv$")
	for(file in files) {
	stem <- gsub("\\.csv$","",file)
	assign(stem,read.csv(file))
}

	cheers,

		Rolf Turner

######################################################################
Attention:\ This e-mail message is privileged and confid...{{dropped:9}}




More information about the R-help mailing list