1. Python
  2. Python | Pandas tseries.offsets.CustomBusinessHour

Python | Pandas tseries.offsets.CustomBusinessHour

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.CustomBusinessHour() Pandas tseries.offsets.CustomBusinessHour () is used to create your own business hours. Subclass DateOffset 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 () to create your own work hour offset.

# import pandas as pd

import pandas as pd

 
# Create a timestamp

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

 
# Create offset

cbh = pd.tseries.offsets.CustomBusinessHour (n = 2 , weekmask = `Mon Tue Wed Thu` ,

start = `12: 00` )

 
# Print time stamp

print (ts)

 
# Print offset

print (cbh)

Output:

We will now add an offset to this timestamp object to increase the datetime value.

# Add an offset to the specified timestamp

new_timestamp = ts + cbh

  
# Print updated timestamp

print (new_timestamp)

Output:

As we see in the output, we have successfully created an offset and added it to the given timestamp.

Example # 2: Use pandas.tseries.offsets.CustomBusinessHour () to create your own working hour offset.

# import pandas as pd

import pandas as pd

 
< code class = "comments"> # Create a timestamp

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

 
# Create offset

cbh = pd.tseries.offsets.CustomBusinessHour (start = ` 07:00` , end = `14:00` )

  
# Print time stamp

print ( ts)

 
# Print offset

print (cbh)

Output:

Now we will add an offset to this timestamp object to increase the datetime value.

# Add an offset to the specified timestamp

new_timestamp = ts + cbh

 
# Print updated timestamp

print (new_timestamp)

Output: < / strong>

As we can see in the output, we have successfully created an offset and added it to the specified timestamp.