Change language

Python | Pandas tseries.offsets.BusinessHour.rollforward

| |

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.BusinessHour.rollforward() Pandas tseries.offsets.BusinessHour.rollforward() date forward until next offset, unless it is offset.

Syntax : pandas.tseries.offsets.BusinessHour.rollforward ()

Parameter:
dt: date

Returns: rollforward

Example # 1: Use pandas.tseries.offsets.BusinessHour.rollforward () to scroll the supplied date forward to the next offset, unless offset.

< / tbody>

# import pandas as pd

import pandas as pd

 
# Create a timestamp

ts = pd.Timestamp ( ’ 2019-10-10 11: 15: 00’ )

  
# Create offset

bh = pd.tseries.offsets.BusinessHour (n = 5 )

 
# Print time stamp

print (ts)

  
# Print offset

print (bh)

Output:

Now we will add the work hour offset to given a timestamp object to increment the datetime value. We’ll also roll the provided date forward to the next offset, if not the offset.

# Add a business hour offset to the specified time stamp

new_timestamp = ts + bh

 
# Print updated timestamp

print (new_timestamp)

 
# move date if not
# by offset

result = bh.rollforward ( pd.to_datetime ( ’2010-02-13’ ))

 
# print the result

print (result)

Output:

As we can see in the output, we have successfully created an offset and added it to the given timestamp. we have also rolled the provided date forward to the next offset.

Example # 2: Use pandas.tseries.offsets.BusinessHour.rollforward () to scroll the provided dates forward until next offset, unless offset.

# import pandas as pd

import pandas as pd

  
# Create a timestamp

ts = pd.Timestamp ( ’2019-10-10 11: 15: 00’ )

 
# Create offset

bh = pd.t series.offsets.BusinessHour (offset = datetime.timedelta (hours = 1 ))

  
# Print time stamp

print ( ts)

 
# Print offset

print (bh)

Output:

We will now add a business hour offset to the specified timestamp object to increase datetime value. We will also roll the provided date forward to the next offset if not offset.

# Add a business hour offset to the specified time stamp

new_timestamp = ts + bh

 
# Print updated timestamp

print (new_timestamp)

 
# move date if not
# by offset

result = bh.rollforward (pd .to_datetime ( ’2010-02-12 11: 00: 00’ ))

 
# print result

print (result)

Output:

As we see in output, we have successfully created an offset and added it to the given timestamp. The passed date has not been transferred because it is at an offset.