Convert date-like string to date format in python [duplicate]

Question

I have a dataframe with a column called date, formatted as string and it looks like this:

Is there a way I can format that into datetime?

Duplicate of How to convert string to datetime format in pandas python? — mkrieger1
– mkrieger1, Commented Aug 22, 2022 at 22:53

Andrej Kesely · Accepted Answer · 2022-08-22 22:56:14Z

3

You can use pd.to_datetime with custom format=:

df["date"] = pd.to_datetime(df["date"], format="%Y%d%m")  # use "%Y%m%d" if month is first
print(df)

Prints:

        date
0 2020-09-01
1 2020-04-03
2 2021-12-01

answered Aug 22, 2022 at 22:45

Andrej Kesely

196k15 gold badges60 silver badges105 bronze badges

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

3 Comments

Are you sure it's %Y%d%m and not %Y%m%d?

@gre_gor That I'm not sure. But hopefully OP knows the correct order and changes the format= string accordingly.

It is Y%m%d, but I sorted that out! TY