Library Carpentry Workshop: OpenRefine

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

Topics covered:

  • 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.

The Centre for Data Culture and Society is offering a limited number of places for this programme, run in partnership with the Centre for Research Collections and the National Library of Scotland.

This programme focuses on building software and data skills within library and information-related communities. Previous knowledge of the tools to be presented 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

To book a place on another of the above workshops, see our other events advertised.

 Click here for more information about the Library Carpentry programme.

 

Digital Scholarship Centre

Digital Scholarship Centre, 6th floor

Main Library 

University of Edinburgh 

Edinburgh EH8 9LJ

You might be interested in

Graphic for a workshop titled ‘Using Prompting Efficiently for Research.’ The background shows an aged, torn book page with visible text. A large green ampersand featuring an illustration of Ada Lovelace is placed on the left. The logo of the Centre for Data, Culture & Society (DCS) appears in the top right corner.

Using Prompting Efficiently for Research

Graphic for a workshop titled ‘What LLMs can and cannot do’ The background is a collage of historical printed text with an overlaid image of a wolf. A large green ampersand featuring an illustration of Ada Lovelace is placed on the left. The logo of the Centre for Data, Culture & Society (DCS) appears in the top right corner.

Digital Method of the Month: What LLMs Can and Cannot Do

Graphic for a workshop titled ‘Data Wrangling and Manipulation with R.’ The background is a black-and-white photograph of a large classroom where people are sculpting and drawing statues. A large green ampersand featuring an illustration of Ada Lovelace is placed on the left. The logo of the Centre for Data, Culture & Society (DCS) appears in the top right corner.

A Pipeline for Data Wrangling and Manipulation with R

Graphic for a workshop titled ‘Geospatial Data and GIS’ The background is a collage of historical printed text with an overlaid image of a wolf. A large green ampersand featuring an illustration of Ada Lovelace is placed on the left. The logo of the Centre for Data, Culture & Society (DCS) appears in the top right corner.

Digital Method of the Month: Geospatial Data and GIS

Graphic for a workshop titled ‘An Introduction to Epistemic Network Analysis.’ The background shows an old manuscript with geometric diagrams and curved illustrations. A large teal ampersand featuring an illustration of Ada Lovelace is placed on the left. The logo of the Centre for Data, Culture & Society (DCS) appears in the top right corner.

From Qualitative Data to Quantified Connections – An Introduction to Epistemic Network Analysis

Graphic for a workshop titled ‘Using API for Research.’ The background is a black-and-white photograph of people working with printing equipment and patterned sheets. A large magenta ampersand featuring an illustration of Ada Lovelace is placed on the left. The logo of the Centre for Data, Culture & Society (DCS) appears in the top right corner.

Using API for Research

Graphic for a workshop titled ‘Working Collaboratively Through Version Control.’ The background is a black-and-white photograph of people weaving on large looms. A large magenta ampersand featuring an illustration of Ada Lovelace is placed on the left. The logo of the Centre for Data, Culture & Society (DCS) appears in the top right corner.

Working Collaboratively through Version Control

Graphic for a workshop titled ‘Data Viscualisation’ The background is a collage of historical printed text with an overlaid image of a wolf. A large green ampersand featuring an illustration of Ada Lovelace is placed on the left. The logo of the Centre for Data, Culture & Society (DCS) appears in the top right corner

Digital Method of the Month: Data Visualisation

Graphic for a workshop titled ‘Text Classification in Practice: From Topic Models to Transformers.’ The background shows handwritten historical letters. A large green ampersand featuring an illustration of Ada Lovelace is placed on the left. The logo of the Centre for Data, Culture & Society (DCS) appears in the top right corner.

Text Classification in Practice: From Topic Models to Transformers

Graphic for a workshop titled ‘Foundations of Webscraping.’ The background is a black-and-white photograph of students working together in a design studio with maps and models. A large teal ampersand featuring an illustration of Ada Lovelace is placed on the left. The logo of the Centre for Data, Culture & Society (DCS) appears in the top right corner.

Collecting Data from the Web: Foundation of Webscraping

Graphic for a workshop titled ‘Getting Started with Inferential Statistics.’ The background is a black-and-white photograph of people studying in a library with partitioned desks. A large teal ampersand featuring an illustration of Ada Lovelace is placed on the left. The logo of the Centre for Data, Culture & Society (DCS) appears in the top right corner.

Getting Started with Inferential Statistics

Graphic for an event titled ‘BYOD Festival.’ The background is a black-and-white photograph of people sitting around a table, drinking tea and playing cards. A large magenta ampersand featuring an illustration of Ada Lovelace is placed on the left. The logo of the Centre for Data, Culture & Society (DCS) appears in the top right corner.

Bring Your Own Data (BYOD) Fest