Cleaning Data with OpenRefine

  • Date : 12th December 2018
  • Time : 10 am - 3:30 pm
  • Location : T1, Sir Louis Matheson Library, Clayton, VIC
  • Instructors : Andrew Perry, Beth Pearson
  • Helpers : Cassandra Freeman, Linda Kalejs, Anna Stokes, Penelope Presta, Melissa Santoso, Amy Han

Got messy data ? Manual data entry with typos ? A spreadsheet that makes Excel grind to a halt ? OpenRefine might just be the tool you need.

This beginner-level hands-on workshop is designed to introduce the basics of working with OpenRefine to clean up, transform and enhance ‘messy’ datasets. At the conclusion of the workshop you will understand what the OpenRefine software does and how to use it to clean and transform data for your own projects.

General Information

This is a hands-on workshop that will be taught in the style of Software Carpentry workshops, following the Library Carpentry OpenRefine material. There will be lots of helpers in the workshop to assist in keeping things on track so that no learner gets lost or left behind !

Who: The course is aimed at beginners - no familiarity with data cleaning techniques or OpenRefine is required. You don’t need to have any previous knowledge of the tools that will be presented at the workshop.

Setup Requirements: Participants must bring their own laptop (Windows, Mac, Linux) with charger and be able to connect to eduroam. Please install OpenRefine on your computer prior to the workshop - if you have trouble arrive a little early and we can help you get it installed.

Schedule

Time Programme
10:00 Session 1
11:00 Break
12:15 Lunch
01:00 Session 2
02:15 Break
03:15 Wrap up, post workshop survey

Shared Notepad

Syllabus

We will follow the Library Carpentry OpenRefine lessons.

Post-workshop survey

We appreciate your feedback (both positive and negative !) - please fill this out in the last 5 mins of the workshop: https://goo.gl/forms/2xZLrj4umOlpqmEJ3

Keep In Touch