Python | Pandas tseries.offsets.BusinessHour
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.BusinessHour() function is used to create an offset of business hours.
Syntax: pandas.tseries.offsets.BusinessHour(n=1, normalize=False, start=’09:00′, end=’17:00′, offset=datetime.timedelta(0)) Parameter : n : number of hours normalize : Whether to round the result of a DateOffset addition down to the previous midnight. start : start time end : end time offset : offset from the given date Returns : offset
Example #1: Use pandas.tseries.offsets.BusinessHour() function to create an offset of 5 Business hours.
Python3
# importing pandas as pd import pandas as pd # Creating Timestamp ts = pd.Timestamp( '2019-10-10 07:15:11' ) # Create an offset of 5 Business hours bh = pd.tseries.offsets.BusinessHour(n = 5 ) # Print the Timestamp print (ts) # Print the Offset print (bh) |
Output : Now we will add the Business hour offset to the given timestamp object to increment the datetime value.
Python3
# Adding the Business hour offset to the given timestamp new_timestamp = ts + bh # Print the updated timestamp print (new_timestamp) |
Output : As we can see in the output, we have successfully created an offset of 5 Business hours and added it to the given timestamp. Example #2: Use pandas.tseries.offsets.BusinessHour() function to create an offset of 10 days and 5 Business hours.
Python3
# importing pandas as pd import pandas as pd # Creating Timestamp ts = pd.Timestamp( '2019-10-10 07:15:11' ) # Create an offset bh = pd.tseries.offsets.BusinessHour(offset = datetime.timedelta(days = 10 , hours = 10 )) # Print the Timestamp print (ts) # Print the Offset print (bh) |
Output : Now we will add the Business hour offset to the given timestamp object to increment the datetime value.
Python3
# Adding the Business hour offset to the given timestamp new_timestamp = ts + bh # 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.