reading in a csv datafile

I am trying to read in a new csv file using this code
...
recent <- read.csv("August2020.csv")
The file "August2020.csv" is in my working directory. R will send this error message
...
Error in read.table(file = file, header = header, sep = sep, quote = quote, :
duplicate 'row.names' are not allowed

Other csv files in my directory R will read, but not this one. Is something wrong with "August2020.csv", if not, how can I read it in?

I suspect R thinks that there are fewer header columns than data columns and is interpreting the first data column as row names. Take a look at the first row of the csv file and see if any of the header names are malformed. You might even change them to something very simple as a test.

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.