Python Pandas - Display the end time of the custom business hour in 24h format from the CustomBusinessHour offset object

PythonServer Side ProgrammingProgramming

To display the end time of the custom business hour in 24h format from the CustomBusinessHour offset object, use the CustomBusinessHour.end property in Pandas.

At first, import the required libraries −

import pandas as pd

Set the timestamp object in Pandas −

timestamp = pd.Timestamp('2021-11-14 05:20:30')

Create the CustomBusinessHour 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 −

cbhOffset = pd.tseries.offsets.CustomBusinessHour(start="09:30", end = "18:30", n = 5)

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

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

Display the end time of the custom business hour −

print("\nThe end time of the custom business hour...\n",cbhOffset.end)

Example

Following is the code −

import pandas as pd

# Set the timestamp object in Pandas
timestamp = pd.Timestamp('2021-11-14 05:20:30')

# Display the Timestamp
print("Timestamp...\n",timestamp)

# Create the CustomBusinessHour Offset
# CustomBusinessHour 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.
cbhOffset = pd.tseries.offsets.CustomBusinessHour(start="09:30", end = "18:30", n = 5)

# Display the CustomBusinessHour Offset
print("\nCustomBusinessHour Offset...\n",cbhOffset)

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

# Display the end time of the custom business hour
print("\nThe end time of the custom business hour...\n",cbhOffset.end)

Output

This will produce the following code −

Timestamp...
 2021-11-14 05:20:30

CustomBusinessHour Offset...
 <5 * CustomBusinessHours: CBH=09:30-18:30>

Updated Timestamp...
 2021-11-15 14:30:00

The end time of the custom business hour...
 (datetime.time(18, 30),)
raja
Updated on 22-Oct-2021 08:06:53

Advertisements