How to parse date column in pandas

If you have a pandas column containing a date string

how-to-parse-date-column-in-pandas.py

df

df

Pandas DataFrame showing date column as string type

which is listed as object:

pandas_show_date_column.py

df["date"]

df["date"]

Pandas date column listed as object dtype before parsing parse it like this:

pandas_to_datetime.py

df["date"] = pd.to_datetime(df["date"])

df["date"] = pd.to_datetime(df["date"])

After which it will be listed as datetime64[ns]:

pandas_show_date_after.py

df["date"]

df["date"]

Pandas date column parsed as datetime64 ns type after pd.to_datetime

Check out similar posts by category: Pandas, Python

If this post helped you, please consider buying me a coffee or donating via PayPal to support research & publishing of new posts on TechOverflow