Covert time mm:ss.ms to seconds

Question

I have a time column in my dataframe that has values like 20:14.4 and I am trying to convert it to seconds.

I have tried df['time'].str.split(':').apply(lambda x: int(x[0]) * 60 + int(x[1])) but the milliseconds at the end would not let it work. The datatype is object. Kindly help. enter image description here

this might help https://stackoverflow.com/a/10663851/1496419 take note of the `.%f` for your milliseconds. — Lex Bryan, Oct 07 '22 at 14:11

score 0 · Answer 1 · answered Oct 07 '22 at 14:11

0

what is the datatype of the time column?

pd.to_timedelta(df['time']).dt.total_seconds()

to get rid of the fraction part

pd.to_timedelta(df['time']).dt.total_seconds().astype(int)

answered Oct 07 '22 at 14:11

Naveed

11,495
2
14
21

Triaction · Answer 2 · 2022-10-09T06:14:38.463

0

Finally found a solution to the problem enter image description here

df['mins'] = pd.to_datetime(df['Time'], format='%M:%S.%f').dt.minute

df['sec'] = pd.to_datetime(df['Time'], format='%M:%S.%f').dt.second

df['Time(s)'] = ((df['mins']*60) + df['sec'])

edited Oct 09 '22 at 06:14

answered Oct 09 '22 at 06:14

Triaction

7
4

Covert time mm:ss.ms to seconds

2 Answers2