Workshop duration: Full day
This session is based on Data Carpentry Ecology workshop which can be found here
1. Introduction to tabular data format.
2. Cleaning Data with OpenRefine. 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.
3. Data Carpentry: R for data analysis and visualization of Ecological Data. This is an introduction to R designed for participants with no programming experience. They lesson will start with some basic information about R syntax, the RStudio interface, and move through how to import CSV files, the structure of data frames, how to deal with factors, how to add/remove rows and columns, how to calculate summary statistics from a data frame, and a brief introduction to plotting.
Requirements:
Follow installation instructions on Data Carpentry website:
Open Refine: http://www.datacarpentry.org/OpenRefine-ecology-lesson/setup/
RStudion and R: http://www.datacarpentry.org/OpenRefine-ecology-lesson/setup/
Organizer/trainer: Mateusz Kuzak, Dutch Techcentre for Life Sciences (DTL)