Python Pandas BusinessHour offset object - Move to the next business day

PythonServer Side ProgrammingProgramming

Move to the next business day using the BusinessHour.next_bday property in Pandas. At first, import the required libraries −

import datetime
import pandas as pd

Create the BusinessHour Offset. BusinessHour is the DateOffset subclass −

bhOffset = pd.tseries.offsets.BusinessHour(offset = datetime.timedelta(days = 3, hours = 3))

Display the BusinessHour Offset −

print("\nBusinessHour Offset...\n",bhOffset)

Set the timestamp object in Pandas −

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

Display the next business day −

print("\nThe next business day...\n",timestamp + bhOffset.next_bday)

Example

Following is the code −

import datetime
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
bhOffset = pd.tseries.offsets.BusinessHour(offset = datetime.timedelta(days = 3, hours = 3))
# Display the BusinessHour Offset
print("\nBusinessHour Offset...\n",bhOffset)

# Display the next business day
print("\nThe next business day...\n",timestamp + bhOffset.next_bday)

Output

This will produce the following code −

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

BusinessHour Offset...
 <BusinessHour: offset=datetime.timedelta(days=3, seconds=10800): BH=09:00-17:00>

The next business day...
 2021-10-01 06:50:20
raja
Updated on 21-Oct-2021 08:59:04

Advertisements