python - Pandas file structure not supported error -
i notimplementederror: file structure not yet supported
when run code below on file
import constants, pandas, pdb 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'))
any idea on might going wrong? related query on smaller sample of same dataset here: date parse error in python pandas while reading file
thanks @cosmoscalibur spotting file missing columns, 1 solution skip parsing header:
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'))
this require rename single column '3' 'prcp' after loading:
df = df.rename(columns={3:'prcp'})
Comments
Post a Comment