The system cannot find the file specified in Rmarkdown

[Tails0298]

Hello guys. I have finished a project for a case study of Coursera. I am doing R Markdown, but is giving this error "The system cannot find the file specified because it says "combined_databike" cannot be found. The combined_databike is the data frame that I am using for my whole project, so I don't why R is not recognizing when I already did it on the R studio desktop.

[andresrcs]

When you knit an Rmd document the code gets executed in a clean environment other than the one you are currently working on so the mentioned data frame doesn't exist there. You need to include the necessary code to import the data frame into memory, in your Rmd document itself, for example, if the data frame comes from a csv file you would include something like this: your_data_frame <- read.csv("path_to_file.csv").

[Tails0298]

Hello Guys
I am doing my current project in RStudio Desktop. I am doing RMarkdown to later transfer. I am having some trouble getting an error of the system cannot find the file specified RMarkdown. At first, it says that the combined_databike was not found, but I literally did it in the same file already also you can see in the upper right all of the data frames which mention "combined_databike." This being said when I am trying to hit knit it gives me the error. Now the error says is at the tripdata_202006, which I cannot understand because I imported every file from tripdata_202006 to tripdata_202105 using the "import dataset."

I want to understand why is not working and how I bring a solution.

[andresrcs]

You have copied your code from console output including the "+" symbols that indicate a new line, you have to remove those, otherwise you get a syntax error.

Also, please do not post screenshots of your code, it is considered a bad practice here, post formatted code instead, here is how to do it.

FAQ: How to format your code

Formatting Code: the Basics All code or console output you include in your posts should be formatted properly. Luckily, this is very easy to do! Just use the code formatting button at the top of the post editing box: [image] Select some code Click the </> button! The code formatting button automatically adds special Markdown formatting symbols to whatever you selected. If you check the preview pane to the right of your post, you'll see that the forum software now outputs nicely formatted code . [04] The code formatting button is pretty smart! It can tell the difference between snippets of code that are part of a sentence and blocks of code that stand alone. …

[Tails0298]

tripdata_202006 <- read_csv("Bike data/202006-divvy-tripdata.csv", 
                            +     col_types = cols(started_at = col_datetime(format = "%m/%d/%Y %H:%M"), 
                                                   +         ended_at = col_datetime(format = "%m/%d/%Y %H:%M"), 
                                                   +         start_station_id = col_character(), 
                                                   +         end_station_id = col_character()))
 View(tripdata_202006)                  july_2020 <- read_csv("Bike data 12 months/202007-divvy-tripdata/202007-divvy-tripdata.csv")


tripdata_202007 <- read_csv("Bike data/202007-divvy-tripdata.csv", 
                              +     col_types = cols(started_at = col_datetime(format = "%m/%d/%Y %H:%M"), 
                                                     +         ended_at = col_datetime(format = "%m/%d/%Y %H:%M"), 
                                                     +         start_station_id = col_character(), 
                                                     +         end_station_id = col_character()))
 View(tripdata_202007)  

 tripdata_202008 <- read_csv("Bike data/202008-divvy-tripdata.csv", 
                              +     col_types = cols(started_at = col_datetime(format = "%m/%d/%Y %H:%M"), 
                                                     +         ended_at = col_datetime(format = "%m/%d/%Y %H:%M"), 
                                                     +         start_station_id = col_character(), 
                                                     +         end_station_id = col_character()))
 View(tripdata_202008)    

 tripdata_202009 <- read_csv("Bike data/202009-divvy-tripdata.csv", 
                              +     col_types = cols(started_at = col_datetime(format = "%m/%d/%Y %H:%M"), 
                                                     +         ended_at = col_datetime(format = "%m/%d/%Y %H:%M"), 
                                                     +         start_station_id = col_character(), 
                                                     +         end_station_id = col_character()))
 View(tripdata_202009)   

 tripdata_202010 <- read_csv("Bike data/202010-divvy-tripdata.csv", 
                              +     col_types = cols(started_at = col_datetime(format = "%m/%d/%Y %H:%M"), 
                                                     +         ended_at = col_datetime(format = "%m/%d/%Y %H:%M"), 
                                                     +         start_station_id = col_character(), 
                                                     +         end_station_id = col_character()))
 View(tripdata_202010)

 tripdata_202011 <- read_csv("Bike data/202011-divvy-tripdata.csv", 
                              +     col_types = cols(started_at = col_datetime(format = "%m/%d/%Y %H:%M"), 
                                                     +         ended_at = col_datetime(format = "%m/%d/%Y %H:%M"), 
                                                     +         start_station_id = col_character(), 
                                                     +         end_station_id = col_character()))
 View(tripdata_202011)

 tripdata_202012 <- read_csv("Bike data/202012-divvy-tripdata.csv", 
                              +     col_types = cols(started_at = col_datetime(format = "%m/%d/%Y %H:%M"), 
                                                     +         ended_at = col_datetime(format = "%m/%d/%Y %H:%M")))
 View(tripdata_202012)

 tripdata_202101 <- read_csv("Bike data/202101-divvy-tripdata.csv", 
                              +     col_types = cols(started_at = col_datetime(format = "%m/%d/%Y %H:%M"), 
                                                     +         ended_at = col_datetime(format = "%m/%d/%Y %H:%M")))
 View(tripdata_202101)   

 tripdata_202102 <- read_csv("Bike data/202102-divvy-tripdata.csv", 
                              +     col_types = cols(started_at = col_datetime(format = "%m/%d/%Y %H:%M"), 
                                                     +         ended_at = col_datetime(format = "%m/%d/%Y %H:%M")))
 View(tripdata_202102)

 tripdata_202103 <- read_csv("Bike data/202103-divvy-tripdata.csv", 
                              +     col_types = cols(started_at = col_datetime(format = "%m/%d/%Y %H:%M"), 
                                                     +         ended_at = col_datetime(format = "%m/%d/%Y %H:%M")))
 View(tripdata_202103)    

 tripdata_202104 <- read_csv("Bike data/202104-divvy-tripdata.csv", 
                              +     col_types = cols(started_at = col_datetime(format = "%m/%d/%Y %H:%M"), 
                                                     +         ended_at = col_datetime(format = "%m/%d/%Y %H:%M")))
 View(tripdata_202104)

 tripdata_202105 <- read_csv("Bike data/202105-divvy-tripdata.csv", 
                              +     col_types = cols(started_at = col_datetime(format = "%m/%d/%Y %H:%M"), 
                                                     +         ended_at = col_datetime(format = "%m/%d/%Y %H:%M")))
 View(tripdata_202105)

Hi andresrcs,
That is true that is from the console because when I uploaded my files I used the "import dataset" which in the console results in this
`tripdata_202006 <- read_csv("Bike data/202006-divvy-tripdata.csv",
+ col_types = cols(started_at = col_datetime(format = "%m/%d/%Y %H:%M"),
+ ended_at = col_datetime(format = "%m/%d/%Y %H:%M"),
+ start_station_id = col_character(),
+ end_station_id = col_character()))
View(tripdata_202006) july_2020 <- read_csv("Bike data 12 months/202007-divvy-tripdata/202007-divvy-tripdata.csv")
I changed the columns start_at, ended_at to DateTime and start_station_id and end_station_id to double. But why R is not recognized because of the + sign?

[andresrcs]

@Tails0298

But why R is not recognized because of the + sign?

Because using "+" signs for newlines is not part of the R syntax, those are just an artifact from the console, the correct way of writing it on a script is this one

tripdata_202006 <- read_csv("Bike data/202006-divvy-tripdata.csv",
                            col_types = cols(started_at = col_datetime(format = "%m/%d/%Y %H:%M"),
                                             ended_at = col_datetime(format = "%m/%d/%Y %H:%M"),
                                             start_station_id = col_character(),
                                             end_station_id = col_character())
                            )

[Tails0298]

Andresrcs the code worked and finally I could knit the Rmarkdown. Thank you very much