how to convert a string to timetuple in Python

Question

Suppose I have a Dataframe as:

df = {'date':['20170101', '20170102', '20170103', '20170104']}

I want to convert '20170101' to '2017-01-01 00:00:00'

How can I achieve it?

Answer 1

You could convert your date time string to datetime object. And then get whatever format you want:

from datetime import datetime

datetime.strptime("20170103", "%Y%m%d").strftime("%Y-%m-%d %H:%M:%S")

Output:

"2017-01-03 00:00:00"