close

[Solved] pandas.parser.CParserError: Error tokenizing data. C error: Expected 2 fields in line 3, saw 12

Hello Guys, How are you all? Hope You all Are Fine. Today I am trying to read csv file But I am facing following error pandas.parser.CParserError: Error tokenizing data. C error: Expected 2 fields in line 3, saw 12 in Python. So Here I am Explain to you all the possible solutions here.

Without wasting your time, Let’s start This Article to Solve This Error.

How pandas.parser.CParserError: Error tokenizing data. C error: Expected 2 fields in line 3, saw 12 Error Occurs ?

I am trying to read csv file But I am facing following error.

pandas.parser.CParserError: Error tokenizing data. C error: Expected 2 fields in line 3, saw 12

Here is my code that I am trying to excecute.

StudentData = 'stdseven.csv'
#print("data read start")
data = pd.read_csv(StudentData)

How To Solve pandas.parser.CParserError: Error tokenizing data. C error: Expected 2 fields in line 3, saw 12 Error ?

  1. How To Solve pandas.parser.CParserError: Error tokenizing data. C error: Expected 2 fields in line 3, saw 12 Error ?

    To Solve pandas.parser.CParserError: Error tokenizing data. C error: Expected 2 fields in line 3, saw 12 Error I think This error might be occurs cause of bad lines presence in your csv file. So you just need to ignore this bad lines. Just use error_bad_lines to False. data = pd.read_csv(‘yourfile.csv’, error_bad_lines=False) This will skip bad lines. Now, Your error must be solved. Second solution is Just try to specify the Sep using the tab character (\t) using separator /t. so, try to open using following code line: data=pd.read_csv(“yourfile.csv”, sep=’\t’) Now, your error should be solved.

  2. pandas.parser.CParserError: Error tokenizing data. C error: Expected 2 fields in line 3, saw 12

    To Solve pandas.parser.CParserError: Error tokenizing data. C error: Expected 2 fields in line 3, saw 12 Error I think This error might be occurs cause of bad lines presence in your csv file. So you just need to ignore this bad lines. Just use error_bad_lines to False. data = pd.read_csv(‘yourfile.csv’, error_bad_lines=False) This will skip bad lines. Now, Your error must be solved. Second solution is Just try to specify the Sep using the tab character (\t) using separator /t. so, try to open using following code line: data=pd.read_csv(“yourfile.csv”, sep=’\t’) Now, your error should be solved.

Solution 1: Ignore bad lines

I think This error might be occurs cause of bad lines presence in your csv file. So you just need to ignore this bad lines. Just use error_bad_lines to False.

data = pd.read_csv('yourfile.csv', error_bad_lines=False)

This will skip bad lines. Now, Your error must be solved.

Solution 2: specify the sep

Just try to specify the Sep using the tab character (\t) using separator /t. so, try to open using following code line.

data=pd.read_csv("yourfile.csv", sep='\t')

Now, your error should be solved.

Summary

It’s all About this issue. Hope all solution helped you a lot. Comment below Your thoughts and your queries. Also, Comment below which solution worked for you?

Also, Read

Leave a Comment