I am trying to subtract End_time and start_time to find the duration. Can you please help me how to do this?
Example:
df['start_time'] = 01-04-2020 03:29:35
df['end_time'] = 01-04-2020 03:29:50
desired output:
df['duration'] = 00:00:15
Asked
Active
Viewed 433 times
1
alka
- 71
- 7
-
Use `df['duration'] = df['end_time'] - df['start_time']` – jezrael Jan 04 '20 at 10:21
-
@jezrael i am getting error - unsupported operand type(s) for -: 'str' and 'str' – alka Jan 04 '20 at 10:24
-
Convert borh columns to datetimes before subtracting – jezrael Jan 04 '20 at 10:25
-
@jezrael can you please tell me how to do this? – alka Jan 04 '20 at 10:25
-
`df['duration'] = pd.to_datetime(df['end_time']) - pd.to_datetime(df['start_time'])` – jezrael Jan 04 '20 at 10:28
-
@jezrael in output- ' 0 days 00:00:11'. days is also coming. – alka Jan 04 '20 at 10:36
-
@jezrael how to get time only in output. – alka Jan 04 '20 at 10:37
-
added new dupe for convert timedeltas to strings – jezrael Jan 04 '20 at 11:23