Joining questions, answers, and tags
Let's build on the last exercise by adding the tags
table to our previous joins. This will allow us to do a better job of identifying which R topics get the most traction on Stack Overflow. The tables you created in the last exercise have been preloaded for you as answer_counts
and question_answer_counts
.
answer_counts <- answers %>%
count(question_id, sort = TRUE)
question_answer_counts <- questions %>%
left_join(answer_counts, by = c("id" = "question_id")) %>%
replace_na(list(n = 0))
This exercise is part of the course
Joining Data with dplyr
Exercise instructions
- Combine the
question_tags
table withquestion_answer_counts
using aninner_join
. - Now, use another
inner_join
to add thetags
table.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
question_answer_counts %>%
# Join the question_tags tables
___ %>%
# Join the tags table
___