How to convert miliseconds to datetime with format: mm:ss:msmsms (minutes:seconds:miliseconds) without year , month an day

Question

Is there a simple way to convert milliseconds in a dataframe to a datetime without year, month and day?

I have successfully converted a column of milliseconds to datetime. However, I want to get rid of the year, months and days.

I did this:

df['Laptimes'] = pd.to_datetime(df['milliseconds'], unit='ms')

But my values are now formatted as: "1970-01-01 00:01:38.109".

I want to have: "01:38:109"

https://docs.python.org/2/library/datetime.html#datetime.date.strftime and https://docs.python.org/2/library/datetime.html#strftime-strptime-behavior — Joe, Aug 21 '18 at 13:22

Hkoof · Answer 1 · 2018-08-21T16:12:08.183

0

Just call the time() method on the datetime object:

df['Laptimes'].time()

edited Aug 21 '18 at 16:12

answered Aug 21 '18 at 13:56

Hkoof

1 Answers1