Data Cleaning with OpenRefine for Ecologists
Abstract
A part of the data workflow is preparing the data for analysis. Some of this involves data cleaning, where errors in the data are identified and corrected or formatting made consistent. This step must be taken with the same care and attention to reproducibility as the analysis. OpenRefine (formerly Google Refine) is a powerful free and open source tool for working with messy data: cleaning it and transforming it from one format into another. This lesson will teach you to use OpenRefine to effectively clean and format data and automatically track any changes that you make. Many people comment that this tool saves them literally months of work trying to make these edits by hand.
Link to resource: https://datacarpentry.org/OpenRefine-ecology-lesson/
Type of resources: Module
Education level(s): Graduate / Professional
Primary user(s): student, teacher
Subject area(s): Computer Science, Information Science, Measurement and Data
Language(s): English
Help us improve the FORRT website
We would be grateful if you could complete this survey.
Your feedback will directly inform improvements to navigation, accessibility, and content structure.
Note:All answers are anonymous and will help us make the website better for everyone!