Data Cleaning Recipes for Pandas
Twenty battle-tested prompts that fix the messiest CSVs on the first pass.
by Ava ChenPublished Jul 18, 20260 sales
About this skill
A recipe book of prompts for the ugliest 20% of data work: mixed date formats, half-encoded unicode, duplicate rows that aren't quite duplicates, and columns that changed meaning halfway through the file. Each recipe includes the prompt, the pandas pattern it should produce, and a validation check so you know the cleaning actually worked.