Test Yourself: Cleaning Data With OpenRefine

Putting Your Skills to the Test

1. Download the McTaggart Cowan dataset.
2. Clean up this spreadsheet using the skills learned in previous activity.

Suggested Actions:

1. Create facets to learn about the fields
2. Identify and remove blank rows
3. Cluster and standardize metadata in the “sex” field
4. Split entries in the “decimal latitude decimal longitude” fields into new columns, and rename the new columns
5. Split entries in “verbatim locality” field and then Join the province and region data into a new field titled “Region”

NEXT STEP: Earn a Workshop Badge