Python Pandas - Create a BusinessHour offset

To create a BusinessHour offset, use the pd.tseries.offsets.BusinessHour() method in Pandas. At first, import the required libraries −

import pandas as pd

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")

Set the timestamp object in Pandas −

timestamp = pd.Timestamp('2021-1-1 01:55:30')

Add the offset to the Timestamp and display the Updated Timestamp −

print("\nUpdated Timestamp...\n",timestamp + bhOffset)

Example

Following is the code −

import pandas as pd

# Set the timestamp object in Pandas
timestamp = pd.Timestamp('2021-1-1 01:55:30')

# 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")

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

# Add the offset to the Timestamp and display the Updated Timestamp
print("\nUpdated Timestamp...\n",timestamp + bhOffset)

Output

This will produce the following code −

Timestamp...
 2021-01-01 01:55:30

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

Updated Timestamp...
 2021-01-01 10:30:00

AmitDiwan

e

Updated on: 21-Oct-2021

108 Views

Kickstart Your Career

Get certified by completing the course

Get Started