Using datetime timedelta with a series in a pandas DF

Question

I have a pandas sim_df that looks like this:

Now, I want to add another column, "date" that is the date corresponding to 'now' plus 'cum_days' (a delta time).

start = dt.datetime.now()
sim_df['date'] = start + dt.timedelta(sim_df['cum_days'])

But it looks like deltatime does not use a series, but a fixed scalar.

TypeError: unsupported type for timedelta days component: Series

Is there a way to solve this in a vectorized operation without iterating over each row of sim_df?

Answer 1

How about this?

start = dt.datetime.now()
sim_df['date'] = start + sim_df['cum_days'].map(dt.timedelta)

This applies dt.timedelta to each element of the cum_days column individually.