VideoPrompt

Explore, Create & Generate Powerful AI Prompts

Free AI Video Prompt Library

Claude Prompt: Data Cleaning and Transformation Checklist + Formulas
Synthetic Prompts

Claude Prompt: Data Cleaning and Transformation Checklist + Formulas

A prompt template for Claude to generate a step-by-step plan for data cleaning and transformation, including identifying issues, providing repair steps (Excel/Python formulas), and defining new calculated columns.

✦ Prompt
Upload your Excel/CSV file.

Give me a step-by-step cleaning and transformation plan:

1. All issues found (missing, duplicates, type errors, outliers...)

2. Exact steps to fix each issue (Excel formulas, Power Query, or Python)

3. New calculated columns that should be created (e.g., Profit = Revenue - Cost)

4. Final cleaned table structure (column names
Category: