Hello everyone,
I hope you do not mind helping me with this likely quite simple problem I am having.
I am trying to read multiple .csv files within a folder into R and combine these files into one longer file. I have done some research and found that there are a bunch of different ways to successfully do this! However, I am running into one small problem: The .csv files that I am working with are use semicolons to separate data rather than using a comma as usual.
When I am running my code, I am therefore having a problem reading in these data files.
I am hoping someone doesn't mind helping with this .
Below I have included what is my current, unsuccessful code. Here you can see that I am trying to read in multiple files (a number of files that will increase weekly). But do not know how to take into consideration the ";" separator in my .csv files.
'''
folderfiles <- list.files("PATH", pattern = "*.csv", full.names = TRUE)
data_csv <- ldply(folderfiles, read_csv)
'''
Note: I have also tried the following unsuccessfully:
'''
folderfiles <- list.files("PATH", pattern = "*.csv", full.names = TRUE)
data_csv <- ldply(folderfiles, read_delim(delim = ";"))
'''