How to add 1 more month to datetime that end up as the first day of month?

Asked Feb 24 '20 at 07:19

Active Feb 24 '20 at 07:19

Viewed 26 times

My expectation:

'2019-02-01' + 1 month -> '2019-03-01'

My try code:

(pd.Timedelta(1, unit = 'M') + pd.to_datetime('2019-01-01'))

However it ends up with this result:

Timestamp('2019-03-03 10:29:06')

I want it to be exactly the first day of the month

asked Feb 24 '20 at 07:19

Chau Loi

check this https://stackoverflow.com/questions/46741423/add-months-to-a-date-in-pandas – Siva Shanmugam Feb 24 '20 at 07:21
3

Use `pd.to_datetime('2019-02-01') + pd.DateOffset(months=1)` – jezrael Feb 24 '20 at 07:21

0 Answers0