数据结构
网络
关系型数据库管理系统
操作系统
Java
MS Excel
iOS
HTML
CSS
Android
Python
C 编程
C++
C#
MongoDB
MySQL
Javascript
PHP
物理学
化学
生物学
数学
英语
经济学
心理学
社会学
时尚研究
法律研究Python Pandas - 检查自定义工作日偏移量是否已标准化
要检查自定义工作日偏移量是否已标准化，请在 Pandas 中使用 CustomBusinessDay.normalize 属性。
首先，导入所需的库 -
import pandas as pd
在 Pandas 中设置时间戳对象 -
timestamp = pd.Timestamp('2021-10-22 03:10:35')
创建 CustomBusinessDay 偏移量。CustomBusinessDay 是 DateOffset 子类，表示自定义工作日，不包括节假日。有效工作日的 Weekmask。我们使用“normalize”参数对 CustomBusinessDay 进行了标准化 -
cbdOffset = pd.tseries.offsets.CustomBusinessDay(n = 2, weekmask = 'Mon Tue Wed Fri', normalize=True)
将偏移量添加到时间戳并显示更新后的时间戳 -
print("\nUpdated Timestamp...\n",timestamp + cbdOffset)
检查 CustomBusinessDay 偏移量是否已标准化 -
print("\nThe CustomBusinessDay Offset is normalized ?\n", cbdOffset.normalize)示例
以下是代码 -
import pandas as pd
# Set the timestamp object in Pandas
timestamp = pd.Timestamp('2021-10-22 03:10:35')
# Display the Timestamp
print("Timestamp...\n",timestamp)
# Create the CustomBusinessDay Offset
# CustomBusinessDay is the DateOffset subclass representing custom business days excluding holidays
# Weekmask of valid business days
# We have normalized the CustomBusinessDay using the "normalize" parameter
cbdOffset = pd.tseries.offsets.CustomBusinessDay(n = 2, weekmask = 'Mon Tue Wed Fri', normalize=True)
# Display the CustomBusinessDay Offset
print("\nCustomBusinessDay Offset...\n",cbdOffset)
# Add the offset to the Timestamp and display the Updated Timestamp
print("\nUpdated Timestamp...\n",timestamp + cbdOffset)
# Return frequency applied on the given CustomBusinessDay Offset object as a string
print("\nFrequency applied on the given CustomBusinessDay Offset object...\n",cbdOffset.freqstr)
# check whether the CustomBusinessDay Offset is normalized or not
print("\nThe CustomBusinessDay Offset is normalized ?\n", cbdOffset.normalize)输出
这将生成以下代码 -
Timestamp... 2021-10-22 03:10:35 CustomBusinessDay Offset... <2 * CustomBusinessDays> Updated Timestamp... 2021-10-26 00:00:00 Frequency applied on the given CustomBusinessDay Offset object... 2C The CustomBusinessDay Offset is normalized ? True
更新于: 2021-10-22
109 次浏览
广告