| layout | title | permalink |
|---|---|---|
page |
Setup |
/setup/ |
You need to download and install OpenRefine and download a data file to follow this lesson.
You can download OpenRefine from http://openrefine.org/download.html. There are two versions you can use for this lesson:
- Google Refine 2.5
- OpenRefine 2.6 RC2
Generally OpenRefine 2.6 is recommended.
There are versions for Windows, Mac OS X and Linux.
When you download OpenRefine for Windows or Linux from the address above, you are downloading a zip file. To install OpenRefine you simply unzip the downloaded file wherever you want to install the program. This can be to a personal directory or to an applications or software directory - OpenRefine should run wherever you put the unzipped folder. The location has to be a "local" drive as problems have been reported trying to run OpenRefine from a Network drive.
If you are downloading OpenRefine for Mac, you a re downloading a ‘dmg’ (disk image) file which you can open, and then drag the OpenRefine application to an appropriate folder on you computer.
OpenRefine is a java application, and you need to have a ‘java runtime environment’ (JRE) installed on your computer to run OpenRefine. If you don’t already have one installed then you can download and install from http://java.com by going to the site and clicking ‘Free Java Download’.
To run Refine:
- On Windows: Navigate to the folder where you’ve installed OpenRefine and either double-click ‘google-refine.exe’ (for Google Refine 2.5), ’openrefine.exe’ (for OpenRefine 2.6) or ‘refine.bat’ (for either)
- On Linux: Navigate to the folder where you’ve installed OpenRefine in a terminal window and type ‘./refine’
- On Mac: Navigate to where you installed OpenRefine and click the OpenRefine icon
The interface to OpenRefine is accessed via a web browser. When you run Refine normally this should open a window in your default web browser pointing at the address http://127.0.0.1:3333. If this doesn’t happen automatically you can open a web browser and type in this address.
If you encounter problems installing or running OpenRefine, a good source of support is the OpenRefine mailing list and forum
If you are installing OpenRefine on Windows, you may want to check the thread on Installing OpenRefine on Windows 7
There are also general and specialist tutorials about using OpenRefine available on the web, including:
- Getting started with OpenRefine by Thomas Padilla
- Cleaning Data with OpenRefine by Seth van Hooland, Ruben Verborgh and Max De Wilde
- Blog posts on using OpenRefine from Owen Stephens
- Identifying potential headings for Authority work using III Sierra, MS Excel and OpenRefine
- Free your metadata website
- Data Munging Tools in Preparation for RDF: Catmandu and LODRefine by Christina Harlow
- Walkthrough of Geonames Recon Service by Christina Harlow
- OpenRefine News (monthly round up of new blog posts, tutorials and other information)
You need to download petitions-archive-list.xlsx, which is an Excel file. Make a note of the location you save the file.
[template]: {{ site.workshop_repo }}