Import CSV file using R

Question

I'm attempting to import a csv file into Excel.

However I keep receiving this error message when I use data = read.csv(C:UsersldayzOneDriveDocumentsrating)

"data = read.csv(C:Users)" fails with an unexpected symbol.

The files directory was copied from details, so it should be correct. Is there anything I'm missing here?

Answer 1

If there are quotes ("), by using the code in the OP's post

str(read.csv("devices.csv",sep=",",header = TRUE))
#'data.frame':  2 obs. of  1 variable:
#$ A.B.C.D.E: Factor w/ 2 levels "1,2,3,4,5","6,7,8,9,10": 1 2

We could remove the " with gsub after reading the data with readLines and then use read.table

read.csv(text=gsub('"', '', readLines('devices.csv')), sep=",", header=TRUE)
#  A B C D  E
#1 1 2 3 4  5
#2 6 7 8 9 10

Another option if we are using linux would be to remove quotes with awk and pipe with read.csv

  read.csv(pipe("awk  'gsub(/\"/,\"\",$1)' devices.csv")) 
  #  A B C D  E
  #1 1 2 3 4  5
  #2 6 7 8 9 10

Unleash the power of data with our comprehensive Data Science Training.