When I subtract two timestamps in a dataframe ,I am getting output "0 days 00:07:30" ; How do I convert it into minutes?

Question

diff=table['DelayInMinute']=(pd.to_datetime(table['joinTime']) - 
     pd.to_datetime(table['ScheduleDateTime']))

Output: "0 days 00:00:00"

diff_minute=pd.Timedelta(diff).total_seconds()/60.0;

But getting

ValueError: Value must be Timedelta, string, integer, float, timedelta or convertible

score 3 · Accepted Answer · answered Oct 22 '18 at 12:50

3

You can use Series.dt.total_seconds if multiple values of Series:

diff_minute=diff.dt.total_seconds()/60.0

If want output scalar by first value use iat for select first value with Timedelta.total_seconds, converting to Timedelta is not necessary:

diff_minute=diff.iat[0].total_seconds()/60.0

answered Oct 22 '18 at 12:50

jezrael

excellent answer as always! – Karn Kumar Oct 22 '18 at 12:55
I guess I was not using "dt." in the above code. Anyway thanks for the quick reply superman! – RAVI VERMA Oct 22 '18 at 12:55
@pygo - Thank you, but not always... – jezrael Oct 22 '18 at 12:56
1

@jezrael, since i started learning pandas i see your ans really the good one so i can say :-) – Karn Kumar Oct 22 '18 at 12:58

1 Answers1