Wednesday, November 20, 2024
Google search engine
HomeUncategorisedPython | Pandas tseries.offsets.BusinessHour.offset

Python | Pandas tseries.offsets.BusinessHour.offset

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.offset attribute is alias for self._offset. It returns a datetime.timedelta value.

Syntax: pandas.tseries.offsets.BusinessHour.offset Parameter : None Returns : datetime.timedelta

Example #1: Use pandas.tseries.offsets.BusinessHour.offset attribute to return the self._offset value for the given offset. 

Python3




# importing pandas as pd
import pandas as pd
 
# Creating Timestamp
ts = pd.Timestamp('2019-10-10 11:15:00')
 
# 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. We will print the offset value. 

Python3




# Adding the Business hour offset to the given timestamp
new_timestamp = ts + bh
 
# Print the updated timestamp
print(new_timestamp)
 
# print the offset
print(bh.offset)


Output : As we can see in the output, we have successfully created an offset and added it to the given timestamp. We have also printed the self._offset value. Example #2: Use pandas.tseries.offsets.BusinessHour.offset attribute to return the self._offset value for the given offset. 

Python3




# 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 : Now we will add the Business hour offset to the given timestamp object to increment the datetime value. We will print the self._offset value. 

Python3




# Adding the Business hour offset to the given timestamp
new_timestamp = ts + bh
 
# Print the updated timestamp
print(new_timestamp)
 
# print the offset
print(bh.offset)


Output : As we can see in the output, we have successfully created an offset and added it to the given timestamp. We have also printed the self._offset value.

Dominic Rubhabha-Wardslaus
Dominic Rubhabha-Wardslaushttp://wardslaus.com
infosec,malicious & dos attacks generator, boot rom exploit philanthropist , wild hacker , game developer,
RELATED ARTICLES

Most Popular

Recent Comments