7  Class Outline: QA/QC 2 - Open Refine

How many ways can you spell….

7.1 OpenRefine

Open Refine is a powerful, free, and open source tool that is used to work with and clean messy data. The website includes a user’s manual and links to more tutorials.

7.2 OpenRefine Tutorials

• Data Carpentry: Data Cleaning with OpenRefine for Social Scientists.

• Data Carpentry: Data Cleaning with OpenRefine for Ecologists
• Environmental Data Initiative OpenRefine Tutorial
• Cleaning Data with OpenRefine Video Tutorials:
  • Video Tutorial No. 1
  • Video Tutorial No. 2
• JHU Library: Cleaning Data with OpenRefine
• The Programming Historian: Cleaning Data with OpenRefine.

7.3 GREL Cheatsheets

• Belinda Weaver’s GREL Cheatsheet with examples
• OpenRefine GREL Manual
• A really good GREL Guide from the Univ Illinois
• Even better: code4lib Toronoto’s OpenRefine cheatsheets, including for GREL commands.
• Datenschule’s OR Cheatsheets

7.4 R Tools for OpenRefine

• The rrefine package allows you to do some OpenRefine tasks from within R.