- Data Structure
- Networking
- RDBMS
- Operating System
- Java
- MS Excel
- iOS
- HTML
- CSS
- Android
- Python
- C Programming
- C++
- C#
- MongoDB
- MySQL
- Javascript
- PHP
- Physics
- Chemistry
- Biology
- Mathematics
- English
- Economics
- Psychology
- Social Studies
- Fashion Studies
- Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Python Pandas BusinessHour offset object - Move to the next business day
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 pd
Create 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("\nBusinessHour Offset...\n",bhOffset)
Set the timestamp object in Pandas −
timestamp = pd.Timestamp('2021-9-30 06:50:20')
Display the next business day −
print("\nThe next business day...\n",timestamp + bhOffset.next_bday)
Example
Following 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...\n",timestamp) # Create 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("\nBusinessHour Offset...\n",bhOffset) # Display the next business day print("\nThe next business day...\n",timestamp + bhOffset.next_bday)
Output
This will produce the following code −
Timestamp... 2021-09-30 06:50:20 BusinessHour Offset... <BusinessHour: offset=datetime.timedelta(days=3, seconds=10800): BH=09:00-17:00> The next business day... 2021-10-01 06:50:20
Advertisements