Lifetime access is $57 through 30 November.
Skillsh
Skillsh
Toggle sidebar
Login Get access · $57

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
Add to a chain