Python Pandas - 获取应用于 CustomBusinessHour 偏移量的周掩码
要在CustomBusinessHour偏移量上应用周掩码,请使用CustomBusinessHour.weekmaskPandas中的属性。
首先,导入所需的库-
import pandas as pd
在Pandas中设置时间戳对象-
timestamp = pd.Timestamp('2021-11-14 05:20:30')
创建CustomBusinessHour偏移量。CustomBusinessHour是DateOffset子类。有效工作日的周掩码-
cbhOffset = pd.tseries.offsets.CustomBusinessHour(n = 7, weekmask = 'Mon Tue Wed Fri')
将偏移量添加到时间戳并显示更新的时间戳-
print("\nUpdated Timestamp...\n",timestamp + cbhOffset)
显示周掩码-
print("\nThe weekmask on the CustomBusinessHour object..\n", cbhOffset.weekmask)
示例
以下是代码-
import pandas as pd #SetthetimestampobjectinPandas timestamp = pd.Timestamp('2021-11-14 05:20:30') #DisplaytheTimestamp print("Timestamp...\n",timestamp) #CreatetheCustomBusinessHourOffset #CustomBusinessHouristheDateOffsetsubclass #Weekmaskofvalidbusinessdays cbhOffset = pd.tseries.offsets.CustomBusinessHour(n = 7, weekmask = 'Mon Tue Wed Fri') #DisplaytheCustomBusinessHourOffset print("\nCustomBusinessHour Offset...\n",cbhOffset) #AddtheoffsettotheTimestampanddisplaytheUpdatedTimestamp print("\nUpdated Timestamp...\n",timestamp + cbhOffset) #ReturnfrequencyappliedonthegivenCustomBusinessHourOffsetobjectasastring print("\nFrequency applied on the given CustomBusinessHour Offset object...\n",cbhOffset.freqstr) #displaytheweekmask print("\nThe weekmask on the CustomBusinessHour object..\n", cbhOffset.weekmask)输出结果
这将产生以下代码-
Timestamp... 2021-11-14 05:20:30 CustomBusinessHour Offset... <7 * CustomBusinessHours: CBH=09:00-17:00> Updated Timestamp... 2021-11-15 16:00:00 Frequency applied on the given CustomBusinessHour Offset object... 7CBH The weekmask on the CustomBusinessHour object.. Mon Tue Wed Fri