Overview

This practice takes users through the prepare menu.  We show how to tidy a dataset, and get it ready for analysis. It uses climatic data from Cameroon. 

Watch this video to see the steps for tidying a messy data set. 

Video script prepared by Rachel Kirk-Gushowaty, and Roger Stern.  Video constructed and voiced by Beryl Waswa.

  •  00:00 Introduction 
  • 04:00 Importing the dataset from the R-Instat Collection 
  • 04:37 Examining the data 
  • 05:27 Import the dataset correctly 
  • 06:00 Examine the data again 
  • 06:47 Data Reshape: Append datasets 
  • 07:40 Transforming a text column 
  • 08:05 Examine the data 
  • 08:37 Renaming a column 
  • 09:10 Data Reshape: Stacking columns 
  • 09:46 Date Column 
  • 10:28 Examine the data 
  • 10:49 Filter Rows 
  • 11:15 Examine the data 
  • 12:43 Sort the data 
  • 13:15 Getting the correct types for the variables 
  • 13:42 Recap of what we have done so far 
  • 14:34 Reflections about the prepare menu 
  • 15:30 Column summaries 
  • 16:34 Add a rain day variable 
  • 18:09 Make monthly and annual summaries 
  • 23:07 Save data 
  • 24:17 Save to excel 
  • 24:57 Extra tidying 
  • 25:15 Rename data frame 
  • 26:05 Improving your data detective and reporting skills 
  • 27:17 Adding a comment 
  •  27:53 Conclusions

Follow along the steps in this written practice document to learn about preparing your data in R-Instat. 

Prepare Menu Practice