Silent Disco: Cleaning Data with OpenRefine
Online
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:
-
Remove duplicate records
-
Separate multiple values contained in the same field
-
Analyse the distribution of values throughout a data set
-
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.
If you're interested in other training on Data Wrangling, have a look at the following:
- Writing Efficient Code in R: Logical Statements and Loops (07/12)
- Intro to Databases with SQLite (13/12)