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

To return the count of increments applied on the BusinessDay offset, use the BusinessDay.n property in Pandas.

At first, import the required libraries −

import datetime
import pandas as pd

Set the timestamp object in Pandas” −

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

Create the BusinessDay Offset. BusinessDay is the DateOffset subclass −

bdOffset = pd.tseries.offsets.BusinessDay(n = 6)

Display the Updated Timestamp −

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

Return the count of increments on the given BusinessDay object −

print("\nThe count of increments on the BusinessDay object..\n", bdOffset.n)

Example

Following is the code −

import datetime
import pandas as pd

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

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

# Create the BusinessDay Offset
# BusinessDay is the DateOffset subclass
bdOffset = pd.tseries.offsets.BusinessDay(n = 6)

# Display the BusinessDay Offset
print("\nBusinessDay Offset...\n",bdOffset)

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

# return the frequency applied on the given BusinessDay object as a string
print("\nFrequency on the given BusinessDay Offset...\n",bdOffset.freqstr)

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

Output

This will produce the following code −

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

BusinessDay Offset...
 <6 * BusinessDays>

Updated Timestamp...
 2021-11-08 01:55:02.000045

Frequency on the given BusinessDay Offset...
 6B

The count of increments on the BusinessDay object..
 6

AmitDiwan

e

Updated on: 21-Oct-2021

63 Views

Kickstart Your Career

Get certified by completing the course

Get Started