Introduction

Importing Data to OpenRefine

Figure 1

Menu to create a new project

Figure 2

Menu to import data

Exploring Data with OpenRefine

Figure 1

Facet menu of a column

Figure 2

Faceting results on the column scientificName

Figure 3

Scatterplots between numeric columns

Transforming Data

Figure 1

OpenRefine tab for Undo/Redo actions

Figure 2

OpenRefine window for joining columns

Figure 3

OpenRefine window for clustering

Figure 4

Facet of scientificName after clustering

Filtering and Sorting with OpenRefine

Figure 1

OpenRefine filtering example

Exporting Data Cleaning Steps

Exporting and Saving Data from OpenRefine

Other Resources in OpenRefine