from pandas.tseries.offsets import CustomBusinessDay
def count_businessday(start_day,end_day):
b = CustomBusinessDay(holidays=['2020-04-06','2020-05-01','2020-05-04','2020-05-05','2020-06-25','2020-10-01',
'2020-10-05','2020-10-06','2020-10-07','2020-10-08'])
bus_day = pd.date_range(start=start_day, end=end_day, freq=b)
length = len(bus_day)
extra_work_day = ['2020-04-26','2020-05-09','2020-06-28','2020-09-27','2020-10-10']
extra_len = 0
dayday = Interval(start_day,end_day)
for i in extra_work_day:
if i in dayday:
extra_len = extra_len+1
return(length+extra_len-1)
if __name__=='__main__':
count_businessday(start_day,end_day)
sheet['工作日'] = sheet.apply(lambda x:count_businessday(x['出院时间'],x['归档日期']),axis=1)
sheet.head()
出现这个错误：
'<' not supported between instances of 'str' and 'Timestamp'
