Silent Disco: Cleaning Data with OpenRefine

Silent Disco mashup

 

Silent Disco: Cleaning Data with Openrefine 

 

Our 'Silent Disco' workshops are based on tutorials from the Programming Historian website. This training event will follow content from the tutorial, Cleaning Data with OpenRefine.  

Open Refine is a powerful tool for working with messy data: cleaning it; transforming it from one format into another 

In this lesson, you will learn the principles and practice of data cleaning, as well as how OpenRefine can be used to perform four essential tasks that will help you to clean your data: 

  1. Remove duplicate records 

  1. Separate multiple values contained in the same field 

  1. Analyse the distribution of values throughout a data set 

  1. Group together different representations of the same reality 

 

 This is an asynchronous event: when taking part, you will work through the tutorial at your own pace with an instructor available online to help you with any issues. 

Participants will meet for a brief introduction to OpenRefine, and will then work on the tutorial at their own pace. The facilitator will be available via Teams Chat to reply to any questions that arise during the workshop. 

This is a beginner level workshop. No previous knowledge on the topic is required/expected and the trainer will cover the basics of the method. 

To attend this course, you will have to join the associated Microsoft Teams group. The link to join the group will be sent to the attendees prior to the course start date, so please make sure to do so in advance. 

After taking part in this event, you may decide that you need some further help in applying what you have learnt to your research. If so, you can book a Data Surgery meeting with one of our training fellows. 

More details about Data Surgeries. 

If you’re new to this training event format, or to CDCS training events in general, read more on what to expect from CDCS training. Here you will also find details of our cancellation and no-show policy, which applies to this event. 

 

Return to the Training Homepage to see other available events. 

You might be interested in

Digital Method of the Month. Machine learning

Digital Method of the Month: Machine Learning

Interactive Analysis Reports with R Markdown

Interactive Analysis Reports with R Markdown

A Gentle Introduction to Causal Inference

A Gentle Introduction to Causal Inference

CDCS Fika April 2025

Fika

Advanced Uses of LLM

Advanced Uses of LLMs

Introduction to Network Analysis with Gephi

Introduction to Network Analysis with Gephi

text analysis

Digital Method of the Month: Text Analysis

Sentiment Analysis

Silent Disco: Introduction to Sentiment Analysis

Introduction to Databases and SQL

Silent Disco: Introduction to Databases and SQL

Analysing Spatial Dynamics with GIS and R

Analysing Spatial Dynamics with GIS and R