Python Pandas CustomBusinessHour - 检查给定的时间戳是否在偏移量上

要检查给定的时间戳是否在偏移量上，请在Pandas中使用。将时间戳作为参数传递以进行检查。CustomBusinessHour.is_on_offset()

首先，导入所需的库-

import pandas as pd

在Pandas中设置时间戳对象-

timestamp = pd.Timestamp(2021-11-14 05:20:30)

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

cbhOffset = pd.tseries.offsets.CustomBusinessHour(start="09:30", end = "18:30")

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

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

检查给定的时间戳是否在偏移量上-

offset = cbhOffset.is_on_offset(pd.Timestamp(2021-11-20 05:20:30))

显示结果-

print("\nCheck if the given timestamp is on offset or not...\n",offset)

示例

以下是代码-

import pandas as pd #SetthetimestampobjectinPandas timestamp = pd.Timestamp(2021-11-14 05:20:30) #DisplaytheTimestamp print("Timestamp...\n",timestamp) #CreatetheCustomBusinessHourOffset #CustomBusinessHouristheDateOffsetsubclass # Here, "start" is the start time of your custom business hour in 24h format. # The "end" is the end time of your custom business hour in 24h format. cbhOffset = pd.tseries.offsets.CustomBusinessHour(start="09:30", end = "18:30") #DisplaytheCustomBusinessHourOffset print("\nCustomBusinessHour Offset...\n",cbhOffset) #AddtheoffsettotheTimestampanddisplaytheUpdatedTimestamp print("\nUpdated Timestamp...\n",timestamp + cbhOffset) #Checkifthegiventimestampisonoffsetornot offset = cbhOffset.is_on_offset(pd.Timestamp(2021-11-20 05:20:30)) #displaytheresult print("\nCheck if the given timestamp is on offset or not...\n",offset)输出结果

这将产生以下代码-

Timestamp... 2021-11-14 05:20:30 CustomBusinessHour Offset... <CustomBusinessHour: CBH=09:30-18:30> Updated Timestamp... 2021-11-15 10:30:00 Check if the given timestamp is on offset or not... False