Python Pandas CustomBusinessHour - 向后滚动提供的日期

要向后滚动提供的日期，请使用Pandas中的方法。首先，导入所需的库-CustomBusinessHour.rollback()

import pandas as pd

在Pandas中设置时间戳对象-

timestamp = pd.Timestamp(2021-12-20 08:35:10)

创建CustomBusinessHour偏移量。CustomBusinessHour是DateOffset子类-

cbhOffset = pd.tseries.offsets.CustomBusinessHour(n = 5, weekmask = Mon Tue Wed Fri)

将偏移量添加到时间戳并显示更新的时间戳-

print("\nUpdated Timestamp...\n",timestamp + cbhOffset)

如果不在偏移上，则向后滚动-

roll_back = cbhOffset.rollback(pd.Timestamp(2021-12-18 08:35:10))

显示结果-

print("\nRoll Backward Result...\n",roll_back)

示例

以下是代码-

import pandas as pd #SetthetimestampobjectinPandas timestamp = pd.Timestamp(2021-12-20 08:35:10) #DisplaytheTimestamp print("Timestamp...\n",timestamp) #CreatetheCustomBusinessHourOffset #CustomBusinessHouristheDateOffsetsubclass #Weekmaskofvalidbusinessdays cbhOffset = pd.tseries.offsets.CustomBusinessHour(n = 5, weekmask = Mon Tue Wed Fri) #DisplaytheCustomBusinessHourOffset print("\nCustomBusinessHour Offset...\n",cbhOffset) #AddtheoffsettotheTimestampanddisplaytheUpdatedTimestamp print("\nUpdated Timestamp...\n",timestamp + cbhOffset) #rollbackwardifnotonoffset roll_back = cbhOffset.rollback(pd.Timestamp(2021-12-18 08:35:10)) #displaytheresult print("\nRoll Backward Result...\n",roll_back)输出结果

这将产生以下代码-

Timestamp... 2021-12-20 08:35:10 CustomBusinessHour Offset... <5 * CustomBusinessHours: CBH=09:00-17:00> Updated Timestamp... 2021-12-20 14:00:00 Roll Backward Result... 2021-12-17 17:00:00