DEV Community

Priya
Priya

Posted on

Data Cleaning for messy Date

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)