ELIXIR node event How to make your messy data usable? / OpenRefine

View event

Date: 30 November 2023 @ 13:00 - 17:00

Timezone: Tallinn

Duration: 4h

Loading map...

The practical workshop on cleaning your messy data with OpenRefine software.

First, we will cover spreadsheet best practices. Then, we will put that knowledge into practice with OpenRefine. This course will explore the depths of OpenRefine software and see what it can offer. This will include cleaning the data in bigger batches and unifying the data in one sweep (transforms and expressions). Additionally, we will introduce the possibility of downloading additional data from other databases and different extensions OpenRefine software has.

Keywords: Workshop, OpenRefine, data cleaning

Venue: Delta building, Narva mnt 18 room 1008, Tartu

City: Tartu

Country: Estonia

Postcode: 51009

Learning objectives:

  • Describe spreadsheet best practices
  • Compare Excel and OpenRefine
  • Apply transforms (cell editing, column editing, transposing) in OpenRefine
  • Write simple expressions in OpenRefine
  • Match your dataset with that of an external source

Organizer: ELIXIR Estonia

Host institutions: University of Tartu, Institute of Computer Science

Eligibility:

  • First come first served

Target audience: Students, Researchers

Capacity: 25

Tech requirements:

Please bring your own laptop!

Cost basis: Free to all

External resources:
How to make your messy data usable? / OpenRefine
Activity log