Python Pandas CustomBusinessHour 偏移对象 - 移至下一个工作日
要转到下一个工作日,请使用CustomBusinessHour.next_bdayPandas中的属性。首先,导入所需的库-
import pandas as pd
在Pandas中设置时间戳对象-
timestamp = pd.Timestamp('2021-12-20 08:35:10')
创建CustomBusinessHour偏移量。CustomBusinessHour是DateOffset子类-
cbhOffset = pd.tseries.offsets.CustomBusinessHour(start ='09:30', end ='18:00', n = 5, weekmask = 'Mon Tue Wed Fri')
显示CustomBusinessHour偏移量-
print("\nCustomBusinessHour Offset...\n",cbhOffset)
显示下一个工作日-
print("\nThe next business day...\n",timestamp + cbhOffset.next_bday)
示例
以下是代码-
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(start ='09:30', end ='18:00', n = 5, weekmask = 'Mon Tue Wed Fri') #DisplaytheCustomBusinessHourOffset print("\nCustomBusinessHour Offset...\n",cbhOffset) #Displaythenextbusinessday print("\nThe next business day...\n",timestamp + cbhOffset.next_bday)输出结果
这将产生以下代码-
Timestamp... 2021-12-20 08:35:10 CustomBusinessHour Offset... <5 * CustomBusinessHours: CBH=09:30-18:00> The next business day... 2021-12-21 08:35:10