asfreq(BDay())类型错误。是否使用所有列数据计数?

2024-09-19 23:29:12 发布

您现在位置:Python中文网/ 问答频道 /正文

试图在一个范围内找到工作日数。所以这是我得到的

df['ENTRYDATE'] = pd.to_datetime(df['ENTRYDATE'], errors='coerce')
df['REQDATE'] = pd.to_datetime(df['REQDATE'], errors='coerce')
df['DELDATE'] = pd.to_datetime(df['DELDATE'], errors='coerce')
df['SHIPCONFIRMED'] = pd.to_datetime(df['SHIPCONFIRMED'], errors='coerce')
#df['DAYSLATE'] = df['DELDATE'] - df['REQDATE']
req_date = df['REQDATE']
del_date = df['DELDATE']
df['DAYSLATE'] = df.ix[req_date:del_date].asfreq(BDay()).count()

但是我得到一个TypeError它看起来像是在读取整个列,而不是只处理那一行的数据

TypeError: '['2017-05-26T00:00:00.000000000' '2017-05-04T00:00:00.000000000' '2017-05-22T00:00:00.000000000' '2017-05-12T00:00:00.000000000' '2017-05-12T00:00:00.000000000' '2017-05-16T00:00:00.000000000' '2017-04-27T00:00:00.000000000' '2017-05-26T00:00:00.000000000' ... ... '2017-05-18T00:00:00.000000000' '2017-05-29T00:00:00.000000000' '2017-05-02T00:00:00.000000000' '2017-05-02T00:00:00.000000000' '2017-05-17T00:00:00.000000000' '2017-04-28T00:00:00.000000000']' is an invalid key

如有任何帮助或指导,我们将不胜感激


Tags: todfdatetimedatereqpddelerrors