how do I convert hh:mm:ss (0:1:19) to minutes using pandas

Question

I wanted to convert the following data into minute, but i always land up on error

time = 0:1:19

time1 = df['time']

time2 = time1.hour * 60 + time1.minute + time1.second

I get this error:

 "AttributeError: 'Series' object has no attribute 'hour'"

your first command `time = 0:1:19` is not a valid python command, at least python3 — brunoff, Feb 01 '21 at 18:01
Does this answer your question? [How to convert a datetime format to minutes - pandas](https://stackoverflow.com/questions/50392796/how-to-convert-a-datetime-format-to-minutes-pandas) — noah, Feb 01 '21 at 18:01
Syntax aside, the number of minutes is hours*60 + minutes + seconds/60. — chepner, Feb 01 '21 at 18:02
Also you could have a look at this: [convert time hh:mm:ss to minutes -python](https://stackoverflow.com/questions/48447123/convert-time-hhmmss-to-minutes-in-python/48447482) — ClaudiaR, Feb 01 '21 at 18:03

score 0 · Answer 1 · answered Feb 02 '21 at 06:55

use pd.to_timedelta to covnert time to timedelta to get seconds.

time1 = pd.Series(['0:1:19', '1:01:19', '0:0:19'])
obj = pd.to_timedelta(time1)
# convert to minutes
obj.dt.seconds / 60.0

    0     1.316667
    1    61.316667
    2     0.316667
    dtype: float64

how do I convert hh:mm:ss (0:1:19) to minutes using pandas

1 Answers1