Pandas Series dt.is_month_end | Check if Date is Last Day of Month

Pandas dt.is_month_end attribute returns a boolean value indicating whether the date is the last day of the month.

Example

Python3

import pandas as pd
sr = pd.Series(['2012-1-31', '2019-7-18 12:30', '2008-02-2 10:30',
               '2010-4-22 09:25', '2019-1-1 00:00'])
idx = ['Day 1', 'Day 2', 'Day 3', 'Day 4', 'Day 5']
sr.index = idx
sr = pd.to_datetime(sr)
result = sr.dt.is_month_end
print(result)

Output

Syntax

Syntax: Series.dt.is_month_end 

Parameter : None 

Returns: Series with boolean values

How to Know if a Date is the Last Day of the Month in Pandas Series

To know if a date in the Pandas Series is the last day of the respective month, we use the Series.dt.is_month_end attribute of the Pandas library in Python.

Let us understand it better with an example 

Example:

Use the Series.dt.is_month_end attribute to check if the dates in the underlying data of the given series object are the last day of the month or not.

Python3

# importing pandas as pd
import pandas as pd

# Creating the Series
sr = pd.Series(pd.date_range('2012-3-31 00:00',
                      periods = 5, freq = 'M'))

# Creating the index
idx = ['Day 1', 'Day 2', 'Day 3', 'Day 4', 'Day 5']

# set the index
sr.index = idx

# Print the series
print(sr)

Output :

Now we will use the Series.dt.is_month_end attribute to check if the dates in the given series object is the last day of the month or not.

Python3

# check if dates are the last
# day of the month or not
result = sr.dt.is_month_end

# print the result
print(result)

Output :

As we can see in the output, the dt.is_month_end attribute has successfully accessed and returned boolean values indicating whether the dates are the last day of the month.