Cleaning and Preparing Data
Getting from what you were given to what you can use
- 7 weeks
- 7 lessons
- Intermediate
- By application
Part of Become a data practitioner.
Starts after Working with Databases on Become a data practitioner.
Start with Data Foundations — freeYou’ll learn toContents
- Profile an unfamiliar dataset before changing anything in it
- Cluster and reconcile values that mean the same thing
- Keep a record of every change so the work can be repeated
Real data arrives inconsistent, duplicated and half-typed by hand. This is the unglamorous work that makes everything after it possible, taught on messy data rather than tidy examples.
- Look before you touch3 lessons
- The first twenty minutes
- Cleaning a real dataset, start to finish
- Check: profiling first
- Making values agree4 lessons
- Same thing, different spelling
- Cleaning moves
- Cleaning that can be repeated
- OpenRefine — download and docs
Share