Convert number of miliseconds from midnight from datetime objct using pandas

Question

I have datetime index

import pandas as pd
sample = ['2021-01-19 15:55:00-05:00',
          '2021-01-19 15:56:00-05:00',
          '2021-01-19 15:56:00-05:00']
sample = pd.to_datetime(sample)

I would like to create new column that represents time measured in the number of milliseconds since midnight.

There is one solution for seconds timeframe Get the time spent since midnight in dataframe but I was not able to convert it to miliseconds.

df['milliseconds'] = df['seconds'] * 1000 – Epsi95 Jan 23 '21 at 14:34 — Epsi95, Jan 23 '21 at 14:34
But isn't -05:00 milisecond part of timeframe? – Mislav Sagovac Jan 23 '21 at 15:12 — Mislav Sagovac, Jan 23 '21 at 15:12
-05:00 seems to be the deviation from GMT – Epsi95 Jan 23 '21 at 15:31 — Epsi95, Jan 23 '21 at 15:31

score 0 · Accepted Answer · answered Jan 23 '21 at 15:30

try

df = pd.DataFrame(sample, columns=['time'])
df['time'] = pd.to_datetime(df['time'])
df['milliseconds'] = df['time'].apply(lambda x: (x.hour * 3600 + x.minute * 60 + x.second)*1000)

df

output

    time                        milliseconds
0   2021-01-19 15:55:00-05:00   57300000
1   2021-01-19 15:56:00-05:00   57360000
2   2021-01-19 15:56:00-05:00   57360000

Convert number of miliseconds from midnight from datetime objct using pandas

1 Answers1