Why I get strange error when trying to read csv file in colab?

Asked Jan 20 '22 at 13:21

Active Jan 20 '22 at 13:21

Viewed 161 times

I get strange error when trying to read csv file in colab, however no error appears when I do it on Jupiter notebook with same dataframe. Here is the error:

ParserError: Error tokenizing data. C error: EOF inside string starting at row 75397

When I do pd.read_csv("train.csv") on Jupiter it works perfectly, but in colab this error appears. How to fix it?

asked Jan 20 '22 at 13:21

Ir8_mind

Have to tried to specify encoding? e.g. `pd.read_csv("train.csv", encoding="utf-8")`? – Marco_CH Jan 20 '22 at 13:26
@Marco_CH yeah it says ```UnicodeDecodeError: 'utf-8' codec can't decode byte 0xd0 in position 0: unexpected end of data``` – Ir8_mind Jan 20 '22 at 13:28
Is it `utf-8` or maybe another one? – Marco_CH Jan 20 '22 at 13:29
@Marco_CH its utf-8 for sure – Ir8_mind Jan 20 '22 at 13:37
Ok, then could you try `pd.read_csv("train.csv", quoting=csv.QUOTE_NONE, encoding="utf-8")`? – Marco_CH Jan 20 '22 at 13:40
Or `pd.read_csv("train.csv", quoting=3, error_bad_lines=False, encoding="utf-8")` – Marco_CH Jan 20 '22 at 13:40
1

@Ir8_mind, you may find this useful https://stackoverflow.com/questions/18016037/pandas-parsererror-eof-character-when-reading-multiple-csv-files-to-hdf5 – Fareed Khan Jan 20 '22 at 13:43

Why I get strange error when trying to read csv file in colab?

0 Answers0