Get startedGet started for free

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

View Course

Exercise instructions

  • Combine the question_tags table with question_answer_counts using an inner_join.
  • Now, use another inner_join to add the tags 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
  ___
Edit and Run Code