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),)
廣告