r - In my CSV file, it shows I have 1 column when I actually have 15 columns

Question

Closed. This question is not reproducible or was caused by typos. It is not currently accepting answers. question from:https://stackoverflow.com/questions/65868258/in-my-csv-file-it-shows-i-have-1-column-when-i-actually-have-15-columns

Answer 1

I am 99% sure that you have defined the field separator wrong. data.table::fread is really good at sniffing the correct format of csv's, and I quite often use fread even if I just convert the resulting data.table back to vanilla data frame, i.e.

library(data.table)
df <- fread("DATA ONLY.csv")
as.data.frame(df) -> df