Skip to main content

Practice Session: Joins

Practice exercises joining bird survey data tables together and identifying primary and foreign keys.
tidy-data
data-wrangling
activity
intermediate
practice
LearningLearning Objectives

After completing this session, you will be able to:

  • Practice joining tables together
  • Practice identifying primary and foreign keys
  • Practice using common cleaning and wrangling functions

1 Overview

In this practice session you will work with bird survey data from the central Arizona-Phoenix metropolitan area. In Exercise 1 you will practice joining tables with left_join(), full_join(), and inner_join(). In Exercise 2 you will practice wrangling and joining the data, including cleaning up inconsistent values, and then save your work with the Git and GitHub workflow.