Subtract a year from a datetime column in pandas

by

You can use DateOffset to achieve this:

In[88]:
df['NEW_DATE'] = df['ACC_DATE'] - pd.DateOffset(years=1)
df

Out[88]: 
        ACC_DATE   NEW_DATE
index                      
538   2006-04-07 2005-04-07
550   2006-04-12 2005-04-12

More Related Contents:

  1. Converting between datetime, Timestamp and datetime64
  2. Convert pandas timezone-aware DateTimeIndex to naive timestamp, but in certain timezone
  3. Convert Excel style date with pandas
  4. Combine Date and Time columns using python pandas
  5. datetime dtypes in pandas read_csv
  6. pandas dataframe groupby datetime month
  7. How to convert columns into one datetime column in pandas?
  8. pandas out of bounds nanosecond timestamp after offset rollforward plus adding a month offset
  9. Find the end of the month of a Pandas DataFrame Series
  10. Create a day-of-week column in a Pandas dataframe using Python
  11. python pandas extract year from datetime: df[‘year’] = df[‘date’].year is not working
  12. Converting between datetime and Pandas Timestamp objects
  13. Convert a column of datetimes to epoch in Python
  14. Pandas: How to create a datetime object from Week and Year?
  15. How to define format when using pandas to_datetime?
  16. pd.Timestamp versus np.datetime64: are they interchangeable for selected uses?
  17. pandas bar plot combined with line plot shows the time axis beginning at 1970
  18. Specifying date format when converting with pandas.to_datetime
  19. how to test if a variable is pd.NaT?
  20. Truncate `TimeStamp` column to hour precision in pandas `DataFrame`
  21. Datetime conversion – How to extract the inferred format?
  22. Python pandas integer YYYYMMDD to datetime
  23. What values are valid in Pandas ‘Freq’ tags?
  24. Python: Datetime to season
  25. How do I convert timestamp to datetime.date in pandas dataframe?
  26. Pandas datetimes with different formats in the same column
  27. Convert dates to pd.to_datetime where month could be either a number or month name
  28. Get weekday/day-of-week for Datetime column of DataFrame
  29. Plot pandas dates in matplotlib
  30. Pandas: select all dates with specific month and day

Leave a Comment