Prompting Skills playbook/Module 4 · Documents & data

Day 39 / 100 · Documents & data · Data cleaning

Messy data? Clean it first.

AI is excellent at messy data, but you don't have to hand it your data. Ask for the method and run it yourself.

Standardise

Job 01

Dates, phone numbers, currency and names in one format.

ASK

“Convert all numbers to +27 format.”

De-duplicate

Job 02

The same customer spelled three different ways.

ASK

“Suggest rules for spotting duplicates.”

Flag, don't fill

Job 03

Missing values marked, not guessed.

ASK

“Mark blanks as [MISSING].”

Validate

Job 04

Catch impossible values: bad emails, future birth dates.

ASK

“List the checks, then the formula.”

Ask for the recipe. Cook it yourself.