date format pandas dataframe code example

Example 1: format date field in pandas

df['date'] = pd.to_datetime(df["date"].dt.strftime('%Y-%m'))

Example 2: apply format to pandas datetime column

formatted_df = df["Date"].dt.strftime("%m/%d/%y")

Example 3: data format pandas

>>> pd.to_datetime('13000101', format='%Y%m%d', errors='ignore')
datetime.datetime(1300, 1, 1, 0, 0)
>>> pd.to_datetime('13000101', format='%Y%m%d', errors='coerce')
NaT