Resources for data prep


Here are some additional resources to help you prepare your data:

Tidy Data, by Hadley Wickham (a well-known data scientist), is a classic paper that defines what makes data clean (or “tidy”) (Wickham 2014)

The University of New Hampshire Library has an excellent research guide for using Excel, including data cleaning, data analysis, data visualization, and spreadsheet best practices.

Preparing Data in Excel, from the University of Nebraska Medical Center College of Public Health, has an excellent set of guidelines for working with Excel

Introduction to Excel is an excellent online module from the University of South Australia Research Methodologies and Statistics department.

Analysis Ready Datasets is an excellent resource from Harvard Medical School