An important part of the data workflow is preparing data for analysis. This often involves data cleaning, where errors in the data are identified and corrected or formatting is made consistent.
This workshop introduces OpenRefine, a powerful free open-source tool for cleaning and transforming messy data. The focus is on practical application; participants bring their own laptops for hands-on exercises. The workshop uses material provided by the Data Carpentries (https://datacarpentry.github.io/openrefine-socialsci/index.html). You will learn how to:
- create, export and import a project in OpenRefine
- view and work on subsets of rows using facets and text filters
- reduce variations in data through clustering, bulk editing and transformations
- undo and redo actions and export the history of actions
- save cleaned data in a widely supported file formats
This is a hands-on workshop. Please bring your own laptop. Also, please make sure to install open refine and download the datafile before the workshop. You will find the links and instructions to do so here: https://datacarpentry.github.io/openrefine-socialsci/index.html
- Time: 8. Oktober 2026, 10:00-12:45 Uhr
- Location: Open Science Lab der SLUB, Raum OSL3, Zellescher Weg 21-25, 01217 Dresden
- Languag: English
- Maximum number of participants: 16
- Registration: https://terminplaner.dfn.de/public/bookings/c3f6f231-2c14-4715-9dc1-c645cb8cd0aa