最近的Python工作日 [英] Most recent previous business day in Python

问题描述

我需要从当前日期减去个工作日。

I need to subtract business days from the current date.

我目前有一些需要始终在最近一个工作日运行的代码。如果今天是星期一至星期五，则可能是今天，但是如果是星期六或星期日，则需要将其设置回周末之前的星期五。我目前有一些漂亮的笨拙代码来做到这一点：

I currently have some code which needs always to be running on the most recent business day. So that may be today if we're Monday thru Friday, but if it's Saturday or Sunday then I need to set it back to the Friday before the weekend. I currently have some pretty clunky code to do this:

 lastBusDay = datetime.datetime.today()
 if datetime.date.weekday(lastBusDay) == 5:      #if it's Saturday
     lastBusDay = lastBusDay - datetime.timedelta(days = 1) #then make it Friday
 elif datetime.date.weekday(lastBusDay) == 6:      #if it's Sunday
     lastBusDay = lastBusDay - datetime.timedelta(days = 2); #then make it Friday

还有更好的方法吗？

例如，我可以告诉timedelta在工作日而不是日历日工作吗？

Can I tell timedelta to work in weekdays rather than calendar days for example?

推荐答案

使用熊猫！

import datetime
import pandas as pd
# BDay is business day, not birthday...
from pandas.tseries.offsets import BDay

today = datetime.datetime.today()
print(today - BDay(4))

由于今天是9月26日，星期四给您输出：

Since today is Thursday, Sept 26, that will give you an output of:

datetime.datetime(2013, 9, 20, 14, 8, 4, 89761)

这篇关于最近的Python工作日的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！