python 函数 日期区间,Python / Pandas中是否有一个函数可以获取两个日期之间的营业时间增量？...

I've got a pandas dataframe with two datetime columns and I would like to calculate the timedelta between the columns in "business minutes". It's easy to add business timedeltas using the offsets method, but I can't seem to find something built in that returns a timedelta in business days, hours, minutes, seconds. I'm very new to Python so it's very likely I'm missing something.

Thanks,

Nick

解决方案

I don't think there's a way in numpy/pandas, but you can do it with python lib businesstime:

>>> datetime(2013, 12, 26, 5) - datetime(2013, 12, 23, 12)

datetime.timedelta(2, 61200)

>>> bt = businesstime.BusinessTime(holidays=businesstime.holidays.usa.USFederalHolidays())

>>> bt.businesstimedelta(datetime(2013, 12, 23, 12), datetime(2013, 12, 26, 5))

datetime.timedelta(1, 18000)