Worksheet · Data Analysis · Data Management
Data cleaning checklist and report template
From the lesson Data Preparation
Work through each step on paper or on screen. Use a real business, a project of your own or a friend’s idea. Keep this page for your portfolio.
1Take a small messy data set.
2Clean it step by step.
3Document your changes with the data cleaning checklist.
Worked example to compare with: Cleaning a customer list
- Problem: "Ottawa", "ottawa" and "OTTAWA" appear as three cities.
- Fix: convert to one format.
- Problem: the same customer appears twice with different emails.
- Fix: match on name and phone, then merge.
- Check: count the rows before and after, and note what changed so others can repeat it.
Check yourself
- I can explain "Data Preparation" in one sentence.
- I used a real business or project, not just an idea.
- I know what I will do next, and by when.
Notes
Free course worksheet · https://studentmarketers.com