Python 脚本可以工作，但抛出错误 - pandas.errors 标记数据

Question

我是Python新手。我正在尝试从请求读取 json 响应并使用 pandas 进行过滤以保存在 csv 文件中。该脚本可以工作并为我提供所有数据，但执行后会抛出此错误 -

我无法弄清楚为什么它会抛出此错误？我怎样才能通过这个错误？

错误 -

 script.py line 42, in <module>

 df = pd.read_csv("Data_script4.csv")

 File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-    

 packages/pandas/io/parsers.py", line 686, in read_csv

 return _read(filepath_or_buffer, kwds)

 File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-   

 packages/pandas/io/parsers.py", line 458, in _read

 data = parser.read(nrows)

 File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-   

 packages/pandas/io/parsers.py", line 1196, in read

 ret = self._engine.read(nrows)

 File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-  

 packages/pandas/io/parsers.py", line 2155, in read

 data = self._reader.read(nrows)

 File "pandas/_libs/parsers.pyx", line 847, in pandas._libs.parsers.TextReader.read

 File "pandas/_libs/parsers.pyx", line 862, in   

 pandas._libs.parsers.TextReader._read_low_memory

 File "pandas/_libs/parsers.pyx", line 918, in pandas._libs.parsers.TextReader._read_rows

 File "pandas/_libs/parsers.pyx", line 905, in   

 pandas._libs.parsers.TextReader._tokenize_rows

 File "pandas/_libs/parsers.pyx", line 2042, in pandas._libs.parsers.raise_parser_error

 pandas.errors.ParserError: Error tokenizing data. C error: Expected 9 fields in line 53,    

 saw 10

Answer 1

这是要点：您需要替换：df = pd.read_csv("Data_script4.csv")有了这个：df = pd.read_csv('Data_script4.csv', error_bad_lines=False)