数据结构
网络
关系数据库管理系统 (RDBMS)
操作系统
Java
MS Excel
iOS
HTML
CSS
Android
Python
C语言编程
C++
C#
MongoDB
MySQL
Javascript
PHP
物理学
化学
生物学
数学
英语
经济学
心理学
社会学
服装设计
法学Python Pandas - 获取应用于 CustomBusinessDay 偏移量的 weekmask
要获取应用于 CustomBusinessDay 偏移量的 weekmask，请在 Pandas 中使用 CustomBusinessDay.weekmask 属性。
首先，导入所需的库：
import pandas as pd
在 Pandas 中设置时间戳对象：
timestamp = pd.Timestamp('2021-10-22 03:10:35')
创建 CustomBusinessDay 偏移量。CustomBusinessDay 是 DateOffset 的子类，表示排除节假日的自定义工作日。有效工作日的 Weekmask：
cbdOffset = pd.tseries.offsets.CustomBusinessDay(n = 4, weekmask = 'Mon Tue Wed Fri')
将偏移量添加到时间戳并显示更新后的时间戳：
print("\nUpdated Timestamp...\n",timestamp + cbdOffset)
显示 weekmask：
print("\nThe weekmask on the CustomBusinessDay object..\n", cbdOffset.weekmask)示例
以下是代码：
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
cbdOffset = pd.tseries.offsets.CustomBusinessDay(n = 4, weekmask = 'Mon Tue Wed Fri')
# 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)
# return the count of increments on the given CustomBusinessDay object
print("\nThe count of increments on the CustomBusinessDay object..\n", cbdOffset.n)
# display the weekmask
print("\nThe weekmask on the CustomBusinessDay object..\n", cbdOffset.weekmask)输出
这将产生以下代码：
Timestamp... 2021-10-22 03:10:35 CustomBusinessDay Offset... <4 * CustomBusinessDays> Updated Timestamp... 2021-10-29 03:10:35 Frequency applied on the given CustomBusinessDay Offset object... 4C The count of increments on the CustomBusinessDay object.. 4 The weekmask on the CustomBusinessDay object.. Mon Tue Wed Fri
更新于：2021年10月22日
160 次浏览
广告