Sahaj.blogs

Day page

12 Mar 2024

Study

Pandas · Cleaning data

Fixing messy columns: stripping and normalising strings, converting types with to_numeric, renaming, dropping duplicates and mapping categories.

  • The .str accessor applies string methods to a whole column at once.
  • pd.to_numeric(errors="coerce") turns unparseable values into NaN instead of crashing.

Read the post →