EconPapers    
Economics at your fingertips  
 

Tidy Data

Hadley Wickham

Journal of Statistical Software, 2014, vol. 059, issue i10

Abstract: A huge amount of effort is spent cleaning data to get it ready for analysis, but there has been little research on how to make data cleaning as easy and effective as possible. This paper tackles a small, but important, component of data cleaning: data tidying. Tidy datasets are easy to manipulate, model and visualize, and have a specific structure: each variable is a column, each observation is a row, and each type of observational unit is a table. This framework makes it easy to tidy messy datasets because only a small set of tools are needed to deal with a wide range of un-tidy datasets. This structure also makes it easier to develop tidy tools for data analysis, tools that both input and output tidy datasets. The advantages of a consistent data structure and matching tools are demonstrated with a case study free from mundane data manipulation chores.

Date: 2014-09-12
References: View references in EconPapers View complete reference list from CitEc
Citations: View citations in EconPapers (4)

Downloads: (external link)
https://www.jstatsoft.org/index.php/jss/article/view/v059i10/v59i10.pdf
https://www.jstatsoft.org/index.php/jss/article/do ... /reshape2_1.4.tar.gz
https://www.jstatsoft.org/index.php/jss/article/do ... 10/plyr_1.8.1.tar.gz
https://www.jstatsoft.org/index.php/jss/article/do ... ile/v059i10/v59i10.R
https://www.jstatsoft.org/index.php/jss/article/do ... 9i10/v59i10-data.zip

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:jss:jstsof:v:059:i10

DOI: 10.18637/jss.v059.i10

Access Statistics for this article

Journal of Statistical Software is currently edited by Bettina Grün, Edzer Pebesma and Achim Zeileis

More articles in Journal of Statistical Software from Foundation for Open Access Statistics
Bibliographic data for series maintained by Christopher F. Baum ().

 
Page updated 2025-03-19
Handle: RePEc:jss:jstsof:v:059:i10