Python Pandas - 从 BusinessHour 偏移对象中以 24 小时制格式显示自定义营业时间的开始时间
要从 BusinessHour 偏移对象中以 24 小时制格式显示自定义营业时间的开始时间,请使用 BusinessHour.start 属性。
首先,导入所需的库:
import pandas as pd
在 Pandas 中设置时间戳对象:
timestamp = pd.Timestamp('2021-9-30 06:50:20')
创建 BusinessHour 偏移量。这里,“start” 是您自定义营业时间以 24 小时制表示的开始时间。“end” 是您自定义营业时间以 24 小时制表示的结束时间:
bhOffset = pd.tseries.offsets.BusinessHour(start="09:30", end = "18:00", n = 8)
显示更新后的时间戳:
显示自定义营业时间的开始时间:
print("\nThe start time of the custom business hour...\n",bhOffset.start)示例
以下是代码:
import pandas as pd
# Set the timestamp object in Pandas
timestamp = pd.Timestamp('2021-9-30 06:50:20')
# Display the Timestamp
print("Timestamp...\n",timestamp)
# Create the BusinessHour Offset
# BusinessHour is the DateOffset subclass
# 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.
bhOffset = pd.tseries.offsets.BusinessHour(start="09:30", end = "18:00", n = 8)
# Display the BusinessHour Offset
print("\nBusinessHour Offset...\n",bhOffset)
# Display the Updated Timestamp
print("\nUpdated Timestamp...\n",timestamp + bhOffset)
# Display the start time of the custom business hour
print("\nThe start time of the custom business hour...\n",bhOffset.start)输出
这将产生以下代码:
Timestamp... 2021-09-30 06:50:20 BusinessHour Offset... <8 * BusinessHours: BH=09:30-18:00> Updated Timestamp... 2021-09-30 17:30:00 The start time of the custom business hour... (datetime.time(9, 30),)
广告
数据结构
网络
关系数据库管理系统 (RDBMS)
操作系统
Java
iOS
HTML
CSS
Android
Python
C 语言编程
C++
C#
MongoDB
MySQL
Javascript
PHP