Data Cleaning with OpenRefine for Ecologists: Setup

Data

Download this data file to your computer: https://ndownloader.figshare.com/files/7823341

About the data

The data for this lesson is a part of the Data Carpentry Ecology workshop. It is a teaching version of the Portal Database. The data in this lesson is a subset of the teaching version that has been intentionally ‘messed up’ for this lesson.

The data for this lesson and the workshop are in the Portal Project Teaching Database available on FigShare, with a CC-BY license available for reuse.

Software

For this lesson you will need OpenRefine and a web browser.

Note: OpenRefine is a Java program that runs on your machine (not in the cloud). It runs inside your browser, but no web connection is needed.

Download OpenRefine version 3.4.1 from http://openrefine.org/download.html.

OpenRefine requires one of these web browsers:

OpenRefine has some issues with Firefox and Internet Explorer is not supported. Learn how to set your browser as default by clicking on this link for Google Chrome and this link for Firefox.

Windows

Mac

Linux