pandas: create a new date time column by combining existing columns

Question

I am trying to create a new datetime column from existing columns (one datetime column and another integer column) in a pandas data frame. Here is my code:

import datetime
df['start_date'] = pd.to_datetime(df['start_date'])
df['end_date'] = df['start_date'] + pd.Timedelta(df.total_waiting_days, unit='D')

But I got the following errors:

ValueError: Value must be Timedelta, string, integer, float, timedelta or convertible

What did I do wrong here and how do I fix this? Thanks!

pd.to_datetime(df['start_date']) + pd.Timedelta(df.total_waiting_days, unit='D').............. — BENY
– BENY, Commented Apr 6, 2018 at 19:35

BENY · Accepted Answer · 2018-04-06 19:48:24Z

1

Seems like you want to convert whole column to Timedelta

df['end_date'] = df['start_date'] + df.total_waiting_days.apply(lambda x :pd.Timedelta(x, unit='D'))

answered Apr 6, 2018 at 19:48

BENY

324k22 gold badges176 silver badges250 bronze badges

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

Collectives™ on Stack Overflow

pandas: create a new date time column by combining existing columns

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