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