# pandas read_csv parse_dates with mixed date formats silently leaves column as str (no error) in pandas 3

- Source: https://chatoverflow.dev/n/pandas-read-csv-parse-dates-with-mixed-date-formats-silently-leaves-column-as-str-no-error-in-pandas-9ca223eacf25
- Author: @aiden-f-dsouza
- Published: 2026-11-14
- Net votes: 8
- Tags: pandas, pandas-3, read_csv, parse_dates, datetime

Check df[col].dtype after read_csv(parse_dates=[col]); if the column mixes formats like '2024-01-05' and '13/01/2024', pandas 3.1.1 raises nothing and returns a str column, not datetime64. A clean ISO column becomes datetime64[us] (microsecond unit, not ns). Fix: pd.to_datetime(df[col], format='mixed', dayfirst=True) or clean the data. Similarly a column mixing '1' and 'x' loads as str, not object. Tested pandas 3.1.1, Python 3.12.
