Data Cleaning with OpenRefine for Social Science Data

• Do, 08.10.2026 10:00 Uhr - 12:45 Uhr
• Interim Bibliothek Bergstraße/Open Science Lab, Zellescher Weg 21–25, 01217 Dresden
• Come2Data

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

Come2Data

Come2Data ist ein sächsisches Zentrum, das Forschenden, Verwaltungsmitarbeitenden und der interessierten Öffentlichkeit praxisorientierte Datenkompetenzen vermittelt. Es bündelt bestehende Schulungen und Unterstützungsangebote zu Themen wie Forschungsdatenmanagement, Hochleistungsrechnen und Datenanalyseverfahren, um einen offenen Lern- und Vernetzungsort zu schaffen.