Python Pandas CustomBusinessHour偏移量对象 – 移动到下一个工作日
要移动到下一个工作日,可以使用Pandas中的CustomBusinessHour.next_bday属性。首先,导入所需的库-
import pandas as pd
在Pandas中设置时间戳对象-
timestamp = pd.Timestamp('2021-12-20 08:35:10')
创建CustomBusinessHour Offset。CustomBusinessHour是DateOffset子类-
cbhOffset = pd.tseries.offsets.CustomBusinessHour(start = '09:30', end = '18:00', n = 5, weekmask = 'Mon Tue Wed Fri')
显示CustomBusinessHour Offset-
print("\nCustomBusinessHour偏移量...\n", cbhOffset)
显示下一个工作日-
print("\n下一个工作日...\n", timestamp + cbhOffset.next_bday)
示例
以下是代码-
import pandas as pd
# 在Pandas中设置时间戳对象
timestamp = pd.Timestamp('2021-12-20 08:35:10')
# 显示时间戳
print("时间戳...\n", timestamp)
# 创建CustomBusinessHour Offset
# CustomBusinessHour是DateOffset子类
# 有效工作日的Weekmask
cbhOffset = pd.tseries.offsets.CustomBusinessHour(start = '09:30', end = '18:00', n = 5, weekmask = 'Mon Tue Wed Fri')
# 显示CustomBusinessHour Offset
print("\nCustomBusinessHour偏移量...\n", cbhOffset)
# 显示下一个工作日
print("\n下一个工作日...\n", timestamp + cbhOffset.next_bday)
输出
这将生成以下代码-
时间戳...
2021-12-20 08:35:10
CustomBusinessHour偏移量...
<5 * CustomBusinessHours: CBH=09:30-18:00>
下一个工作日...
2021-12-21 08:35:10
极客教程