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)