I was able to get the data uploaded. I'm still not sure what caused the problem, but here is the info you requested along with the troubleshooting steps I performed. (I also sent an email over with a sample of the first 150 rows of the data (I tried uploading this sample and received the same error).
Here is the info you requested:
- PC - Windows 10
- Python version 3.7.4
- Pandas Verion 0.25.1
Here is some troubleshooting that I have done:
- I tried setting the
line_terminator argument to
'\n but that caused a different error when uploading (although I don't recall the error. I can do it again if you want that error message).
- I used a different python and pandas verion (python 3.8.3 with pandas 1.0.3). Still got the error.
- I converted the data value column to a string/object dtype. Then, ran
.str.strip(r'\r') on the series representing that column, and then wrote it to csv. Still got the error.
None of these worked. I then removed any lines in the dataframe that corresponded to weekends (which removed the problem line), wrote it to csv, and then uploaded it successfully. (I probably should have tried this first).
Another thing that seemed to work was when I simply changed the column header of the data column to a different name. This actually allowed me to upload the original file without the problem line being removed.
Anyways, thanks for your help. I was able to get it uploaded. If you need any more information from me to help you troubleshoot anything on your end, please do let me know.