CODEWITHSUNDEEP
rloopsdateread.csv
user123456
user123456

Reputation: 67

how to read multiple (loop) .csv files with a date name in R?

I have several .csv files with these names (from 1 January 2016 to 31 december 2016)

    01012016.csv
    02012016.csv
    ...
    31122016.csv

I want to use read.csv( by using a loop but still considering date patterns. 

start<-as.Date("01-01-16")
end<-as.Date("31-12-16")
theDate<-start
­{read.csv(theDate,".csv")}

Upvotes: 0

Views: 736

Answers (2)

r.user.05apr
r.user.05apr

Reputation: 5456

To create a character vector containing the format yyyymmdd you could try:

(yyyymmdd.vec <- format(seq(from = as.Date("01-01-16", format = "%d-%m-%y"),
                            to = as.Date("31-12-16", format = "%d-%m-%y"), 
                            by = "day"), format=  "%Y%m%d"))

Upvotes: 0

tushaR
tushaR

Reputation: 3116

You can get the names of all the files using list.files and giving it the path of all folder where all the files are located:

filenames = list.files('/path/to/datefiles/', pattern = "*.csv")

Then you can use lapply to iterate over the vector 'filenamescontaining the names of files and applyread.csvto each of them and set additional parameters likeheaderandstringsAsFactors` as TRUE or FALSE as required:

data = lapply(filenames,read.csv,header = TRUE,stringsAsFactors=FALSE)

Upvotes: 2

Related Questions