Pandas datetime column operation

Question

I have dataframe that look like this.

| Date_Time           | Execution_Time |  
|---------------------|----------------|  
| 2019-10-10 09:07:29 | 14.0           |
| 2019-09-21 19:47:01 | 14.3           |
| 2019-09-19 02:49:49 | 14.1           |
| 2019-09-27 23:19:16 | 21.9           |
| 2019-09-05 18:46:00 | 14.2           |

The execution is in seconds. How can I add Date_Time and Execution_Time ?

datatype for Date_Time: object, Execution_Time: float64

I have tried df['diff'] = df['Date_Time'] + df['Execution_Time'] and it returns following error:

TypeError: ufunc 'add' did not contain a loop with signature matching types dtype('<U32') dtype('<U32') dtype('<U32')

jezrael · Accepted Answer · 2020-03-11 07:30:30Z

4

First column convert to datetimes by to_datetime and second to timedeltas by to_timedelta:

df['diff'] = (pd.to_datetime(df['Date_Time']) + 
              pd.to_timedelta(df['Execution_Time'], unit='s'))
print (df)
             Date_Time  Execution_Time                    diff
0  2019-10-10 09:07:29            14.0 2019-10-10 09:07:43.000
1  2019-09-21 19:47:01            14.3 2019-09-21 19:47:15.300
2  2019-09-19 02:49:49            14.1 2019-09-19 02:50:03.100
3  2019-09-27 23:19:16            21.9 2019-09-27 23:19:37.900
4  2019-09-05 18:46:00            14.2 2019-09-05 18:46:14.200

answered Mar 11, 2020 at 7:30

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

1 Comment

Dzakirin Over a year ago

Thank you very much for helping me. previously i tried newdf[["Date_Time","Execution_Time"]] = newdf[["Date_Time","Execution_Time"]].apply(pd.to_datetime) to convert both to date time.. but the 'Execution_time' Column value got messed up.. Thank you again

Collectives™ on Stack Overflow

Pandas datetime column operation

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related