Python Articles - Page 268 of 829

To roll provided date forward to next offset only if not on offset, use the CustomBusinessHour.rollforward() method in Pandas.At first, import the required libraries −import pandas as pdSet the timestamp object in Pandas −timestamp = pd.Timestamp('2021-12-20 08:35:10') Create the CustomBusinessHour Offset. CustomBusinessHour is the DateOffset subclass. Weekmask of valid business days −cbhOffset = pd.tseries.offsets.CustomBusinessHour(n = 5, weekmask = 'Mon Tue Wed Fri')Add the offset to the Timestamp and display the Updated Timestamp −print("Updated Timestamp...", timestamp + cbhOffset) Roll forward if not on offset −roll = cbhOffset.rollforward(pd.Timestamp('2021-12-30 08:35:10'))Display the result −print("Roll forward Result...", roll) ExampleFollowing is the code −import pandas as ... Read More

To create a CustomBusinessHour object, use the pandas.tseries.offsets.CustomBusinessHour() method in Pandas.At first, import the required libraries −import pandas as pdSet the timestamp object in Pandas −timestamp = pd.Timestamp('2021-12-31 08:35:10') Create the CustomBusinessHour Offset. CustomBusinessHour is the DateOffset subclass. Weekmask of valid business days −cbhOffset = pd.tseries.offsets.CustomBusinessHour(n = 5, weekmask = 'Mon Tue Wed Fri')Display the CustomBusinessHour Offset −print("CustomBusinessHour Offset...", cbhOffset) Add the offset to the Timestamp and display the Updated Timestamp −print("Updated Timestamp...", timestamp + cbhOffset)ExampleFollowing is the code −import pandas as pd # Set the timestamp object in Pandas timestamp = pd.Timestamp('2021-12-31 08:35:10') # Display the Timestamp ... Read More

To get the weekmask applied on the CustomBusinessDay offset, use the CustomBusinessDay.weekmask property in Pandas.At first, import the required libraries −import pandas as pdSet the timestamp object in Pandas −timestamp = pd.Timestamp('2021-10-22 03:10:35') Create the CustomBusinessDay Offset. CustomBusinessDay is the DateOffset subclass representing custom business days excluding holidays. Weekmask of valid business days −cbdOffset = pd.tseries.offsets.CustomBusinessDay(n = 4, weekmask = 'Mon Tue Wed Fri')Add the offset to the Timestamp and display the Updated Timestamp −print("Updated Timestamp...", timestamp + cbdOffset) Display the weekmask −print("The weekmask on the CustomBusinessDay object..", cbdOffset.weekmask)ExampleFollowing is the code −import pandas as pd # Set the ... Read More

To create a CustomBusinessDay Offset object, use the pd.tseries.offsets.CustomBusinessDay() method in Pandas.At first, import the required libraries −import pandas as pdCreate the CustomBusinessDay Offset. CustomBusinessDay is the DateOffset subclass representing custom business days excluding holidays. Weekmask of valid business days −cbdOffset = pd.tseries.offsets.CustomBusinessDay(n = 5, weekmask = 'Mon Tue Wed Fri') Set the timestamp object in Pandas −timestamp = pd.Timestamp('2021-12-31 08:35:10')Add the offset to the Timestamp and display the Updated Timestamp −print("Updated Timestamp...", timestamp + cbdOffset) ExampleFollowing is the code −import pandas as pd # Set the timestamp object in Pandas timestamp = pd.Timestamp('2021-12-31 08:35:10') # Display the ... Read More

Move to the next business day using the BusinessHour.next_bday property in Pandas. At first, import the required libraries −import datetime import pandas as pdCreate the BusinessHour Offset. BusinessHour is the DateOffset subclass −bhOffset = pd.tseries.offsets.BusinessHour(offset = datetime.timedelta(days = 3, hours = 3)) Display the BusinessHour Offset −print("BusinessHour Offset...", bhOffset)Set the timestamp object in Pandas −timestamp = pd.Timestamp('2021-9-30 06:50:20') Display the next business day −print("The next business day...", timestamp + bhOffset.next_bday)ExampleFollowing is the code −import datetime import pandas as pd # Set the timestamp object in Pandas timestamp = pd.Timestamp('2021-9-30 06:50:20') # Display the Timestamp print("Timestamp...", timestamp) # ... Read More

To display the end time of the custom business hour in 24h format from the BusinessHour offset object, use the BusinessHour.end property.At first, import the required libraries −import pandas as pdSet the timestamp object in Pandas −timestamp = pd.Timestamp('2021-9-30 06:50:20') Create the BusinessHour Offset. Here, "start" is the start time of your custom business hour in 24h format. The "end" is the end time of your custom business hour in 24h format −bhOffset = pd.tseries.offsets.BusinessHour(start="09:30", end = "18:00", n = 8)Display the Updated Timestamp −print("Updated Timestamp...", timestamp + bhOffset) Display the end time of the custom business hour −print("The end ... Read More

To display the start time of the custom business hour in 24h format from the BusinessHour offset object, use the BusinessHour.start property.At first, import the required libraries −import pandas as pdSet the timestamp object in Pandas −timestamp = pd.Timestamp('2021-9-30 06:50:20') Create the BusinessHour Offset. Here, "start" is the start time of your custom business hour in 24h format. The "end" is the end time of your custom business hour in 24h format −bhOffset = pd.tseries.offsets.BusinessHour(start="09:30", end = "18:00", n = 8)Display the Updated Timestamp − Display the start time of the custom business hour −print("The start time of the custom ... Read More

To create a BusinessHour offset, use the pd.tseries.offsets.BusinessHour() method in Pandas. At first, import the required libraries −import pandas as pdCreate the BusinessHour Offset. BusinessHour is the DateOffset subclass. Here, "start" is the start time of your custom business hour in 24h format. The "end" is the end time of your custom business hour in 24h format −bhOffset = pd.tseries.offsets.BusinessHour(start="09:30", end = "18:00") Set the timestamp object in Pandas −timestamp = pd.Timestamp('2021-1-1 01:55:30')Add the offset to the Timestamp and display the Updated Timestamp −print("Updated Timestamp...", timestamp + bhOffset) ExampleFollowing is the code −import pandas as pd # Set the ... Read More

To return the rule code applied on the given BusinessDay object, use the BusinessDay.rule_code property in Pandas.At first, import the required libraries −import datetime import pandas as pdSet the timestamp object in Pandas −timestamp = pd.Timestamp('2021-10-30 01:55:02.000045') Create the BusinessDay Offset. BusinessDay is the DateOffset subclass −bdOffset = pd.tseries.offsets.BusinessDay(offset = datetime.timedelta(hours = 8, minutes = 10))Display the Updated Timestamp −print("Updated Timestamp...", timestamp + bdOffset) Return the rule code of the frequency applied on the given BusinessDay Offset −print("The rule code of the BusinessDay object..", bdOffset.rule_code)ExampleFollowing is the code −import datetime import pandas as pd # Set the timestamp object ... Read More

To check whether the BusinessDay Offset has been normalized or not, use the BusinessDay.normalize property in Pandas.At first, import the required libraries −import datetime import pandas as pdSet the timestamp object in Pandas −timestamp = pd.Timestamp('2021-10-30 01:55:02.000045') Create the BusinessDay Offset. BusinessDay is the DateOffset subclass. We have normalized the BusinessDay using the "normalize" parameter −bdOffset = pd.tseries.offsets.BusinessDay(offset = datetime.timedelta(hours = 8, minutes = 10), normalize=True)Display the Updated Timestamp −print("Updated Timestamp...", timestamp + bdOffset) Check whether the BusinessDay Offset is normalized or not −print("The BusinessDay Offset is normalized..", bdOffset.normalize)ExampleFollowing is the code −import datetime import pandas as pd # ... Read More