Pandas add one day to column

user_137783 0
Viewed 111959

I need to add 1 day to each date I want to get the begining date of the following month eg 2014-01-2014 for the 1st item in the dataframe. Tried: 

montdist['date'] + pd.DateOffset(1)

Which gives me: 

TypeError: cannot use a non-absolute DateOffset in datetime/timedelta operations [<DateOffset>]

Have a Dataframe:

    Units   mondist                date
1    6491  0.057785 2013-12-31 00:00:00
2    7377  0.065672 2014-01-31 00:00:00
3    9990  0.088934 2014-02-28 00:00:00
4   10362  0.092245 2014-03-31 00:00:00
5   11271  0.100337 2014-04-30 00:00:00
6   11637  0.103596 2014-05-31 00:00:00
7   10199  0.090794 2014-06-30 00:00:00
8   10486  0.093349 2014-07-31 00:00:00
9    9282  0.082631 2014-08-31 00:00:00
10   8632  0.076844 2014-09-30 00:00:00
11   8204  0.073034 2013-10-31 00:00:00
12   8400  0.074779 2013-11-30 00:00:00
pandas python
6 Answers

I think that the cleanest way to do this is a variant of szu's answer. Pandas has nearly full support datetime built into its functionality, so there is no need to load datetime; instead, if you are already using pandas, create the new column like this:

mondist['shifted_date'] = mondist.date + pd.Timedelta(days=1)
user_108330490

One quick mention. if you are using data-frames and your datatype is datetime64[ns] non indexed, Then I would go as below: Assuming the date column name is 'Date to Change by 1' and you want to change all dates by 1 day.

import time
from datetime import datetime, timedelta, date, time

before
['Date to Change by 1'] = 1/31/2020

df['Date to Change by 1'] = (pd.to_datetime(df['Date to Change by 1']) + 
timedelta(1)

After
['Date to Change by 1'] = 2/01/2020
user_118331980
Related