pandas and NumPy 3 · Cleaning and transforming
Parse dates
Convert text to datetimes, then pull out parts.
df["date"] = pd.to_datetime(df["date"])
df["month"] = df["date"].dt.month
Official pandas and NumPy 3 documentation
More cleaning and transforming commands
- Count missing values
- Drop rows with missing values
- Fill missing values
- Remove duplicate rows
- Rename columns
- Drop columns
All cleaning and transforming commands · pandas and NumPy 3 cheatsheet