Introduction to Open Refine In-Person
Please note this is an in person workshop.
OpenRefine is a free desktop application that has been described as 'a power tool for working with messy data'. OpenRefine is most useful for cleaning and standardising data in a simple tabular format such as a spreadsheet. Therefore, it can be especially useful to researchers in the humanities, who might not be used to thinking about ‘data’, but are increasingly sharing their research materials and are concerned about others making sense of them. 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.
In this workshop, 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 bibliographical 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.
Related LibGuide: Research Data Service by Aoife Coffey
- Date:
- Thursday, March 6, 2025
- Time:
- 10:00 - 12:30
- Time Zone:
- UK, Ireland, Lisbon Time (change)
- Location:
- Research Skills Teaching Room
- Audience:
- Library Staff Postgraduates UCC Staff
- Categories:
- Training Training
Research Services
Q+2 Boole Library,
University College Cork