Skip to content

Beginner

Data Cleaning

Find duplicates, broken types and missing values without silently inventing facts.

Do not invent

A blank price stays blank or is dropped. Do not type a typical price to make a chart look complete. Record the rule you used.

Duplicates

Same name and same state with only capitalisation changed is one record. Same name in two states may be two businesses. Keep the rule on the data card.

Quiz

Two rows differ only by letter case. They are:
A price cell is empty. The right fix is: