Data wrangling: relational data and factors

Introduction to relational data

• Multiple tables of data that when combined together answer research questions
• Relations define the important element, not just the individual tables
• Relations are defined between a pair of tables
• Relational verbs
  • Mutating joins
  • Filtering joins

Superheroes

Publishers

inner_join(x = superheroes, y = publishers)

left_join(x = superheroes, y = publishers)

right_join(x = superheroes, y = publishers)

full_join(x = superheroes, y = publishers)

semi_join(x = superheroes, y = publishers)

anti_join(x = superheroes, y = publishers)