I tried to read a csv dataset file in R with read.csv but every observation is showing with a \t next to it (screenshot attached).
code: generate <- read.csv("~/Desktop/Datasets/ElectricGenerationCapacityandEnergy/Generation-Table1.csv", fileEncoding="UTF-8-BOM",sep = ",")
I've tried specifying the separator (sep = ",") and file encoding (fileEncoding="UTF-8-BOM"). I have also tried the read.delim function and setting my working directory to the correct place. None of my attempts were successful. enter image description here Would appreciate any help with this one. Thank you!
