CommencerCommencer gratuitement

Joining questions and answers with tags

To learn more about the questions and answers tables, you'll want to use the question_tags table to understand the tags associated with each question that was asked, and each answer that was provided. You'll be able to combine these tables using two inner joins on both the questions table and the answers table.

Cet exercice fait partie du cours

Joining Data with dplyr

Afficher le cours

Instructions

  • Use two inner joins to combine the question_tags and tags tables with the questions table.
  • Now, use two inner joins to combine the question_tags and tags tables with the answers table.

Exercice interactif pratique

Essayez cet exercice en complétant cet exemple de code.

# Inner join the question_tags and tags tables with the questions table
questions %>%
  inner_join(question_tags, by = ___) %>%
  inner_join(tags, by = ___)

# Inner join the question_tags and tags tables with the answers table
answers %>%
  ___ %>%
  ___
Modifier et exécuter le code