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(0)

The 0 in MonthEnd just specifies to roll forward to the end of the given month. Note that if we’d used MonthEnd(1), then we’d have got the next date which is at the end of the month.
If you wanted the last day of the next month, you’d then add an extra MonthEnd(1), 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

Related Contents:

  1. How to set a variable to be “Today’s” date in Python/Pandas
  2. Splitting timestamp column into separate date and time columns
  3. How do I get the day of week given a date?
  4. How to calculate number of days between two given dates
  5. How do I get a value of datetime.today() in Python that is “timezone aware”?
  6. Convert Pandas Column to DateTime
  7. Keep only date part when using pandas.to_datetime
  8. Get month name from number
  9. How to print pandas DataFrame without index
  10. Formatting “yesterday’s” date in python
  11. datetime dtypes in pandas read_csv
  12. Add missing dates to pandas dataframe
  13. Combine Date and Time columns using pandas
  14. Cleanest and most Pythonic way to get tomorrow’s date?
  15. Convert pandas timezone-aware DateTimeIndex to naive timestamp, but in certain timezone
  16. Calculate Time Difference Between Two Pandas Columns in Hours and Minutes
  17. how to test if a variable is pd.NaT?
  18. Convert dataframe index to datetime
  19. How do I sort a list of datetime or date objects?
  20. Converting between datetime and Pandas Timestamp objects
  21. How to add/subtract time (hours, minutes, etc.) from a Pandas DataFrame.Index whos objects are of type datetime.time?
  22. How to convert string to datetime format in pandas python?
  23. Pandas: Subtracting two date columns and the result being an integer
  24. Pandas: Convert Timestamp to datetime.date
  25. Check if string has date, any format
  26. Locate first and last non NaN values in a Pandas DataFrame
  27. Get Day name from Weekday int
  28. User-friendly time format in Python?
  29. Find the closest date to a given date
  30. Pandas: Return Hour from Datetime Column Directly
  31. Python pandas convert datetime to timestamp effectively through dt accessor
  32. How would I compute exactly 30 days into the past with Python (down to the minute)?
  33. Get weekday/day-of-week for Datetime column of DataFrame
  34. datetime to string with series in pandas
  35. Comparison between datetime and datetime64[ns] in pandas
  36. Add months to a date in Pandas
  37. Get total number of hours from a Pandas Timedelta?
  38. Convert Gregorian (Christian) date to Persian date and vice-versa in Python
  39. Checking date against date range in Python
  40. pandas datetime to unix timestamp seconds
  41. Truncate `TimeStamp` column to hour precision in pandas `DataFrame`
  42. Pandas converting row with unix timestamp (in milliseconds) to datetime
  43. Subtract a year from a datetime column in pandas
  44. change multiple columns in pandas dataframe to datetime
  45. pandas extract year from datetime: df[‘year’] = df[‘date’].year is not working
  46. Convert column of date objects in Pandas DataFrame to strings
  47. Comparing two date strings in Python [duplicate]
  48. Converting time zone pandas dataframe
  49. Pandas – Number of Months Between Two Dates
  50. Python pandas integer YYYYMMDD to datetime

Leave a Comment