Date and time extraction from Excel file in Python or Pandas
Pandas can parse most dates formats using
import pandas as pd
pd.to_datetime(df[&quot;name of your date column&quot;])

You can also cast the desired column to datetime64 which is Numpy dtype
df = df.astype({&quot;column name&quot;: &quot;datetime64&quot;})