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

Question

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?

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
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
@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

score 0 · Answer 1 · answered Jul 07 '22 at 14:13

This happened to me. What happens is that it's reading the HTML encoded file. This is how I solved it:

Open the GitHub repository page in your web browser.
Click on the dataset file you want to read from the GitHub repository. A preview of the file will open.
You will find a "Raw" button close to the upper right corner of the file preview. ...
Copy this URL and paste in your google colab using this code.

import pandas as pd df = pd.read_csv('https://raw.githubusercontent.com/<username>/publicfile.csv')

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

1 Answers1