• 1 Welcome
    • 1.1 Pre-Class Prep
    • 1.2 Learning Objectives
    • 1.3 Class Data
    • 1.4 About the Instructor
  • 2 Getting to Know our Data and Tools
    • 2.1 What is OpenRefine?
    • 2.2 Exploring the Data
    • 2.3 Uploading Data Into OpenRefine
    • 2.4 The OpenRefine Interface
  • 3 Basic Data Cleaning with OpenRefine
    • 3.1 Splitting Columns
    • 3.2 Undo/Redo
    • 3.3 Faceting Data
    • 3.4 Trimming Whitespace and Changing to Titlecase
    • 3.5 Clustering Data
    • 3.6 Sorting
  • 4 Advanced OpenRefine
    • 4.1 Pulling data from an API
    • 4.2 Extracting the Data
  • 5 Exporting Cleaned Data and Scripts
  • 6 Recommended Resources and Tutorials

Introduction to OpenRefine

Chapter 6 Recommended Resources and Tutorials

Here are some places to learn more about OpenRefine:

  • OpenRefine Website
  • OpenRefine User Manual
  • Library Carpentry - OpenRefine (heavily used for the basis of this lesson)
  • Data Carpentry – OpenRefine for Social Science Data
  • Grateful Dead OpenRefine Tutorial
  • Programming Historian - Fetching and Parsing Data with OpenRefine
  • Fetching URLS from OpenRefine
  • Reconciling Data with OpenRefine