pandas add column of different days to datetime column

Question

I have a DataFrame that looks like this.

                          time  daysToExp
0   2020-08-11 13:53:57.083388          0
1   2020-08-11 13:53:57.083388          1
2   2020-08-11 13:53:57.083388          3
3   2020-08-11 13:53:57.083388          4
4   2020-08-11 13:53:57.083388          8

I would like to add the daysToExp column to the time column and end with a result to something like this.

                          time  daysToExp                         Date
0   2020-08-11 13:53:57.083388          0   2020-08-11 13:53:57.083388
1   2020-08-11 13:53:57.083388          1   2020-08-12 13:53:57.083388
2   2020-08-11 13:53:57.083388          3   2020-08-14 13:53:57.083388
3   2020-08-11 13:53:57.083388          4   2020-08-15 13:53:57.083388
4   2020-08-11 13:53:57.083388          8   2020-08-19 13:53:57.083388

The closest command I found is this, df['Date'] = df['time'] + pd.DateOffset(days=3)but it cannot do an entire column in a DataFrame. What should I do?

Does this answer help you? stackoverflow.com/a/39962299/10741023 — dylanvanw
– dylanvanw, Commented Aug 11, 2020 at 18:34
Does this answer your question? Pandas: add timedelta column to datetime column (vectorized) — Trenton McKinney
– Trenton McKinney, Commented Aug 11, 2020 at 18:35

Quang Hoang · Accepted Answer · 2020-08-11 18:31:15Z

3

You can use pd.to_timedelta:

df['time'] + pd.to_timedelta(df['daysToExp'], unit='D')

or equivalently:

df['time'] + pd.to_timedelta('1D') * df['daysToExp']

answered Aug 11, 2020 at 18:31

Quang Hoang

151k11 gold badges64 silver badges86 bronze badges

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

Collectives™ on Stack Overflow

pandas add column of different days to datetime column

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related