Find the end of the month of a Pandas DataFrame Series

by

You can use pandas.tseries.offsets.MonthEnd:

from pandas.tseries.offsets import MonthEnd

df['Date'] = pd.to_datetime(df['Date'], format="%Y%m") + MonthEnd(1)

The 1 in MonthEnd just specifies to move one step forward to the next date that’s a month end. (Using 0 or leaving it blank would also work in your case). If you wanted the last day of the next month, you’d use MonthEnd(2), etc. This should work for any month, so you don’t need to know the number days in the month, or anything like that. More offset information can be found in the documentation.

Example usage and output:

df = pd.DataFrame({'Date': [200104, 200508, 201002, 201602, 199912, 200611]})
df['EndOfMonth'] = pd.to_datetime(df['Date'], format="%Y%m") + MonthEnd(1)

     Date EndOfMonth
0  200104 2001-04-30
1  200508 2005-08-31
2  201002 2010-02-28
3  201602 2016-02-29
4  199912 1999-12-31
5  200611 2006-11-30

More Related Contents:

  1. Convert Excel style date with pandas
  2. Splitting timestamp column into separate date and time columns
  3. Which is the fastest way to extract day, month and year from a given date?
  4. Clean way to convert quarterly periods to datetime in pandas
  5. How to combine year, month, and day columns to single datetime column?
  6. How do I convert timestamp to datetime.date in pandas dataframe?
  7. Convert dates to pd.to_datetime where month could be either a number or month name
  8. Filtering Pandas DataFrames on dates
  9. Keep only date part when using pandas.to_datetime
  10. How to print pandas DataFrame without index
  11. How to convert string to datetime format in pandas python?
  12. How to format date string via multiple formats in python
  13. Pandas: Subtracting two date columns and the result being an integer
  14. Python Pandas: Group datetime column into hour and minute aggregations
  15. Generate a list of datetimes between an interval
  16. Sort a pandas dataframe series by month name
  17. Matplotlib DateFormatter for axis label not working
  18. Extract day of year and Julian day from a string date
  19. Comparing two date strings in Python
  20. Get week start date (Monday) from a date column in Python (pandas)?
  21. Pandas converting row with unix timestamp (in milliseconds) to datetime
  22. Python pandas convert datetime to timestamp effectively through dt accessor
  23. Locate first and last non NaN values in a Pandas DataFrame
  24. Extracting dates that are in different formats using regex and sorting them – pandas
  25. Pandas custom function to find whether it is the 1st, 2nd etc Monday, Tuesday, etc – all suggestions welcome
  26. Formatting “yesterday’s” date in python
  27. Python: Datetime to season
  28. Pandas datetimes with different formats in the same column
  29. Get weekday/day-of-week for Datetime column of DataFrame
  30. Plot pandas dates in matplotlib

Leave a Comment