Digital Scholarship Workshop Materials

Workshop materials:

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

Register for a Google Maps API key here: https://developers.google.com/maps/faq#new-key

Workshop materials are here.

Download the following from the Google Drive:

OR_humanities_workshop document

OR_humanities_basic worksheet

OR_humanities_geo worksheet

OR_humanities_group worksheet

Please follow the OR_humanities_workshop 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 the Chronicling America API
• Geocode with the Google Maps API
• Templating in OpenRefine to GeoJSON

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