13+ Can Only Use Dt Accessor With Datetimelike Values. Dfs= [] for f in files: Import pandas as pd testdata['prd_exp_dt'] = pd.to_datetime(testdata['prd_exp_dt'] ,errors = 'coerce',format = '%y.

Can only use.dt accessor with datetimelike values. You can use the parse_dates parameter when using read_csv. Just took a look at your query code, maybe it’s just simpler to rename the columns when you get your data in your.