Python Pandas - Return the count of increments applied on the BusinessHour offset

 To return the count of increments applied on the BusinessHour offset, use the BusinessHour.n 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. 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 Updated Timestamp −

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

Return the count of increments on the given BusinessHour object −

print("\nThe count of increments on the BusinessHour object..\n", bhOffset.n)

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

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

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

# return the count of increments on the given BusinessHour object
print("\nThe count of increments on the BusinessHour object..\n", bhOffset.n)

Output

This will produce the following code −

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

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

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

The count of increments on the BusinessHour object..
 8

AmitDiwan

e

Updated on: 21-Oct-2021

48 Views

Kickstart Your Career

Get certified by completing the course

Get Started