Pandas: Calculate one business day from a specified date

Last update on December 21 2024 07:56:09 (UTC/GMT +8 hours)

Write a Pandas program to calculate one, two, three business day(s) from a specified date. Also find the next business month end from a specific date.

Sample Solution:

Python Code :

import pandas as pd
from pandas.tseries.offsets import *
import datetime
from datetime import datetime, date
dt = datetime(2020, 1, 4)
print("Specified date:")
print(dt)
print("\nOne business day from the said date:")
obday = dt + BusinessDay()
print(obday)
print("\nTwo business days from the said date:")
tbday = dt + 2 * BusinessDay()
print(tbday)
print("\nThree business days from the said date:")
thbday = dt + 3 * BusinessDay()
print(thbday)
print("\nNext business month end from the said date:")
nbday = dt + BMonthEnd()
print(nbday)

Sample Output:

Specified date:
2020-01-04 00:00:00

One business day from the said date:
2020-01-06 00:00:00

Two business days from the said date:
2020-01-07 00:00:00

Three business days from the said date:
2020-01-08 00:00:00

Next business month end from the said date:
2020-01-31 00:00:00

Python Code Editor:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: Write a Pandas program to convert integer or float epoch times to Timestamp and DatetimeIndex.
Next: Write a Pandas program to create a period index represent all monthly boundaries of a given year. Also print start and end time for each period object in the said index.