How to read time column in pandas and how to convert it into milliseconds

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   |

I want read this time exactly as in excel.and want to convert into milliseconds,as i want to use time to calculate time difference in percentage for further working

will you provide a sample of your data? datetime has a millisecond part. — Golden Lion, Dec 10 '21 at 15:17
A value like `0.208333` represents time? In what unit, fractional days? Output in milliseconds should then be milliseconds of the day? — FObersteiner, Dec 11 '21 at 10:01

score 0 · Answer 1 · answered Dec 10 '21 at 15:18

0

try dividing the microsecond of the datetime by 1000

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

answered Dec 10 '21 at 15:18

Golden Lion

3,840
2
26
35

How to read time column in pandas and how to convert it into milliseconds

1 Answers1