How to Refine your Spreadsheets - An Introduction to OpenRefine

by Christian Knüpfer (Kompetenzzentrum Digitale Forschung, FSU Jena), Roman Gerlach

Tuesday 26 Oct 2021, 10:00 → 12:00 Europe/Berlin

Linuxpool 2 (room 3410) (Kompetenz- und Servicezentrum der Fakultät für Mathematik und Informatik)

Are you working with data organised in spreadsheets? Do you usually spend more time on data cleansing and data quality improvements than on data analysis? And do you want a powerful tool, that is free of charge and runs on every computer, including your local PC? If your answer to these questions is YES, then you should consider registering for this hands-on workshop.

OpenRefine is a powerful, free and open source tool to clean, correct, codify, and extend your tabular data. Using OpenRefine will save you hours of manual editing and correcting of data.

In this hands-on workshop we will first introduce what OpenRefine is and what it can do. You will learn how to import your data into OpenRefine, how to find and correct errors in your data, how to transform data, and how to save and export your cleaned data from OpenRefine. Finally, we will point you to additional resources to continue learning after the workshop.

Participating in this workshop does not require any prior installation nor knowledge of OpenRefine.