Library Carpentry: OpenRefine

This workshop introduces attendees to working with data in OpenRefine, and how to use it to work with data files.  

Topics covered include:

  • Introduction to OpenRefine   

  • Importing data into OpenRefine  

  • Layout of OpenRefine   

  • Faceting and filtering  

  • Clustering  

  • Working with columns and sorting  

  • Transformations  

Requirements: Please bring a laptop with a Mac, Linux, or Windows operating system (not a tablet, Chromebook, etc.) that you have administrative privileges on. Please make sure that your web browser is up to date. 

Please ensure that you have a specific software installed for this workshop – click here for setup instructions. 

- - - 

This workshop is part of a programme of Library Carpentry workshops. 

Library Carpentry will introduce you to the fundamentals of computing and provide you with a platform for further self-directed learning. You can choose to attend the full programme of workshops, or to participate only in workshops that are useful to you (workshops will be advertised individually). 

The programme focuses on building software and data skills within library and information-related communities, and aims to help you to: 

  • automate repetitive, boring, error-prone tasks 

  • create, maintain and analyse sustainable and reusable data 

  • work effectively with IT and systems colleagues 

  • better understand the use of software in research and much more 

Previous knowledge of the tools to be presented at sessions is not required. 

Full programme outline: 

  • Introduction to Working with Data (Regular Expressions) 

  • Tidy Data for Librarians 

  • OpenRefine 

  • The UNIX Shell

  • Introduction to Python for Libraries

  • Introduction to R for Libraries 

 Click here for more information about the Library Carpentry programme