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. 

You might be interested in

graphic of a black and white Christmas tree background with colourful baubles and snowflakes. The text "Dorothy Berry, CDCS Annual Lecture 2025" is overlayed."

CDCS Annual Lecture 2025

Graphic for a workshop titled ‘An Introduction to Deep Learning for Image Classification.’ The background is a sepia photograph of people working at desks in a large hall with overhead lamps. 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.

Silent Disco: Computer Vision for the Humanities: An Introduction to Deep Learning for Image Classification

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

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 ‘Creating Choropleth Maps with Python and Folium.’ The background is a sepia photograph of people working at desks in a large hall with overhead lamps. 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.

Silent Disco: Creating Choropleth Maps with Python and Folium

Graphic for a workshop titled ‘Introduction to Geographical Data with QGIS.’ The background shows an old map of the world with detailed 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.

Intro to Geographical Data with QGIS

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 ‘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 ‘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 ‘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

an old map of Acotland with the text "Jennifer Smith & Brian Aitken, Project deep Dive"

Who Speaks Scots Where: What Crowdsourcing Reveals

black and white photograph of a person drinking tea out of a flaks on top of a hill.

CDCS December Fika