The data for this lesson is a part of the Data Carpentry Natural History Collections workshop. It is a teaching version of a download of rodent data from the http://portal.idigbio.org/ for use in Open Refine for the Natural History Science Collections (NHC) Lessons for Data Carpentry. See more information about the NHC datasets for Data Carpentry on figshare.
Dataset description: common rodents in the continental United States from major institutions that publish extended information about their specimens. There are 10,767 rows in the idigbio_rodents.csv file. The data in this lesson
are just a small subset of the available data at http://portal.idigbio.org. Data aggregated for this experience have been intentionally ‘messed up’ for this lesson.
For this lesson you will need OpenRefine (formerly Google Refine) and a
web browser.
Note: this is a Java program that runs on your machine (not in the cloud). It runs inside your browser, but no web connection is needed.
Windows
Check that you have Firefox or Chrome browsers installed and set as your
default browser. OpenRefine runs in your default browser. It will not run correctly in Internet Explorer.
Unzip the downloaded file into a directory by right-clicking and
selecting “Extract…”. Name that directory something like OpenRefine.
Go to your newly created OpenRefine directory.
Launch OpenRefine
Click the google-refine.exe (this will launch a command prompt window, but you can ignore that and wait for the browser to launch)
If you are using a different browser, or OpenRefine does not automatically open for you, point your browser at http://127.0.0.1:3333/ or http://localhost:3333 to launch the program.
Mac
Check that you have Firefox or Chrome browsers installed and set as your
default browser. OpenRefine runs in your default browser. It will not run correctly in Internet Explorer.
Unzip the downloaded file into a directory by double-clicking it. Name
that directory something like OpenRefine.
Go to your newly created OpenRefine directory.
Launch OpenRefine
Drag icon into Applications folder, and Ctrl-click/Open… it.
If you are using a different browser, or OpenRefine does not automatically open for you, point your browser at http://127.0.0.1:3333/ or http://localhost:3333 to launch the program.
Linux
Check that you have Firefox or Chrome browsers installed and set as your
default browser. OpenRefine runs in your default browser. It will not run correctly in Internet Explorer.
Unzip the downloaded file into a directory. Name
that directory something like OpenRefine.
Go to your newly created OpenRefine directory.
Launch OpenRefine
Type ./refine into the terminal within the OpenRefine directory
If you are using a different browser, or OpenRefine does not automatically open for you, point your browser at http://127.0.0.1:3333/ or http://localhost:3333 to launch the program.