import pandas as pd
Sample messy data
df = pd.DataFrame(
{'raw_date': ['2026-11-13', '13/11/2026', 'Nov 13, 2026', 'invalid_date', None]}
)
Convert to standard datetime objects
df['clean_date'] = pd.to_datetime(
df['raw_date'], format='mixed', dayfirst=True, errors='coerce'
)
print(df)
Top comments (0)