How to convert Str into Date time format in python?

Question

I have a data frame of type str which I want to convert into DateTime format and then want to create another column for time only in hour: min :sec

   TimeStamp
  20200706 07:00:00
  20200706 08:07:00
  20200706 08:28:00
  20200706 09:30:00
  20200706 09:31:00
  20200706 09:32:00

Additionally to Nicolos answer: in general you can use the standard libraries datetime and time. in datetime you would use strftime() and strptime() to read and write specific formats docs.python.org/3/library/…. time doesn't offer as much options, but sometimes it's faster to use. — Night Train
– Night Train, Commented Jul 10, 2020 at 9:06
Does this answer your question? Convert Pandas Column to DateTime — Night Train
– Night Train, Commented Jul 10, 2020 at 9:08

Nicolò Gasparini · Accepted Answer · 2020-07-10 08:40:13Z

2

to have it as timestamp

import pandas as pd
pd.to_datetime(df['Timestamp'])

To have another (string) column with hour, minutes and seconds

pd.to_datetime(df['Timestamp']).dt.strftime("%H:%M:%S")

answered Jul 10, 2020 at 8:40

Nicolò Gasparini

2,4063 gold badges29 silver badges58 bronze badges

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

1 Answer 1