Pandas Reading csv - Error

Question

I have a problem with reading a CSV file with pandas (I know there are other topics but I could not solve the problem). My code is:

import pandas as pd
f = pd.read_csv('1803Ltem.csv',sep='\t', dtype=object,)

The error I get is:

    Traceback (most recent call last):
  File "/username/username/Documents/first.py", line 362, in <module>
    fuck = pd.read_csv('1803Ltem.csv',sep='\t', dtype=object,)
  File "/Users/username/anaconda/lib/python3.5/site-packages/pandas/io/parsers.py", line 562, in parser_f
    return _read(filepath_or_buffer, kwds)
  File "/Users/username/anaconda/lib/python3.5/site-packages/pandas/io/parsers.py", line 325, in _read
    return parser.read()
  File "/Users/username/anaconda/lib/python3.5/site-packages/pandas/io/parsers.py", line 815, in read
    ret = self._engine.read(nrows)
  File "/Users/username/anaconda/lib/python3.5/site-packages/pandas/io/parsers.py", line 1314, in read
    data = self._reader.read(nrows)
  File "pandas/parser.pyx", line 805, in pandas.parser.TextReader.read (pandas/parser.c:8748)
  File "pandas/parser.pyx", line 827, in pandas.parser.TextReader._read_low_memory (pandas/parser.c:9003)
  File "pandas/parser.pyx", line 881, in pandas.parser.TextReader._read_rows (pandas/parser.c:9731)
  File "pandas/parser.pyx", line 868, in pandas.parser.TextReader._tokenize_rows (pandas/parser.c:9602)
  File "pandas/parser.pyx", line 1865, in pandas.parser.raise_parser_error (pandas/parser.c:23325)
pandas.io.common.CParserError: Error tokenizing data. C error: Expected 4 fields in line 4587, saw 5

What am I doing wrong?

The error indicates that one of the rows has 5 fields instead of 4. In other words in line 4587, there are 4 tabs instead of 3. — James
– James, Commented Dec 17, 2016 at 19:57

Ted Petrou · Accepted Answer · 2016-12-17 20:43:29Z

2

Try adding the argument error_bad_lines=False to read_csv

answered Dec 17, 2016 at 20:43

Ted Petrou

62.4k19 gold badges139 silver badges139 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

n4321d · Accepted Answer · 2022-08-26 21:20:41Z

0

The following worked for me by adding:

import pandas as pd
f = pd.read_csv('1803Ltem.csv',sep='\t', dtype=object,error_bad_lines=False)

edited Aug 26, 2022 at 21:20

n4321d

1,2232 gold badges16 silver badges33 bronze badges

answered Aug 23, 2022 at 11:14

Ahmed Ali

711 silver badge2 bronze badges

1 Comment

Community Over a year ago

Your answer could be improved with additional supporting information. Please edit to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers in the help center.

Collectives™ on Stack Overflow

Pandas Reading csv - Error

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related