My df looks like this. I tried many ways to convert the time of:
hour:minute:second microseconds,
but hit a wall. Bellow is the sample.df.
I need the Time and micro-seconds (the 3 numbers after 00:00:02 948, so the micro seconds in this row would be: 948.
How to make another column of Time object that pandas will be able to work- like with fast vectorizing (not itterating) later on. I do not need year, month, day, date. Just need theTime, with microseconds, formated in a way to be acceptable for work by pd, like making aggregated time intervals etc. Any ideas would be greatly appreciated!
idx, time, col2, col3, col4, col5, col6
0 00:00:02 948 41 14 34 36 55
1 00:00:03 228 44 -12 32 41 55