python - In Pandas, how to convert a string to a datetime object with milliseconds?

Question

I have a column of event's timestamp in my dataframe, looks like "2016-06-10 18:58:25:675", the last 3 digits are milliseconds, is there a efficient way to transform this column to a Pandas datatime type?

When I try:

pd.to_datetime('2016-06-10 18:57:35:317')

An error occurs saying "Unknown string format".

Answer 1

Something like this should work

pd.to_datetime('2016-06-10 18:57:35:317', format="%Y-%m-%d %H:%M:%S:%f")

You can look up datetime formats here