Time difference between rows pandas dataframe

Question

I have a time variable in my dataframe and I am trying to come up with a new column that gives the time passed in minutes from one row to another. I was trying to use this function:

df["Time"].diff()

But I get the following error:

TypeError: unsupported operand type(s) for -: 'datetime.time' and 'datetime.time'

Is there any way I can create a column in pandas with the time difference from one row to the next one?

Does this answer your question? [How do I select rows from a DataFrame based on column values?](https://stackoverflow.com/questions/17071871/how-do-i-select-rows-from-a-dataframe-based-on-column-values) — Nayem Jaman Tusher, May 20 '22 at 09:31
Please provide enough code so others can better understand or reproduce the problem. — Alex B, May 20 '22 at 11:01

jezrael · Answer 1 · 2022-05-20T11:27:20.983

2

You can convert Time column to datetimes with default same date, so Series.diff working well:

df['difference'] = pd.to_datetime(df["Time"].astype(str)).diff()

edited May 20 '22 at 11:27

answered May 20 '22 at 09:30

jezrael

729,927
78
1,141
1,090

1

Can you explain why that should work? How can `diff()` work on a datetime.time type once converted to string? – alec_djinn May 20 '22 at 09:36
I tried it and it worked perfectly thank you! had to modify a bit to have it as a new column, but thank you very much – Natalia Caceres May 20 '22 at 11:26
@NataliaCaceres - You are welcome, code is edited for assign to column – jezrael May 20 '22 at 11:27

Time difference between rows pandas dataframe

1 Answers1