Change language

Python | Pandas tseries.offsets.CustomBusinessDay.onOffset

| |

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.CustomBusinessDay.onOffset() Pandas tseries.offsets.CustomBusinessDay.onOffset() to check if a given time stamp is in offset or not.

Syntax: pandas.tseries.offsets.CustomBusinessDay.onOffset (dt)

Parameter:
dt: date

Returns: boolean

Example # 1: Use pandas.tseries.offsets.CustomBusinessDay.onOffset () to check if a given timestamp is in offset or not.

# import pandas as pd

import pandas as pd

 
# Create a timestamp

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

 
# Create offset

cbd = pd.tseries.offsets.CustomBusinessDay (weekmask = ’Mon Tue Wed’ )

 
# Print time stamp

print (ts)

 
# Print offset

print (cbd) 

Output:

We will now add an offset to this timestamp object to increase the datetime value. We will also check if the given timestamp is offset or not.

# Adds an offset to the specified timestamp

new_timestamp = ts + cbd

 
# Print updated timestamp

print (new_timestamp)

 
# check if the given timestamp
# is offset or not

result = cbd.onOffset (pd.Timestamp ( ’2019-4-22 11: 15: 00’ )) < / code>

 
# 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 also checked if the given time stamp is in offset or not.

Example # 2: Use pandas.tseries.offsets.CustomBusinessDay.onOffset () to check if the given timestamp is in offset or not.

# import pandas as pd

import pandas as pd

 
# Create a timestamp

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

 
# Create offset

cbd = pd.tseries.of fsets.CustomBusinessDay (n = 3 , weekmask = ’Mon Tue Wed Thu’ )

 
# Print time stamp

print (ts)

 
# Print offset

print (cbd)

Output:

Now we add an offset to the given timestamp object to increase the datetime value. We will also check if the given timestamp is offset or not.

# Adds an offset to the specified timestamp

new_timestamp = ts + cbd

 
# Print updated timestamp

print (new_timestamp)

 
# check if the given timestamp
# is offset or not

result = cbd.onOffset (pd.Timestamp ( ’2019-4-19 11: 15:00’ )) < / code>

 
# 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 also checked if the given offset object is anchored or not.