Data Cleaning with OpenRefine

In this tutorial, we will work through the Carpentries lesson on OpenRefine, which is a free and open-source tool for working with messy data.

0:00 Introduction
4:30 Creating Projects
6:24 Faceting
9:04 Clusters
11:22 Splitting
13:11 Undo/Redo
14:17 Trim White Spaces
15:59 Filter/Sort
19:45 Scripts

1. Download this data file to your computer: https://ndownloader.figshare.com/file...

The data for this lesson are in the Portal Project Teaching Database (Links to an external site.) available on FigShare, with a CC-BY license available for reuse.

2. Setup (download OpenRefine, Java, set browser defaults): https://datacarpentry.org/OpenRefine-...

3. Other Resources:
https://datacarpentry.org/OpenRefine-...