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

Reconciliation of Values

Figure 1

  • https://eol.org/api/reconciliation Prompt to add a service URL for reconciliation

    • Figure 2

    Reconciliation menu

    Figure 3

  • In the scientificName column you should be able to see the various potential matches. Clicking on a match will take you to the EOL page for that entity Reconciliation menu for each cell

    • Figure 4

    Column with the identifiers from reconciliation

    Looking Up Data

    Figure 1

    Add column by fetching URLs screen capture

    Figure 2

    Example of the results of fetching data from GBIF

    Figure 3

    Parse JSON to extract taxonomic family

    Exporting Data Cleaning Steps

    Exporting and Saving Data from OpenRefine

    Other Resources in OpenRefine