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 ?
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.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