时间戳

首页 > 解决方案 > 尝试删除 python 中的第一行失败？

python - 尝试删除 python 中的第一行失败？

问题描述

嗨，我有一些 csv 格式的数据。

我有一些非常简单的代码，只是为了删除第一行：

import numpy as np
import pandas as pd
data = pd.read_csv("mydata.csv")
data = data.drop(data.columns[[0]],axis=0)
data.to_csv("mydata2.csv")

但是，运行时，我收到此错误：

Warning (from warnings module):
  File "C:/Users/george/Desktop/testing/output/PIVOTING.py", line 1
DtypeWarning: Columns (6) have mixed types. Specify dtype option on import or set low_memory=False.

Traceback (most recent call last):
  File "C:/Users/george/Desktop/testing/output/PIVOTING.py", line 5, in <module>
    data = data.drop(data.columns[[0]],axis=0)
  File "C:\Python27\lib\site-packages\pandas\core\frame.py", line 3697, in drop
    errors=errors)
  File "C:\Python27\lib\site-packages\pandas\core\generic.py", line 3111, in drop
    obj = obj._drop_axis(labels, axis, level=level, errors=errors)
  File "C:\Python27\lib\site-packages\pandas\core\generic.py", line 3143, in _drop_axis
    new_axis = axis.drop(labels, errors=errors)
  File "C:\Python27\lib\site-packages\pandas\core\indexes\base.py", line 4404, in drop
    '{} not found in axis'.format(labels[mask]))
KeyError: "['C'] not found in axis"

标签： pythonpandasnumpy

解决方案

供将来参考，pandasread_csv接受skiprows帮助完成该任务，如此处广泛介绍

推荐阅读