Re: [R] Import multiple files into R

[Lisa S]

But I don't think a list can contain that much data - we dont know how big
each txt file is.

So I'd like to do:
city.set <- c('Asheville','Charlotte')
month.set <- c('Dec', 'Jan', 'Feb')

comb.set <- expand.grid(city.set,month.set)
comb.set$filename = paste(comb.set[,1],comb.set[,2],sep = '_')

for i in 1:nrow(comb.set){
    db <- read.table(comb.set$filename[i] + '.txt',header = TRUE)
    save(db,filename + '.dat')
    rm(db)
}

So that each file is saved in a .dat file as a data frame, and she only
need to load and remove whenever she uses the file.


On Thu, Mar 20, 2014 at 5:14 PM, PIKAL Petr <petr.pi...@precheza.cz> wrote:

> Hi
>
> Best way is to put those files in one directory and start R from this
> directory or set this directory as working one.
>
> ?set.wd
> Then you can use list.files() to get file names.
> ?list.files
>
> myfiles<-list.files()
>
> Than strip txt. E.g. by
>
> filenames<-strsplit(list.files(), "\\."))
>
> After that you can use for cycle to read all files, however I would prefer
> list structure.
>
> files<-vector(mode="list", length(myfiles))
>
> for (i in 1:length(myfiles)) {
> files[[i]]<-read.table(myfiles[i])
> names(files)[[i]]<-filenames[[i]][1]
> }
>
> Instead of 75 objects you will get one list object and you can easily use
> interactively or programmatically its parts.
>
> Regards
> Petr
>
>
> > -----Original Message-----
> > From: r-help-boun...@r-project.org [mailto:r-help-bounces@r-
> > project.org] On Behalf Of ajaykumar
> > Sent: Thursday, March 20, 2014 6:15 AM
> > To: r-help@r-project.org
> > Subject: [R] Import multiple files into R
> >
> > Hi I want to import around 75 files. Each file has a name and a time
> > and is comma separated.
> > For example some of my file names are
> > Asheville_Dec.txt
> > Asheville_Jan.txt
> > Asheville_Feb.txt
> > Charlotte_Dec.txt
> > Chapelhill_Jan.txt
> >
> > The time months are only Dec Jan and Feb. The locations are different.
> > I have data for these 3 months at 25 cities which I want to import in R
> > I don't want to use read.table 75 times and keep changing names.
> >
> > Is there any way I can keep all the city names in an object and the
> > three months in another object and then use a loop over read.table of
> > location_time.txt I would also like to view them as 75 different data
> > sets in R So the file Asheville_Dec must be in a dataset called
> > Asheville_Dec in R
> >
> > Can this be done.
> > Please help
> >
> >
> >
> > --
> > View this message in context: http://r.789695.n4.nabble.com/Import-
> > multiple-files-into-R-tp4687178.html
> > Sent from the R help mailing list archive at Nabble.com.
> >
> > ______________________________________________
> > 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.
>
> ________________________________
> Tento e-mail a jakékoliv k němu připojené dokumenty jsou důvěrné a jsou
> určeny pouze jeho adresátům.
> Jestliže jste obdržel(a) tento e-mail omylem, informujte laskavě
> neprodleně jeho odesílatele. Obsah tohoto emailu i s přílohami a jeho 
> kopie
> vymažte ze svého systému.
> Nejste-li zamýšleným adresátem tohoto emailu, nejste oprávněni tento 
> email
> jakkoliv užívat, rozšiřovat, kopírovat či zveřejňovat.
> Odesílatel e-mailu neodpovídá za eventuální škodu způsobenou 
> modifikacemi
> či zpožděním přenosu e-mailu.
>
> V případě, že je tento e-mail součástí obchodního jednání:
> - vyhrazuje si odesílatel právo ukončit kdykoliv jednání o uzavření
> smlouvy, a to z jakéhokoliv důvodu i bez uvedení důvodu.
> - a obsahuje-li nabídku, je adresát oprávněn nabídku bezodkladně 
> přijmout;
> Odesílatel tohoto e-mailu (nabídky) vylučuje přijetí nabídky ze strany
> příjemce s dodatkem či odchylkou.
> - trvá odesílatel na tom, že příslušná smlouva je uzavřena teprve
> výslovným dosažením shody na všech jejích náležitostech.
> - odesílatel tohoto emailu informuje, že není oprávněn uzavírat za
> společnost žádné smlouvy s výjimkou případů, kdy k tomu byl písemně 
> zmocněn
> nebo písemně pověřen a takové pověření nebo plná moc byly 
> adresátovi tohoto
> emailu případně osobě, kterou adresát zastupuje, předloženy nebo jejich
> existence je adresátovi či osobě jím zastoupené známá.
>
> This e-mail and any documents attached to it may be confidential and are
> intended only for its intended recipients.
> If you received this e-mail by mistake, please immediately inform its
> sender. Delete the contents of this e-mail with all attachments and its
> copies from your system.
> If you are not the intended recipient of this e-mail, you are not
> authorized to use, disseminate, copy or disclose this e-mail in any manner.
> The sender of this e-mail shall not be liable for any possible damage
> caused by modifications of the e-mail or by delay with transfer of the
> email.
>
> In case that this e-mail forms part of business dealings:
> - the sender reserves the right to end negotiations about entering into a
> contract in any time, for any reason, and without stating any reasoning.
> - if the e-mail contains an offer, the recipient is entitled to
> immediately accept such offer; The sender of this e-mail (offer) excludes
> any acceptance of the offer on the part of the recipient containing any
> amendment or variation.
> - the sender insists on that the respective contract is concluded only
> upon an express mutual agreement on all its aspects.
> - the sender of this e-mail informs that he/she is not authorized to enter
> into any contracts on behalf of the company except for cases in which
> he/she is expressly authorized to do so in writing, and such authorization
> or power of attorney is submitted to the recipient or the person
> represented by the recipient, or the existence of such authorization is
> known to the recipient of the person represented by the recipient.
> ______________________________________________
> 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]]


______________________________________________
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.