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

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

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

Python Code Editor:

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

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.