Skip to content
Related Articles

Related Articles

Improve Article
Save Article
Like Article

Python | Pandas tseries.offsets.CustomBusinessDay

  • Last Updated : 23 Apr, 2019

Dateoffsets are a standard kind of date increment used for a date range in Pandas. It works exactly like relativedelta in terms of the keyword args we pass in. DateOffets work as follows, each offset specify a set of dates that conform to the DateOffset. For example, Bday defines this set to be the set of dates that are weekdays (M-F).

DateOffsets can be created to move dates forward a given 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 on a valid date, first it is moved to a valid date and then offset is created.

Pandas tseries.offsets.CustomBusinessDay() function is used to create your own custom business days. DateOffset subclass 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() function to create your own custom business days.




# importing pandas as pd
import pandas as pd
  
# Creating Timestamp
ts = pd.Timestamp('2019-4-23 11:15:00')
  
# Create an offset
cbd = pd.tseries.offsets.CustomBusinessDay(weekmask = 'Mon Tue Wed')
  
# Print the Timestamp
print(ts)
  
# Print the Offset
print(cbd)

Output :

Now we will add the offset to the given timestamp object to increment the datetime value.




# Adding the offset to the given timestamp
new_timestamp = ts + cbd
  
# Print the 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() function to create your own custom business days.






# importing pandas as pd
import pandas as pd
  
# Creating Timestamp
ts = pd.Timestamp('2019-4-23 11:15:00')
  
# Create an offset
cbd = pd.tseries.offsets.CustomBusinessDay(n = 3, weekmask = 'Mon Tue Wed Thu')
  
# Print the Timestamp
print(ts)
  
# Print the Offset
print(cbd)

Output :

Now we will add the offset to the given timestamp object to increment the datetime value.




# Adding the offset to the given timestamp
new_timestamp = ts + cbd
  
# Print the 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.


My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!