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.
Deze oefening maakt deel uit van de cursus
Joining Data with dplyr
Oefeninstructies
- Use two inner joins to combine the
question_tagsandtagstables with thequestionstable. - Now, use two inner joins to combine the
question_tagsandtagstables with theanswerstable.
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
# 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 %>%
___ %>%
___