python - 未实现错误 : file structure not yet supported from pandas read_csv

Question

当我在此 file 上运行下面的代码时，我得到一个 NotImplementedError: file structure not yet supported

import constants, pandas, pdb
from datetime import datetime, timedelta

df = pandas.read_csv('300113R1.DNC', skiprows = 11, delim_whitespace=True,usecols=['Y','M','D','PRCP'],
                     parse_dates={"datetime": [0,1,2]}, index_col="datetime",
                    date_parser=lambda x: pandas.datetime.strptime(x, '%Y %m %d'))

知道可能出了什么问题吗？关于同一数据集的较小样本的相关查询在这里: Date parse error in Python pandas while reading file

Answer 1

感谢@cosmoscalibur 发现您的文件缺少列，一种解决方案是跳过解析标题:

df = pandas.read_csv('300113R1.DNC', skiprows = 12, delim_whitespace=True,usecols=[0,1,2,3], header=None
                     parse_dates={"datetime": [0,1,2]}, index_col="datetime",
                    date_parser=lambda x: pandas.datetime.strptime(x, '%Y %m %d'))

这将要求您在加载后将单列从“3”重命名为“PRCP”:

df = df.rename(columns={3:'PRCP'})