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.
