Pandas Series dt.is_month_end | Check if Date is Last Day of Month
Last Updated :
07 Feb, 2024
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
import pandas as pd
sr = pd.Series(pd.date_range( '2012-3-31 00:00' ,
periods = 5 , freq = 'M' ))
idx = [ 'Day 1' , 'Day 2' , 'Day 3' , 'Day 4' , 'Day 5' ]
sr.index = idx
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
result = sr.dt.is_month_end
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.
Share your thoughts in the comments
Please Login to comment...