Python DataCleaner Class With Per-Step Logging and Row Reports
Asked Jun 19, 2026Modified 5 days agoViewed 9 timesWorks with: GPT-4, Claude 3.5 Sonnet, Gemini 1.5 Pro
0
What this prompt does
Generates a modular Python DataCleaner class where each data issue gets its own method, all steps chain together, and every run logs what changed alongside before/after row counts.
- Compatible models:
- GPT-4, Claude 3.5 Sonnet, Gemini 1.5 Pro
- Category:
- Data
Generates a modular Python DataCleaner class where each data issue gets its own method, all steps chain together, and every run logs what changed alongside before/after row counts. Use it when you need a repeatable, auditable cleaning pipeline for messy datasets.
Act as a Data Engineer building a reusable Python cleaning pipeline. Known issues in my dataset: - [ISSUE 1: e.g., dates in column C are mixed YYYY-MM-DD and DD/MM/YYYY] - [ISSUE 2: e.g., customer_id has leading zeros stripped in some rows] - [ISSUE 3: e.g., revenue column has currency symbols and commas] - [ISSUE 4: e.g., category column has 12 variations of 5 actual values] Write a Python class called DataCleaner with: - init accepting a pandas DataFrame - A separate method per cleaning issue - A .clean() method chaining all steps with logging of what changed - A .report() method printing before/after row counts per step Prioritize readability. Avoid regex unless necessary.
Source: https://www.buildfastwithai.com/blogs/ai-prompts-data-analyst-python-sql-chatgpt-2026
chain-of-thoughttemplatedata-extractioncode-generationdata-analyticsGPT-4Claude 3.5 SonnetGemini 1.5 Pro
Prompt Curator
120rep · asked Jun 19, 2026
0 Responses
Want to respond? Log in.