I am having a problem in opening the excel files in specdata folder. I have completed coding the R program for the assignment but when I run the following commands in the R console,
*source("pollutantmean.R")* *> pollutantmean("specdata", "nitrate", 23)* I get an error message stating *Error in file(file, "rt") : cannot open the connection* *In addition: Warning message:* *In file(file, "rt") :* * cannot open file 'specdata/023.csv': No such file or directory* I tried everything and reset my Working Directory to *C:/Users/acer/My Documents/specdata/rprog-data-specdata/specdata* After the last specdata folder are all the excel sheets numbered 001 to 332. I searched the internet and all other options available, and got a solution to open it using the following command: *df <- read.csv("specdata/001.csv")* This generated the following error message *Error in file(file, "rt") : cannot open the connection* *In addition: Warning message:* *In file(file, "rt") :* * cannot open file 'specdata/001.csv': No such file or directory* I have tried various other commands also such as *path <- c(paste("./",directory, "/",formatC(id[i], width=3, flag=0),".csv",sep=""))* However, all the commands show some error. What shall I do? I am using the 3.2.1 version of R on a Windows 8 laptop. Regards, Nikita Dinger [[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see 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.