format = '%Y-%m-%d'

而不是'yyyy-mm-dd'

dict_datetime = {}
for i in [0, '0', '', np.nan, pd.NaT, None]:
    try:
        dict_datetime[i] = pd.to_datetime(i, format='%Y-%m-%d')
    except:
        dict_datetime[i] = 'error'
df_datetime = pd.DataFrame.from_dict(dict_datetime, orient='index', columns=['result']).reset_index()
df_datetime['index'] = df_datetime['index'].apply(lambda x: '\'' + str(x) + '\'' if isinstance(x, str) else x)
display(df_datetime)

判断是否是日期_pandas