Adding incrementing date value to a column in Pandas

Question

I would like to make a column in existing Pandas df that will be an increment(minutes based, for example) to a set date value, so another words trying to do smth like that:

df_test['date_min'] = datetime.datetime(2019, 3, 1) + pd.to_timedelta(1,unit='min')

I tried this approach and also using for loop but I don't receive an increment just the stable values. How can this task be done in Pandas?

Thanks!

yatu · Accepted Answer · 2019-07-25 09:55:34Z

3

You could use pd.date_range. Just set an initial datetime, a number of periods to add according to the dataframe's shape and a frequency:

df_test['date_min'] = (pd.date_range(start=datetime.datetime(2019, 3, 1), 
                                     periods=df_test.shape[0], 
                                     freq='min'))

answered Jul 25, 2019 at 9:55

yatu

88.7k12 gold badges93 silver badges148 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Adding incrementing date value to a column in Pandas

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related