Pandas: Create a time series with the last working days of each month

Last update on May 02 2025 12:54:58 (UTC/GMT +8 hours)

15. Last Working Days per Month

Write a Pandas program to get a time series with the last working days of each month of a specific year.

Sample Solution:

Python Code :

import pandas as pd
s = pd.date_range('2021-01-01', periods=12, freq='BM')
df = pd.DataFrame(s, columns=['Date'])
print('last working days of each month of a specific year:')
print(df)

Sample Output:

last working days of each month of a specific year:
         Date
0  2021-01-29
1  2021-02-26
2  2021-03-31
3  2021-04-30
4  2021-05-31
5  2021-06-30
6  2021-07-30
7  2021-08-31
8  2021-09-30
9  2021-10-29
10 2021-11-30
11 2021-12-31

For more Practice: Solve these Related Problems:

Write a Pandas program to generate the last business day for each month of a specified year and then compare with the calendar month-end.
Write a Pandas program to create a time-series of last working days and then visualize them on a plot.
Write a Pandas program to compute the last business day for each month, adjusting for observed holidays.
Write a Pandas program to extract the last working day from a monthly date range using custom business day rules.

Go to:

Previous: Write a Pandas program to check if a day is a business day (weekday) or not.
Next: Write a Pandas program to create a time series combining hour and minute.

Python Code Editor:

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