Python | Pandas tseries.offsets.CustomBusinessHour
Last Updated :
07 Sep, 2022
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. DateOffsets 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.CustomBusinessHour() function is used to create your own custom business hours. DateOffset subclass representing possibly n custom business days.
Syntax: pandas.tseries.offsets.CustomBusinessHour() 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 : None calendar : None start : start of business hour end : end of business hour offset : datetime.timedelta(0) Returns : offset
Example #1: Use pandas.tseries.offsets.CustomBusinessHour() function to create your own custom business hour offset.
Python3
import pandas as pd
ts = pd.Timestamp( '2019-4-23 11:15:00' )
cbh = pd.tseries.offsets.CustomBusinessHour(n = 2 , weekmask = 'Mon Tue Wed Thu' ,
start = '12:00' )
print (ts)
print (cbh)
|
Output : Now we will add the offset to the given timestamp object to increment the datetime value.
Python3
new_timestamp = ts + cbh
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.CustomBusinessHour() function to create your own custom business hour offset.
Python3
import pandas as pd
ts = pd.Timestamp( '2019-4-23 11:15:00' )
cbh = pd.tseries.offsets.CustomBusinessHour(start = '07:00' , end = '14:00' )
print (ts)
print (cbh)
|
Output : Now we will add the offset to the given timestamp object to increment the datetime value.
Python3
new_timestamp = ts + cbh
print (new_timestamp)
|
Output : As we can see in the output, we have successfully created an offset and added it to the given timestamp.
Share your thoughts in the comments
Please Login to comment...