You can use OpenRefine to learn more about; transform into different formats; and enhance or correct your data. Specific functions include, for example, removing duplicate records, standardising date formats, or finding different spellings of the same name and replacing them with a single consistent name.
One wonderful feature of OpenRefine is that it always uses a copy of your data – so no accidentally modifying or writing over your data! It works completely offline, keeping your data private on your own computer until (where relevant) you decide to export and share it!
In this in-person Data Carpentries training session, OpenRefine for Social Science Data, on June 3 from 10.00 – 12.30, you will learn how to import data into OpenRefine, how to use the programme to interrogate, clean and organise it. We will use a sample dataset to show you how you can speed up repetitive tasks by replaying previous actions on multiple datasets. We will also show you how to reverse or undo actions on your data. Finally, we will introduce you to using OpenRefine for importing, filtering, clustering, transforming, and exporting data. These concepts are complex, and you may not have encountered them before, but by the end of the workshop, you will have practical experience, gained from working on a range of examples and exercises.
This workshop will cover
The basics of how to work with OpenRefine, beginning with how to import data into it
An introduction to using the functions of the program to interrogate, clean and organise the data.
Exporting and saving the data once you have cleaned it
How to find out more and build upon your knowledge
Questions can be sent to DANS Training Coordinator and lead instructor for this workshop, Dr Deborah Thorpe. The session will be co-instructed by DANS Research Data Management Specialist Dr Kim Ferguson.
Coffee and tea will be provided, as well as lunch at the end of the workshop.
What you will need to know
The workshop assumes no prior knowledge of the skills or tools.
The language of instruction will be English.
What you will need to bring
Data Carpentry’s teaching is hands-on so you will need to bring your own laptop with OpenRefine pre-installed as per the instructions on the OpenRefine for Social Science Summary and Setup page.
We will be working with sample data. Download the data file linked from the above page to a place that is easily findable on your computer.
Registration
The workshop is full, but pleas fill out the form the join the waiting list.
Your data is only processed in the context of this event. More information can be found in our Privacy Statement.
