Pandas – Number of Months Between Two Dates

by

Here is a very simple answer my friend:

df['nb_months'] = ((df.date2 - df.date1)/np.timedelta64(1, 'M'))

and now:

df['nb_months'] = df['nb_months'].astype(int)

More Related Contents:

  1. Add missing dates to pandas dataframe
  2. Convert Excel style date with pandas
  3. Can pandas automatically read dates from a CSV file?
  4. Find the end of the month of a Pandas DataFrame Series
  5. Add months to a date in Pandas
  6. How do I convert strings in a Pandas data frame to a ‘date’ data type?
  7. python/pandas: convert month int to month name
  8. Python Pandas: Group datetime column into hour and minute aggregations
  9. Sort a pandas dataframe series by month name
  10. Matplotlib DateFormatter for axis label not working
  11. Splitting timestamp column into separate date and time columns
  12. Get week start date (Monday) from a date column in Python (pandas)?
  13. Pandas Merge on Name and Closest Date
  14. Diff of two Dataframes
  15. Computing np.diff in Pandas after using groupby leads to unexpected result
  16. changing all dates to standard date time in dataframe
  17. group by week in pandas
  18. Convert month int to month name in Pandas
  19. Which is the fastest way to extract day, month and year from a given date?
  20. Extracting dates that are in different formats using regex and sorting them – pandas
  21. Getting days since last occurence in Pandas DataFrame?
  22. Resample time series in pandas to a weekly interval
  23. Clean way to convert quarterly periods to datetime in pandas
  24. How to combine year, month, and day columns to single datetime column?
  25. How do I convert timestamp to datetime.date in pandas dataframe?
  26. Convert dates to pd.to_datetime where month could be either a number or month name
  27. String concatenation of two pandas columns
  28. How to create a large pandas dataframe from an sql query without running out of memory?
  29. How to add hovering annotations to a plot
  30. Writing a Python Pandas DataFrame to Word document

Leave a Comment