如何在panda中读取时间列，以及如何将其转换为毫秒

Question

I used this code to read excel file
df=pd.read_excel("XYZ.xlsb",engine='pyxlsb',dtype={'Time':str})
This is just to show what i am getting after reading excel file.
import pandas as pd
import numpy as np
data = {'Name':['T1','T2','T3'],
'Time column in excel':['01:57:15', '00:30:00', '05:00:00'],
'Time column in Python':['0.0814236111111111', '0.0208333333333333', '0.208333333333333']}

df = pd.DataFrame(data)
print (df)
| left | Time column in excel | Time column in Python|
| T1  | 01:57:15              |  0.0814236111111111  |
| T2  | 00:30:00              |  0.0208333333333333  |
| T3  | 05:00:00              |  0.208333333333333   |

我想把这个时间读成excel中的时间，并想转换成毫秒，因为我想用时间来计算进一步工作的百分比时差

Answer 1

尝试将日期时间的微秒除以1000

def get_milliseconds(dt):
return dt.microsecond / 1000