Python Pandas BusinessHour 偏移对象 - 移至下一个工作日


使用 Pandas 中的 BusinessHour.next_bday 属性将当前时间移动到下一个工作日。首先导入所需的库 -

import datetime
import pandas as pd

创建 BusinessHour 偏移。BusinessHour 是 DateOffset 子类 -

bhOffset = pd.tseries.offsets.BusinessHour(offset = datetime.timedelta(days = 3, hours = 3))

显示 BusinessHour 偏移 -

print("\nBusinessHour Offset...\n",bhOffset)

在 Pandas 中设置时间戳对象 -

timestamp = pd.Timestamp('2021-9-30 06:50:20')

显示下一个工作日 -

print("\nThe next business day...\n",timestamp + bhOffset.next_bday)

示例

以下是代码 -

import datetime
import pandas as pd

# Set the timestamp object in Pandas
timestamp = pd.Timestamp('2021-9-30 06:50:20')

# Display the Timestamp
print("Timestamp...\n",timestamp)

# Create the BusinessHour Offset
# BusinessHour is the DateOffset subclass
bhOffset = pd.tseries.offsets.BusinessHour(offset = datetime.timedelta(days = 3, hours = 3))
# Display the BusinessHour Offset
print("\nBusinessHour Offset...\n",bhOffset)

# Display the next business day
print("\nThe next business day...\n",timestamp + bhOffset.next_bday)

输出

此代码会产生以下 -

Timestamp...
 2021-09-30 06:50:20

BusinessHour Offset...
 <BusinessHour: offset=datetime.timedelta(days=3, seconds=10800): BH=09:00-17:00>

The next business day...
 2021-10-01 06:50:20

更新于: 2021-10-21

239 次浏览

启动你的 职业生涯

通过完成课程获取认证

开始
广告
© . All rights reserved.