我正在尝试运行此代码,该代码从数据框中删除不必要的列以供以后处理。它遍历第一个文件,然后给出以下错误。在它运行良好之前。我看到它可能是一个损坏的文件,所以我删除了所有以前的文件,并重新生成了步骤中的所有文件,但我仍然收到错误消息。对不起,如果它冗长,我需要展示我论文的每一步,而且我仍然是一个新手程序员。任何人都可以帮助解决这个问题吗?
代码是:
import pandas as pd
import os
path = ('./Sketch_grammar/weighted/')
files = os.listdir(path)
for file in files:
df = pd.read_csv(path+file)
df = df.drop('Hits', axis=1)
df = df.drop('Score', axis=1)
df = df.drop('Score.1', axis=1)
print(df)
filename = os.path.splitext(file)
(f, ext) = filename
print(f)
df.to_csv(path+'weighted_out/'+f+'_out.csv', index=False)
错误信息如下:
Traceback (most recent call last):
File "/home/sandra/git/trees/trees/remove_columns.py", line 9, in <module>
df = pd.read_csv(path+file)
File "/home/sandra/miniconda3/lib/python3.6/site-packages/pandas/io/parsers.py", line 678, in parser_f
return _read(filepath_or_buffer, kwds)
File "/home/sandra/miniconda3/lib/python3.6/site-packages/pandas/io/parsers.py", line 440, in _read
parser = TextFileReader(filepath_or_buffer, **kwds)
File "/home/sandra/miniconda3/lib/python3.6/site-packages/pandas/io/parsers.py", line 787, in __init__
self._make_engine(self.engine)
File "/home/sandra/miniconda3/lib/python3.6/site-packages/pandas/io/parsers.py", line 1014, in _make_engine
self._engine = CParserWrapper(self.f, **self.options)
File "/home/sandra/miniconda3/lib/python3.6/site-packages/pandas/io/parsers.py", line 1708, in __init__
self._reader = parsers.TextReader(src, **kwds)
File "pandas/_libs/parsers.pyx", line 539, in pandas._libs.parsers.TextReader.__cinit__
File "pandas/_libs/parsers.pyx", line 737, in pandas._libs.parsers.TextReader._get_header
File "pandas/_libs/parsers.pyx", line 932, in pandas._libs.parsers.TextReader._tokenize_rows
File "pandas/_libs/parsers.pyx", line 2112, in pandas._libs.parsers.raise_parser_error
相关分类