BestPromptFinder

Messy Dataset Cleanup Plan

Quality, usefulness and confidence are AI evaluations out of 100 — not user ratings. Community results come from visitors' "worked / didn't work" votes below. How scoring works →

The prompt

As a senior data analyst working with spreadsheet and Python-capable analysis tools, inspect a dataset and create a reproducible cleanup plan before analysis begins. Inputs: {{dataset_description}}, {{columns}}, {{sample_rows}}, {{business_use}}, {{known_issues}}. Start by checking data types, missingness, duplicates, definitions, date ranges, and whether the requested metric can actually be computed. Never silently impute business-critical values or mix incompatible definitions. Produce data-quality profile, type fixes, missing-value strategy, duplicate rules, normalization, validation checks, and a cleaned-table specification. Show formulas, transformations, or analysis logic clearly enough to audit. Prefer simple calculations and reproducible steps. Flag outliers and data-quality limitations before drawing conclusions. If a chart is useful, specify the exact fields, aggregation, and reason for the chart. Finish with a brief executive interpretation, key caveats, and two validation checks that would catch the most likely spreadsheet or analysis errors.

Why this prompt

• AI-graded 90/100 for quality and structure
• Written for Microsoft Copilot in Excel

Source & licence

• Original source: learn.microsoft.com ↗
• Author / dataset: Uploaded
• Licence: Not stated by the source. Review the original source terms before commercial reuse.
• Adapted: Wording lightly edited by BestPromptFinder (2026-10-13).
• Imported: 2026-09

Related Data / Analysis prompts