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 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.rollback() function roll provided date backward to next offset only if not on offset.
Syntax: pandas.tseries.offsets.BusinessHour.rollback() Parameter : dt : date Returns : rollback
Example #1: Use pandas.tseries.offsets.BusinessHour.rollback() function to roll provided date backward to next offset only if not on offset.
# importing pandas as pd import pandas as pd
# Creating Timestamp ts = pd.Timestamp( '2019-10-10 11:15:00' )
# Create an offset bh = pd.tseries.offsets.BusinessHour(n = 5 )
# Print the Timestamp print (ts)
# Print the Offset print (bh)
|
Output :
# Adding the Business hour offset to the given timestamp new_timestamp = ts + bh
# Print the updated timestamp print (new_timestamp)
# rollback the date if not # on offset result = bh.rollback( pd.to_datetime( '2010-02-13' ))
# print the result print (result)
|
Output :
# importing pandas as pd import pandas as pd
# Creating Timestamp ts = pd.Timestamp( '2019-10-10 11:15:00' )
# Create an offset bh = pd.tseries.offsets.BusinessHour(offset = datetime.timedelta(hours = 1 ))
# Print the Timestamp print (ts)
# Print the Offset print (bh)
|
Output :
# Adding the Business hour offset to the given timestamp new_timestamp = ts + bh
# Print the updated timestamp print (new_timestamp)
# rollback the date if not # on offset result = bh.rollback( pd.to_datetime( '2010-02-12 11:00:00' ))
# print the result print (result)
|
Output :