Python Pandas - 從 BusinessHour 偏移物件中以 24 小時制格式顯示自定義營業時間的開始時間


要從 BusinessHour 偏移物件中以 24 小時制格式顯示自定義營業時間的開始時間,請使用 BusinessHour.start 屬性。

首先,匯入所需的庫:

import pandas as pd

在 Pandas 中設定時間戳物件:

timestamp = pd.Timestamp('2021-9-30 06:50:20')

建立 BusinessHour 偏移量。這裡,“start” 是您自定義營業時間以 24 小時製表示的開始時間。“end” 是您自定義營業時間以 24 小時製表示的結束時間:

bhOffset = pd.tseries.offsets.BusinessHour(start="09:30", end = "18:00", n = 8)

顯示更新後的時間戳:

顯示自定義營業時間的開始時間:

print("\nThe start time of the custom business hour...\n",bhOffset.start)

示例

以下是程式碼:

import pandas as pd

# Set the timestamp object in Pandas
timestamp = pd.Timestamp('2021-9-30 06:50:20')

# 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", n = 8)

# Display the BusinessHour Offset
print("\nBusinessHour Offset...\n",bhOffset)

# Display the Updated Timestamp
print("\nUpdated Timestamp...\n",timestamp + bhOffset)

# Display the start time of the custom business hour
print("\nThe start time of the custom business hour...\n",bhOffset.start)

輸出

這將產生以下程式碼:

Timestamp...
 2021-09-30 06:50:20

BusinessHour Offset...
 <8 * BusinessHours: BH=09:30-18:00>

Updated Timestamp...
 2021-09-30 17:30:00

The start time of the custom business hour...
 (datetime.time(9, 30),)

更新於:2021年10月21日

80 次瀏覽

啟動您的 職業生涯

完成課程獲得認證

開始學習
廣告