Data Carpentry’s aim is to teach researchers basic concepts, skills, and tools for working with data so that they can get more done in less time, and with less pain. This workshop uses a tabular ecology dataset and teaches data cleaning, management, analysis and visualization.
Data organization in spreadsheets
Data cleaning with OpenRefine
Introduction to R
Data analysis and visualization in R
SQL for data management
The workshop will be taught using R as the base language.
There are no pre-requisites, and the materials assume no prior knowledge about the tools.
The data for this workshop are from the Portal Project Teaching Database available on FigShare, with a CC-BY license available for reuse. The Portal Project Teaching Database is a simplified version of the Portal Project Database designed for teaching. It is a tabular dataset of observations of small mammals in a desert ecosystem in Arizona, USA, collected over more than 40 years. It provides a real world example of life-history, population, and ecological data, with sufficient complexity to teach many aspects of data analysis and management, but with many complexities removed to allow students to focus on the core ideas and skills being taught.
This workshop is open to the community and is free of charge.