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
Instructions
- Use two inner joins to combine the
question_tags
andtags
tables with thequestions
table. - Now, use two inner joins to combine the
question_tags
andtags
tables with theanswers
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 %>%
___ %>%
___