This course will be in two parts: a 1-hour online lecture on what you can do in OpenRefine, including transformations, expressions, and extensions for the software, held on the 8th of November at 10:00 in Zoom. The practical workshop on how to transform your previously cleaned data with OpenRefine software will be a video lecture that you can follow in your own time. Additionally, we will hold 2 Q&A sessions in Zoom, where you can talk about any problems you encountered with the OpenRefine software.

This is a follow-up workshop for “How to make your messy data usable - PART 1”, where we talked about spreadsheets but also introduced the OpenRefine software. This course will explore the depths of OpenRefine software and see what else it can offer. This will include cleaning the data in bigger batches and unifying the data in one sweep. These include transformations and expressions. Additionally, we will introduce the possibility of downloading additional data from other databases and different extensions OpenRefine software has.