Python Data Cleaning Cookbook
by Michael Walker · Michael Walker
Recipe-style solutions for detecting and fixing messy data in pandas and NumPy, from missing values and outliers to merging and reshaping. Each recipe is self-contained, so you can look up a specific cleaning problem as it arises.
This link may earn us a small commission at no extra cost to you. Affiliate disclosure
More resources on Data Wrangling
Tidyverse
The official home of R's tidyverse packages, with documentation and guides for dplyr, tidyr, and readr. Covers the shared design philosophy so you can reshape, filter, and join data frames consistently.
Pandas Documentation
The official pandas user guide, organized by task: indexing, merging, reshaping, grouping, and handling missing values. Reading it end to end gives you command of DataFrame operations and the idioms experienced Python analysts rely on.
Data Wrangling with Pandas
A single-sitting video walkthrough of pandas by Keith Galli, working through loading CSV files, filtering rows, aggregating, and saving results. By the end you can perform the common cleaning steps on a real dataset yourself.
Cleaning Data with Python
Learn data-wrangling essentials! This DataCamp course teaches you how to clean messy data with Python for effective analysis.
Data Analysis with Python and Pandas Tutorial
First video in Corey Schafer's pandas series, walking through installing pandas and Jupyter, loading a CSV survey dataset into a DataFrame, and inspecting its shape, columns, and rows. Viewers finish able to set up a working environment for data analysis in Python.
Data Visualization Full Course - Learn Data Visualization in 7 Hours
A long-form Python course covering NumPy arrays, Pandas dataframes, and plotting with Matplotlib and Seaborn. Work through it to load, clean and summarize tabular datasets, then chart the results in code.