About this resource

    Type of resources
    Module
    Education level(s)
    Graduate / Professional
    Primary user(s)
    student, teacher
    Subject area(s)
    Information Science, Measurement and Data, Social Science
    Language(s)
    English
    Cluster
    Transparency and Reproducibility in Computation and Analysis, FAIR Data and Materials
    Last updated
    1 January 2020
    Module

    OpenRefine for Social Science Data

    By Erin Becker, François Michonneau, Geoff LaFlair, Karen Word, Lachlan Deer, Peter Smyth, Tracy Teal

    Open this resource

    Level Graduate / Professional · For student, teacher · Language English

    Abstract

    Lesson on OpenRefine for social scientists. A part of the data workflow is preparing the data for analysis. Some of this involves data cleaning, where errors in the data are identifed 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.

    Keywords Analysis · Data · Education · OpenRefine · Open Scholarship Tools and Technologies · Reproducibility · Research Data Management Tools · Researchers