Rentia Website: OpenRefine Workshop Website: Please note that space is limited.Īlternatively contact Rentia at: fee: Please take note: In case of “no-show” or cancellation of less than 7 days before the meeting, you will have to pay the full non-member price. TO RSVP: Please complete the REGISTRATION FORM by Friday, 26 August 2022. For more information please visit the OpenRefine Workshop link below. Requirements: Participants must bring a laptop with a Mac, Linux, or Windows operating system (not a tablet, Chromebook, etc.) that they have administrative privileges on.

You don’t need to have any previous knowledge of the tools that will be presented at the workshop. Who: The course is for people working in library- and information-related roles and anyone cleaning data using spreadsheets.

Help you split data up into more granular parts, for example splitting up cells with multiple authors into separate cells and more….

Resolve inconsistencies in a data set, for example standardizing date formatting.

OpenRefine can be used to standardize and clean data across your file. OpenRefine is most useful where you have data in a simple tabular format such as a spreadsheet, a comma separated values file (csv) or a tab delimited file (tsv) but with internal inconsistencies either in data formats, or where data appears, or in terminology used. It is described as “a power tool for working with messy data” ( David Huynh). Venue: 137 Murray St, Brooklyn, Pretoria, 0181 South AfricaĬost: R200 for paid-up members R350 for non-membersġ4:00-15:00 Exporting and looking up dataĪbout the workshop: OpenRefine is a desktop application that uses your web browser as a graphical interface.

You are cordially invited to the Southern African Online User Group’s (SAOUG) OpenRefine Workshop

Illuminations inc stickers