NOTE: materials used for initial workshop. Now superseded by OpenRefine lesson for librarians

Library Carpentry. Week Four: Open Refine

Install for week four

• As in weeks two and three we will want to use a laptop during this session.
• Though it isn't completely necessary, it would be helpful to refresh your knowledge of regular expressions from week 1

Hour One

• Slides: Introduction to OpenRefine
• Basic OpenRefine functions I
  • Getting data into OpenRefine
  • Navigating OpenRefine
  • Working with columns
  • Sorting data
  • Facets and Filters
  • Rows and Records
  • Clustering

Hour Two

• Basic OpenRefine functions II
  • Transforming Data
  • Undo and Redo
  • Exporting Data
  • Data Types

Hour Three

• Advanced OpenRefine functions
  • Looking up data from a URL
  • Reconciliation services
  • Extensions
  • Looking up data from other OpenRefine projects
• Applications of OpenRefine in your own work

Acknowledgements and Licensing

This repository contains lesson materials for Library Carpentry week four, held 30 November 2015 at City University London.

Library Carpentry is generously funded by the Software Sustainability Institute. The Software Sustainability Institute cultivates world-class research with software. The Institute is based at the universities of Edinburgh, Manchester, Southampton and Oxford.

This lesson is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License. Exceptions: embeds to and from external sources, and direct quotations from speakers

This lesson is partially derived from material developed by Owen Stephens, Working with Data Using OpenRefine (Creative Commons Attribution 4.0 International License)

The DOAJ article metadata used in this lesson is licenced under Creative Commons Attribution-ShareAlike License (CC BY-SA)