Data Analysis
//Intermediate
Data Cleaning Pipeline
Cleans messy CSV or Excel data with a reproducible pandas script: standardizes column names, types, dates, casing and categories, trims whitespace, deduplicates on a defined key, validates rules, and quarantines rejected rows with reasons instead of silently dropping them. Use when the user has a messy export, inconsistent spreadsheet, duplicate records or failed import and needs analysis-ready, tidy data plus a cleaning log.
Preview
# Data Cleaning Pipeline Cleaning by hand can't be repeated or audited. This skill turns a messy export into tidy, validated data with a script you can rerun next month, a quarantine file for every rejected row, and a log of exactly what changed. ## When to
Related skills