Python Pandas - 从 CustomBusinessHour 偏移对象以 24 小时格式显示自定义营业时间的结束时间
要从CustomBusinessHour偏移量对象以24小时格式显示自定义营业时间的结束时间,请使用CustomBusinessHour.endPandas中的属性。
首先,导入所需的库-
import pandas as pd
在Pandas中设置时间戳对象-
timestamp = pd.Timestamp('2021-11-14 05:20:30')
创建CustomBusinessHour偏移量。此处,“开始”是24小时格式的自定义营业时间的开始时间。“结束”是24小时格式的自定义营业时间的结束时间-
cbhOffset = pd.tseries.offsets.CustomBusinessHour(start="09:30", end = "18:30", n = 5)
将偏移量添加到时间戳并显示更新的时间戳-
print("\nUpdated Timestamp...\n",timestamp + cbhOffset)
显示自定义营业时间的结束时间-
print("\nThe end time of the custom business hour...\n",cbhOffset.end)
示例
以下是代码-
import pandas as pd #在Pandas中设置时间戳对象 timestamp = pd.Timestamp('2021-11-14 05:20:30') #显示时间戳 print("Timestamp...\n",timestamp) #创建CustomBusinessHour偏移量 #CustomBusinessHour是DateOffset子类 # 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", n = 5) #显示CustomBusinessHour偏移量 print("\nCustomBusinessHour Offset...\n",cbhOffset) #将偏移量添加到时间戳并显示更新的时间戳 print("\nUpdated Timestamp...\n",timestamp + cbhOffset) #显示自定义营业时间的结束时间 print("\nThe end time of the custom business hour...\n",cbhOffset.end)输出结果
这将产生以下代码-
Timestamp... 2021-11-14 05:20:30 CustomBusinessHour Offset... <5 * CustomBusinessHours: CBH=09:30-18:30> Updated Timestamp... 2021-11-15 14:30:00 The end time of the custom business hour... (datetime.time(18, 30),)