Python Pandas CustomBusinessHour - 向后滚动提供的日期
要向后滚动提供的日期,请使用Pandas中的方法。首先,导入所需的库-CustomBusinessHour.rollback()
import pandas as pd
在Pandas中设置时间戳对象-
timestamp = pd.Timestamp('2021-12-20 08:35:10')创建CustomBusinessHour偏移量。CustomBusinessHour是DateOffset子类-
cbhOffset = pd.tseries.offsets.CustomBusinessHour(n = 5, weekmask = 'Mon Tue Wed Fri')
将偏移量添加到时间戳并显示更新的时间戳-
print("\nUpdated Timestamp...\n",timestamp + cbhOffset)如果不在偏移上,则向后滚动-
roll_back = cbhOffset.rollback(pd.Timestamp('2021-12-18 08:35:10'))显示结果-
print("\nRoll Backward Result...\n",roll_back)示例
以下是代码-
import pandas as pd
#SetthetimestampobjectinPandas
timestamp = pd.Timestamp('2021-12-20 08:35:10')
#DisplaytheTimestamp
print("Timestamp...\n",timestamp)
#CreatetheCustomBusinessHourOffset
#CustomBusinessHouristheDateOffsetsubclass
#Weekmaskofvalidbusinessdays
cbhOffset = pd.tseries.offsets.CustomBusinessHour(n = 5, weekmask = 'Mon Tue Wed Fri')
#DisplaytheCustomBusinessHourOffset
print("\nCustomBusinessHour Offset...\n",cbhOffset)
#AddtheoffsettotheTimestampanddisplaytheUpdatedTimestamp
print("\nUpdated Timestamp...\n",timestamp + cbhOffset)
#rollbackwardifnotonoffset
roll_back = cbhOffset.rollback(pd.Timestamp('2021-12-18 08:35:10'))
#displaytheresult
print("\nRoll Backward Result...\n",roll_back)输出结果这将产生以下代码-
Timestamp... 2021-12-20 08:35:10 CustomBusinessHour Offset... <5 * CustomBusinessHours: CBH=09:00-17:00> Updated Timestamp... 2021-12-20 14:00:00 Roll Backward Result... 2021-12-17 17:00:00
热门推荐
10 八一幼儿祝福语大全简短
11 公司乔迁食堂祝福语简短
12 婚礼结束聚餐祝福语简短
13 儿媳买车妈妈祝福语简短
14 毕业送礼老师祝福语简短
15 同事辞职正常祝福语简短
16 恭贺新婚文案祝福语简短
17 金店立秋祝福语简短英文
18 婆婆高寿祝福语大全简短