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? — Nayem Jaman Tusher
– Nayem Jaman Tusher, Commented May 20, 2022 at 9:31

jezrael · Accepted Answer · 2022-05-20 11:27:20Z

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, 2022 at 11:27

answered May 20, 2022 at 9:30

jezrael

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

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

3 Comments

alec_djinn Over a year ago

Can you explain why that should work? How can diff() work on a datetime.time type once converted to string?

Natalia Caceres Over a year ago

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

jezrael Over a year ago

@NataliaCaceres - You are welcome, code is edited for assign to column

Collectives™ on Stack Overflow

Time difference between rows pandas dataframe

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related