Introduction to Data wrangling with OpenRefine (TU9)

27. Juni 2024, 15:20 Uhr

This online seminar is part of a TU9 Libraries virtual event series.
Organizer: ULB Darmstadt

Zeit: 27. Juni 2024, 15:20 – 16:50 Uhr
Download als iCal:

Event for participants without OpenRefine or other special prior knowledge.

In our workshop "Data wrangling with OpenRefine" you will learn the basics of preparing and transforming tabular data with the open source software OpenRefine. OpenRefine provides functions to identify and correct inconsistencies in large amounts of data under a graphical user interface that outwardly resembles spreadsheet software. For example, it is possible to combine slightly different spellings of a name in different entries (e.g. TU Darmstadt and TU_Darmstadt) by clustering and then label them uniformly. Such data preparation often makes later analysis of the data much easier.

  • How do I create a project and import data?
  • How do I use facet, filter and cluster functions?
  • How do I transform data? (e.g. splitting cell contents)
  • How do I export data?

You will get answers to these questions in the workshop and can apply your new knowledge directly to a sample dataset.

Please set up OpenRefine on your computer before the workshop starts. Instructions can be found at https://hessenbox.tu-darmstadt.de/getlink/fiJ2dhQbWYQ4VtYgi6k6DPUC/Installationshinweise_OpenRefine (current documents available 7 days before the workshop).

Target audience: Scientific staff, students

Lecturers: Jens Freund (ULB Darmstadt)

Date: 27.06.2024 3:20 p.m. - 4:50 p.m.

Registration:  Registration until 24h before the start of the workshop via Cituro

Tool used: Zoom

Link to the original application here.

Visual material: https://hessenbox.tu-darmstadt.de/getlink/fi4veKgtRZnzhuQtV1PEqA1n/OpenRefine.jpg

Zum Seitenanfang