Joining question and answer counts

We can also determine how many questions actually yield answers. If we count the number of answers for each question, we can then join the answers counts with the questions table.

Deze oefening maakt deel uit van de cursus

Joining Data with dplyr

Cursus bekijken

Oefeninstructies

Count and sort the question_id column in the answers table to create the answer_counts table.
Join the questions table with the answer_counts table and include all observations from the questions table.
Replace the NA values in the n column with 0s.

Praktische interactieve oefening

Probeer deze oefening eens door deze voorbeeldcode in te vullen.

# Count and sort the question id column in the answers table
answer_counts <- answers %>%
  ___

# Combine the answer_counts and questions tables
questions %>%
  ___ %>%
  # Replace the NAs in the n column
  ___

Code bewerken en uitvoeren