Difference between two timestamps in Pandas

I have the following two time columns: "Time1" and "Time2". I need to compute the column "Difference", which is (Time2-Time1) in Pandas:

Time1         Time2                 Difference
8:59:45       9:27:30               -1 days +23:27:45
9:52:29       10:08:54              -1 days +23:16:26
8:07:15       8:07:53               00:00:38

When Time1 and Time2 are at different hours, I get the result as "-1 days +". My desired result for the first two values ​​is given below:

Time1         Time2                 Difference
8:59:45       9:27:30               00:27:45
9:52:29       10:08:54              00:16:26

How can I get this output in Pandas?

Both times are in the 'datetime64 [ns]' dtype.

+4
source share
2 answers

, time1 time2 , time2 - time1, time2-time1 , timedeltas. , :

(df.Time1.dt.minute- df.Time2.dt.minute)
+3

, pandas 17.1:

import pandas as pd

d = {
    "start_time": [
        "8:59:45",
        "9:52:29",
        "8:07:15"
    ],
    "end_time": [
        "9:27:30",
        "10:08:54",
        "8:07:53"
    ]
}

from datetime import  datetime
df = pd.DataFrame(data=d)
df['start_time'] = pd.to_datetime(df['start_time'])
df['end_time'] = pd.to_datetime(df['end_time'])

df.end_time - df.start_time

0   00:27:45
1   00:16:25
2   00:00:38
dtype: timedelta64[ns]
+2

Source: https://habr.com/ru/post/1613806/


All Articles