Free

Cleaning & Exploring your data with Open Refine at USYD Camperdown

Event Information

Share this event

Date and Time

Location

Location

USYD Camperdown

Jacaranda Training Room, Level 3, G12 Services Building

The University of Sydney

Camperdown, NSW 2006

Australia

Event description

Description

  • Cost: Free to Researchers and PhD students at the University of Sydney.

  • The venue is not fitted with desktop PCs. You must bring your own laptop to this course.

  • Proudly presented in association with Sydney Informatics.


Why do this course?

Do you have messy data from multiple inconsistent sources, or open-responses to questionnaires? Do you want to improve the quality of your data by refining it and using the power of the internet?

Open Refine is the perfect partner to Excel. It is a powerful, free tool for exploring, normalising and cleaning datasets, and extending data by accessing the internet through APIs. In this course we'll work through the various features of Refine, including importing data, faceting, clustering, and calling remote APIs, by working on a fictional but plausible humanities research project.

You’ll learn how to:

  • Download, install and run Open Refine

  • Import data from csv, text or online sources and create projects

  • Navigate data using the Open Refine interface

  • Explore data by using facets

  • Clean data using clustering

  • Parse data using GREL syntax

  • Extend data using Application Programming Interfaces (APIs)

  • Export project for use in other applications

The Intersect approach to training

At Intersect, we work closely with our member universities to develop and deliver training that targets the day-to-day software and technology problems that researchers face. We deliver hands-on courses in a relaxed setting with knowledgeable, helpful trainers who are themselves researchers and who know how researchers work.

Download the course outline.

For more information visit Learn.intersect.org.au

Date and Time

Location

USYD Camperdown

Jacaranda Training Room, Level 3, G12 Services Building

The University of Sydney

Camperdown, NSW 2006

Australia

Save This Event

Event Saved