Geek Answers Handbook

Python 3 Pandas Error: pandas.parser.CParserError: error tokenization data. Error C: expected 11 fields on line 5, 13

I checked this answer as I have a similar problem.

Python Pandas Error Market Data

However, for some reason ALL of my lines are skipped.

My code is simple:

import pandas as pd

fname = "data.csv"
input_data = pd.read_csv(fname)

and I get the following message:

  File "preprocessing.py", line 8, in <module>
    input_data = pd.read_csv(fname) #raw data file ---> pandas.core.frame.DataFrame type
  File "/Library/Frameworks/Python.framework/Versions/3.4/lib/python3.4/site-packages/pandas/io/parsers.py", line 465, in parser_f
    return _read(filepath_or_buffer, kwds)
  File "/Library/Frameworks/Python.framework/Versions/3.4/lib/python3.4/site-packages/pandas/io/parsers.py", line 251, in _read
    return parser.read()
  File "/Library/Frameworks/Python.framework/Versions/3.4/lib/python3.4/site-packages/pandas/io/parsers.py", line 710, in read
    ret = self._engine.read(nrows)
  File "/Library/Frameworks/Python.framework/Versions/3.4/lib/python3.4/site-packages/pandas/io/parsers.py", line 1154, in read
    data = self._reader.read(nrows)
  File "pandas/parser.pyx", line 754, in pandas.parser.TextReader.read (pandas/parser.c:7391)
  File "pandas/parser.pyx", line 776, in pandas.parser.TextReader._read_low_memory (pandas/parser.c:7631)
  File "pandas/parser.pyx", line 829, in pandas.parser.TextReader._read_rows (pandas/parser.c:8253)
  File "pandas/parser.pyx", line 816, in pandas.parser.TextReader._tokenize_rows (pandas/parser.c:8127)
  File "pandas/parser.pyx", line 1728, in pandas.parser.raise_parser_error (pandas/parser.c:20357)
pandas.parser.CParserError: Error tokenizing data. C error: Expected 11 fields in line 5, saw 13
+4
source share
5 answers

The solution is to use pandas built-in sniffing delimiter.

input_data = pd.read_csv(fname, sep=None)
+9
source

, , , .xls, true.csv. csv .

+4

, csv, :   d1 = pd.read_json('my.csv')   d1 = pd.read_json('my.csv', sep='\t') . , ",", ",", , , . pandas.read_csv

+2

. CSV , R, , "" CSV .

, read.table R, , write.csv row.names = F

, .

0

More articles:


All Articles