How to clean and format data using R, OpenRefine, Excel?

Susanne Grossman-Clarke (Environmental Data Initiative, University of Wisconsin-Madison) provided guidance on choosing tools for data cleaning, on February 13, 2018.

Click here for presentation slides.

A recording of the presentation is available on YouTube.

Instructions on data cleaning exercise can be found here.

This is the second tutorial in EDI’s series on the “5 phases of data publishing”, as detailed on EDI’s website under “Resources” here. We will give an overview of some of the tools available for data formatting and data quality control, discuss the tool’s suitability and limitations and provide an example data set and instructions for working with those tools.