数据结构
网络
RDBMS
操作系统
Java
MS Excel
iOS
HTML
CSS
Android
Python
C 编程
C++
C#
MongoDB
MySQL
Javascript
PHP
物理
化学
生物
数学
英语
经济
心理
社会研究
时尚研究
法律研究Python Pandas - 创建一个 BusinessHour 偏移
要创建 BusinessHour 偏移，请在 Pandas 中使用 pd.tseries.offsets.BusinessHour() 方法。首先，导入必需的库 -
import pandas as pd
创建 BusinessHour 偏移。BusinessHour 是 DateOffset 子类。在此，“start”是自定义营业时间的 24 小时制开始时间。“end”是自定义营业时间的 24 小时制结束时间 -
bhOffset = pd.tseries.offsets.BusinessHour(start="09:30", end = "18:00")
在 Pandas 中设置时间戳对象 -
timestamp = pd.Timestamp('2021-1-1 01:55:30')将偏移添加到时间戳并显示更新后的时间戳
print("\nUpdated Timestamp...\n",timestamp + bhOffset)
示例
以下是代码 -
import pandas as pd
# Set the timestamp object in Pandas
timestamp = pd.Timestamp('2021-1-1 01:55:30')
# 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")
# Display the BusinessHour Offset
print("\nBusinessHour Offset...\n",bhOffset)
# Add the offset to the Timestamp and display the Updated Timestamp
print("\nUpdated Timestamp...\n",timestamp + bhOffset)输出
这将生成以下代码 -
Timestamp... 2021-01-01 01:55:30 BusinessHour Offset... <BusinessHour: BH=09:30-18:00> Updated Timestamp... 2021-01-01 10:30:00
更新于：21-Oct-2021
128 浏览量
广告