Digital Scholarship Workshop Materials

Workshop materials:

Download Open Refine here:http://openrefine.org/download.html

Workshop materials are here.

Download the following from the Google Drive:

OR_catalogers_workshop document

OR_catalogers worksheet

OR_catalogers_names worksheet

Please follow the OR_catalogers_tutorial documentation for easy cutting and pasting throughout.

Objectives of this workshop:

• Creating a project

• Understanding the interface

• Faceting and Clustering data

• Splitting and Trimming data

• Editing data

• Using basic GREL

• Using the FAST API for subject headings

• Reconciling name entities with Wikidata, LCNAF, and VIAF

Introduction

What is Open Refine? Why use it?

Some important notes:

• It’s not a spreadsheet or a database, but it has the look and feel of spreadsheets with the robustness of a database.

• Don’t try to use it for data entry. Add your data in Excel or another program first, then import.

• You get infinite undos!

• You can apply actions/transformations from one project to another for quick data manipulation.

• Although Open Refine can handle thousands of rows of data, it is suggested that you don’t try to do anything with huge datasets. Break them into smaller sections if possible.

More resources:

Library Carpentry OpenRefine

Open Refine Github Repository