The goal of tidyr is to help you create tidy data. Tidy data is data where:
- Each variable is in a column.
- Each observation is a row.
- Each value is a cell.
Tidy data describes a standard way of storing data that is used wherever possible throughout the tidyverse. If you ensure that your data is tidy, you'll spend less timing fighting with the tools and more time working on your analysis.
# The easiest way to get tidyr is to install the whole tidyverse: install.packages("tidyverse") # Alternatively, install just tidyr: install.packages("tidyr") # Or the the development version from GitHub: # install.packages("devtools") devtools::install_github("tidyverse/tidyr")
There are two fundamental verbs of data tidying:
gather()takes multiple columns, and gathers them into key-value pairs: it makes "wide" data longer.
spread(). takes two columns (key & value) and spreads in to multiple columns, it makes "long" data wider.
tidyr also provides
extract() functions which makes it easier to pull apart a column that represents multiple variables. The complement to
To get started, read the tidy data vignette (
vignette("tidy-data")) and check out the demos,
demo(package = "tidyr")).
tidyr replaces reshape2 (2010-2014) and reshape (2005-2010). Somewhat counterintuitively each iteration of the package has done less. tidyr is designed specifically for tidying data, not general reshaping (reshape2), or the general aggregation (reshape).
If you'd like to read more about data reshaping from a CS perspective, I'd recommend the following three papers:
An interactive framework for data cleaning (Potter's wheel)
To guide your reading, here's translation between the terminology used in different places: