Python Pandas - Check whether the BusinessHour Offset has been normalized or not


To check whether the BusinessHour Offset has been normalized or not, use the BusinessHour.normalize property in Pandas.

At first, import the required libraries −

import pandas as pd

Set the timestamp object in Pandas −

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

Create the BusinessHour Offset. We have normalized the BusinessHour using the "normalize" parameter −

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

Display the Updated Timestamp −

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

Check whether the BusinessHour Offset is normalized or not −

print("\nThe BusinessHour Offset is normalized ?\n", bhOffset.normalize)

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.
# We have normalized the BusinessHour using the "normalize" parameter
bhOffset = pd.tseries.offsets.BusinessHour(start="09:30", end = "18:00", normalize=True)

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

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

# check whether the BusinessHour Offset is normalized or not
print("\nThe BusinessHour Offset is normalized ?\n", bhOffset.normalize)

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 00:00:00

The BusinessHour Offset is normalized ?
 True

Updated on: 21-Oct-2021

66 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements