Loading and Cleaning Small Datasets in R

TABLE OF CONTENTS:

08–A: Learning Outcomes

In this module, we will be learning how to:

• 1. Download a dataset from Qualtrics and open our dataset in Excel.

  2. Delete columns that we do not need to make our dataset more management to work with.

  3. Rename column headings to make sense to us.

  4. Spot missing data in a dataset and think about how to handle that missing data.

  5. Compile variables into a single outcome variable for running analyses.

If you want to view the Qualtrics survey that we collected the example data from, you may view the survey here:

https://umdsurvey.umd.edu/jfe/form/SV_a5XHsNPL2U7oZ1A

Please download the example data here:

https://drive.google.com/file/d/13v4FsUCWkqQmrepiJEpzgvuvgcOC4S_x/view?usp=sharing

Video (0:36)

08–B: Downloading a Dataset in Qualtrics and Opening in Excel

UMD students should navigate to: umdsurvey.umd.edu

Non-UMD affiliates may be able to access Qualtrics through their own institution or may export their excel dataset from any other data collecting source.

Video (3:32)

08–C: Deleting Unnecessary Columns

Video (1:47)

08–D: Renaming Columns

Video (3:11)

08–E: Handling Missing Data

Video (2:21)

08–F: Creating A Single Outcome Variable

Video (4:32)

Test Your Knowledge

LINK TO GOOGLE QUIZ: https://drive.google.com/drive/folders/1l4ukBnLseOen4CRzir4OzwkReUUF21gr?usp=sharing