How to include strings and variables in the file path for read.csv in R?

Question

I am trying to enter a file path into a function where part of the function reads data from .csv files from a folder specified in the function.

This part of the script:

prep_data <- function("filepath", Year_First, Year_Last)  {
...
FileName <- paste0(filepath,"/details", Year_Index, "moredetails", Year_Index, ".csv")
Tbl_Year <- read.csv(FileName)

Where

prep_data("/users/me/etc", 1980, 2014)

Is giving me this error:

In file(file, "rt") :
cannot open file 'filepath/details1980moredetails1980.csv': No such file or directory

My desired file path would be:

/users/me/etc/details1980moredetails1980.csv

This line is in a for loop that is reading .csv files for the range of specified years.

It should be prep_data <- function(filepath, Year_First, Year_Last) with filepath unquoted. But I don't even see how that works without error — Rich Scriven
– Rich Scriven, Commented Oct 21, 2015 at 1:23

Rγσ ξηg Lιαη Ημ 雷欧 · Accepted Answer · 2015-12-02 22:36:26Z

1

read.csv(paste0(getwd(),'/details/, Year_Index, 'moredetails', Year_Index, '.csv'),header=TRUE,sep=',',FactorAsString=TRUE)

Suggest try getwd() for filepath if your files saved in directory.

answered Dec 2, 2015 at 22:36

Rγσ ξηg Lιαη Ημ 雷欧

5062 gold badges9 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to include strings and variables in the file path for read.csv in R?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related