How to convert string timestamp to datetime object in Python

Question

I have a pandas column with timestamp strings in the format '00:00:00.000' (hours, minutes, seconds, micro seconds). I would like to convert them to datetime objects to work on the seconds.

I have seen many similar questions here for example. I am guessing that I should use strptime but I couldn't figure out how.

jezrael · Accepted Answer · 2021-04-13 05:37:07Z

1

If convert values to datetimes in pandas, also there is added some default date by to_datetime:

df['col'] = pd.to_datetime(df['col'], format='%H:%M:%S.%f')

If need avoid it convert values to timedeltas by to_timedelta:

df['col'] = pd.to_timedelta(df['col'])

edited Apr 13, 2021 at 5:37

answered Apr 13, 2021 at 5:33

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

jezrael Over a year ago

@Ynjxsjmh - Ya, I know, explained more.

Collectives™ on Stack Overflow

How to convert string timestamp to datetime object in Python

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related