Error reading csv files
by Debojit23 - Tuesday, March 29, 2022, 10:58:27

I tried to read the 'css_main_training.csv' using pandas.

main_train = pd.read_csv('../input/fedciss2022/css_main_training/css_main_training.csv')

I am running into this following error :

ParserError: Error tokenizing data. C error: Expected 1 fields in line 27847, saw 2

If anyone have a solution to read the csv files, please do help out.

RE: Error reading csv files
by antoni-jamiolkowski - Tuesday, March 29, 2022, 12:24:57


You should check separator in the file and a default separator in the pandas function :) In css_main_training.csv it is semicolon (;) yet in the pandas function the default is comma (,).

>>> import pandas as pd
>>> data = pd.read_csv("css_main_training.csv", sep=";")

Best regards,

Antoni JamioĊ‚kowski

RE: Error reading csv files
by Debojit23 - Wednesday, March 30, 2022, 12:05:19

thanks a lot!!