Find us on GitHub

Workshop: Cleaning Data with OpenRefine

SE Data Librarian Symposium: Georgia Tech Library

October 9, 2018

8:45 am - 10:15 am

Instructor: Sherry Lake

Helpers: Ximin Mi, Jen Doty

General Information

This hands-on workshop will teach the basics of OpenRefine. It is based on the Library Carpentry Lesson: https://librarycarpentry.github.io/lc-open-refine/. For this workshop, the original Library Carpentry Lesson was shortened to be taught in 75 Minutes.

Participants please bring a laptop, if you are able and plan to participate actively.

By the end of the workshop learners should be able to more effectively manage data and be able to apply the tools and approaches directly to their ongoing projects.

Where: Clough Undergraduate Learning Commons - if necessary: Homer Rice Center, Ga Tech Library.

Requirements: Participants should bring a laptop with a Mac, Linux, or Windows operating sytem (not a tablet, Chromebook, etc.) that they have administrative privileges on. They should have Openrefine installed (see setup below). Participants are also required to abide by the SE Data Librarians Code of Conduct.

Contact: Please mail shLake@virginia.edu for more information.


Etherpad: https://public.etherpad-mozilla.org/p/SEDL-Symposium-2018-10-09.
We will use this Etherpad for chatting, taking notes, and sharing URLs.

OpenRefine Lesson: https://shlake.github.io/lc-open-refine-short/

Lesson Files: https://shlake.github.io/lc-open-refine-short/setup.html
Located on the Lesson setup page, bottom section "Downloading the Data".


Based on the Lessons from: Library Carpentry. OpenRefine for Librarians. June 2016. https://librarycarpentry.github.io/lc-open-refine/

OpenRefine


Setup

To participate in this workshop, you will need working copies of the described software. Please make sure to install everything (or at least to download the installers) before the start of your workshop. Participants should bring and use their own laptops to insure the proper setup of tools for an efficient workflow once you leave the workshop.

Please follow these Installation Instructions.



SE Data Librarian Symposium Program: https://se-datalibrarian.github.io/program/
The lessons in this workshop are derived from work that is Copyright © Data Carpentry and Library Carpentry.
Licensed under a Creative Commons Attribution 4.0 International License