Reading a bunch of csv files into R
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.