[R] Reading a bunch of csv files into R

[Rui barradas]

Hello,

Or maybe put the data frames in a list

df.list <- lapply(seq_len(filenames), read.csv, ...) # '...other...' are 
options you might want to pass, (like headers=TRUE)
names(df.list) <- data_names

Now access the data frames by number in the list or by name in data_names.

Hope this helps,

Rui Barradas
Em 25-05-2012 20:08, Nutter, Benjamin escreveu:
> For example:
>
> myDir<- "some file path"
> filenames<- list.files(myDir)
> filenames<- filenames[grep("[.]csv", filenames)]
>
> data_names<- gsub("[.]csv", "", filenames)
>
> for(i in 1:length(filenames)) assign(data_names[i], read.csv(file.path(myDir, filenames[i])))
>
>   
>
>   Benjamin Nutter |  Biostatistician     |  Quantitative Health Sciences
>    Cleveland Clinic    |  9500 Euclid Ave.  |  Cleveland, OH 44195  | (216) 445-1365
>
>
> -----Original Message-----
> From: r-help-bounces at r-project.org [mailto:r-help-bounces at r-project.org] On Behalf Of Kevin Wright
> Sent: Friday, May 25, 2012 2:55 PM
> To: HJ YAN
> Cc: r-help at r-project.org
> Subject: Re: [R] Reading a bunch of csv files into R
>
> See ?dir
>
> Assign the value to a vector and loop over the elements of the vector.
>
> Kevin
>
>
> On Fri, May 25, 2012 at 12:16 PM, HJ YAN<yhj204 at googlemail.com>  wrote:
>> Dear R users
>>
>>
>> I am struggling from a data importing issue:
>>
>> I have some hundreds of csv files needed to be read into R for futher
>> analysis. All those csv files are named in one of the three formats:
>>
>> (1) strings: e.g. London_Oxford street
>> (2) Integer: e.g. 1234_5678
>> (3) combined: e.g. London_1234
>>
>> I intend to use read.csv("xxxx_xxx.csv") but I only dealt with sigle
>> documents before and if there are only no more than 20 files, I do not
>> bother to search a more efficient way.
>>
>>
>> Is there any claver way that I do not have to type in all these
>> hundreds names by hand, maybe using a R package or write some code in
>> some other languages if it is not too difficult to learn.
>>
>> Any thoughts/hints please??
>>
>> Many thanks in advance!
>>
>> HJ
>>
>>         [[alternative HTML version deleted]]
>>
>> ______________________________________________
>> R-help at 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.
>
>
> --
> Kevin Wright
>
> ______________________________________________
> R-help at 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.
>
>
> ===================================
>
>   Please consider the environment before printing this e-mail
>
> Cleveland Clinic is ranked one of the top hospitals
> in America by U.S.News&  World Report (2010).
> Visit us online at http://www.clevelandclinic.org for
> a complete listing of our services, staff and
> locations.
>
>
> Confidentiality Note:  This message is intended for use\...{{dropped:13}}
>
> ______________________________________________
> R-help at 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.