Python | Pandas tseries.offsets.CustomBusinessDay



DateOffsets can be created to move dates by a specified number of valid dates. For example, Bday (2) can be added to a date to move it two business days forward. If the date does not start with a valid date, it is first moved to a valid date and then an offset is generated.

tseries.offsets.CustomBusinessDay() Pandas tseries.offsets.CustomBusinessDay () is used to create your own custom business days. Subclass DateOffset representing possibly n custom business days, excluding holidays.

Syntax: pandas.tseries.offsets.CustomBusinessDay ()

Parameter:
n: int
normalize: Normalize start / end dates to midnight before generating date range
weekmask: weekmask of valid business days, passed to numpy.busdaycalendar
holidays: list / array of dates to exclude from the set of valid business days, passed to numpy.busdaycalendar
calendar: pd.HolidayCalendar or np.busdaycalendar
offset: timedelta, default timedelta (0)

Returns: custom business day

Example # 1: Use pandas.tseries.offsets.CustomBusinessDay () to create your own weekdays.

# import pandas as pd

import pandas as pd

 
# Create a timestamp

ts = pd.Timestamp ( `2019-4-23 11: 15: 00` )

 
# Create offset

cbd = pd.tseries.offsets.CustomBusinessDay (weekmask = `Mon Tue Wed` )

 
# Print time stamp

print (ts)

 
# Print offset

print (cbd)

Output:

Now we will add an offset to this timestamp object to increase the datetime value.

# Adds an offset to the specified timestamp

new_timestamp = ts + cbd

 
# Print updated timestamp  

print (new_timestamp)

Output:

As we can see in the output, we have successfully created an offset and added it to the given timestamp.

Example # 2. Use pandas.tseries .offsets.CustomBusinessDay () to create your own business days.

# import pandas as pd

import pandas as pd

  
# Create a timestamp

ts = pd.Timestamp ( ` 2019-4-23 11: 15: 00` )

  
# Create offset

cbd = pd.tseries.offsets.CustomBusinessDay (n = 3 , weekmask = `Mon Tue Wed Thu` )

  
# Print time stamp

print (ts)

  
# Print offset

print (cbd)

Output:

We will now add an offset to this timestamp object to increase the datetime value.

# Add an offset to the specified timestamp

new_timestamp = ts + cbd

  
# Print updated timestamp

print (new_timestamp)

Exit:

As we can see in the output, we have successfully created an offset and added it to the given timestamp.