数据结构
网络
关系型数据库管理系统(RDBMS)
操作系统
Java
MS Excel
iOS
HTML
CSS
Android
Python
C 编程
C++
C#
MongoDB
MySQL
Javascript
PHP
物理
化学
生物
数学
英语
经济学
心理学
社会学
时装研究
法律研究Python Pandas CustomBusinessHour 偏移对象 - 移至下一个工作日
要在 Pandas 中移至下一个工作日，请使用 CustomBusinessHour.next_bday 属性。首先，导入所需的库 −
import pandas as pd
在 Pandas 中设置时间戳对象 −
timestamp = pd.Timestamp('2021-12-20 08:35:10')
创建 CustomBusinessHour Offset。CustomBusinessHour 是 DateOffset 子类 −
cbhOffset = pd.tseries.offsets.CustomBusinessHour(start ='09:30', end ='18:00', n = 5, weekmask = 'Mon Tue Wed Fri')
显示 CustomBusinessHour Offset −
print("\nCustomBusinessHour Offset...\n",cbhOffset)
显示下一个工作日 −
print("\nThe next business day...\n",timestamp + cbhOffset.next_bday)示例
以下是代码 −
import pandas as pd
# Set the timestamp object in Pandas
timestamp = pd.Timestamp('2021-12-20 08:35:10')
# Display the Timestamp
print("Timestamp...\n",timestamp)
# Create the CustomBusinessHour Offset
# CustomBusinessHour is the DateOffset subclass
# Weekmask of valid business days
cbhOffset = pd.tseries.offsets.CustomBusinessHour(start ='09:30', end ='18:00', n = 5, weekmask = 'Mon Tue Wed Fri')
# Display the CustomBusinessHour Offset
print("\nCustomBusinessHour Offset...\n",cbhOffset)
# Display the next business day
print("\nThe next business day...\n",timestamp + cbhOffset.next_bday)输出
将会生成以下代码 −
Timestamp... 2021-12-20 08:35:10 CustomBusinessHour Offset... <5 * CustomBusinessHours: CBH=09:30-18:00> The next business day... 2021-12-21 08:35:10
更新于: 2021-10-22
查看 72 次
广告