aj-geddes avatar

Data Cleaning Pipeline

This handles the standard data cleaning workflow: dealing with missing values, spotting outliers, removing duplicates, and standardizing formats. You'd reach for it when you're staring at messy raw data that needs to be analysis-ready. It's designed for building automated preprocessing pipelines, which is honestly where most data work time goes. The repo has 245 stars and sits in a collection of AI prompts, so it's likely a prompt template rather than executable code. Worth noting that the actual implementation details are light in the source, so you'll want to check the full SKILL.md to see exactly what techniques and approaches it covers before adding it to your workflow.

GitHub stars
317
last updated
Aug 21, 2026

Install

$ npx -y skills add aj-geddes/useful-ai-prompts --skill 'Data Cleaning Pipeline' --agent claude-code

Installs into .claude/skills of the current project.

Files

Data Cleaning Pipeline

Overview

Data cleaning pipelines transform raw, messy data into clean, standardized formats suitable for analysis and modeling through systematic handling of missing values, outliers, and data quality issues.

When to Use

  • Preparing raw datasets for analysis or modeling
  • Handling missing values and data quality issues
  • Removing duplicates and standardizing formats
  • Detecting and treating outliers
  • Building automated data preprocessing workflows
  • Ensuring data integrity and consistency

Core Components

  • Missing Value Handling: Imputation and removal strategies
  • Outlier Detection & Treatment: Identifying and handling anomalies
  • Data Type Standardization: Ensuring correct data types
  • Duplicate Removal: Identifying and removing duplicates
  • Normalization & Scaling: Standardizing value ranges
  • Text Cleaning: Handling text data

Cleaning Strategies

  • Deletion: Removing rows or columns
  • Imputation: Filling with mean, median, or predictive models
  • Transformation: Converting between formats
  • Validation: Ensuring data integrity rules

Implementation with Python

Sponsors

Details

Repository
github.com/aj-geddes/useful-ai-prompts
Categories
DevOps & CI/CD, Code Review & Quality, AI & Agent Building, Automation & Workflows, Sales & Marketing
First seen
Jun 3, 2026

More from aj-geddes/useful-ai-prompts

All 258
1butterbase-ai avatarjourney-deploybutterbase-ai/butterbase-skillsUse as the deploy-verification stage of the Butterbase journey, after journey-frontend (or after any build stage if there is no frontend). Smoke-tests the deplo0skills.sh installs
2masharratt avatarcfn-error-managementmasharratt/claude-flow-noviceUnified error handling, batching, and logging for CFN Loop. Use when you need to capture agent errors, batch multiple errors for processing, log structured erro0skills.sh installs
3METR avatarmonitoringMETR/inspect-actionMonitor Hawk job status, view logs, and diagnose issues. Use when the user wants to check job progress, view error logs, debug a failing job, or generate a moni0skills.sh installs
4microsoft avatarazure-kubernetesmicrosoft/github-copilot-for-azurePlan, create, and configure production-ready Azure Kubernetes Service (AKS) clusters. Covers Day-0 checklist, SKU selection (Automatic vs Standard), networking 0skills.sh installs
5rknall avatarGitLab Stack Config Generatorrknall/claude-skillsGenerates service-specific configuration files for GitLab stack projects in ./config directory, using .env as the primary configuration source. Creates nginx, P0skills.sh installs
6rknall avatarGitLab Stack Creatorrknall/claude-skillsCreate new GitLab stack projects from templates with proper directory structure, git configuration, validation hooks, and documentation. Use when initializing n0skills.sh installs