Finding gaps between questions and answers
Now we'll join together questions
with answers
so we can measure the time between questions and answers.
Make sure to explore the tables and columns in the console before starting the exercise. Can you tell how are questions identified in the questions
table? How can you identify which answer corresponds to which question using the answers
table?
This exercise is part of the course
Joining Data with dplyr
Exercise instructions
- Use an inner join to combine the
questions
andanswers
tables using the suffixes"_question"
and"_answer"
, respectively. - Subtract
creation_date_question
fromcreation_date_answer
within theas.integer()
function to create thegap
column.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
questions %>%
# Inner join questions and answers with proper suffixes
___ %>%
# Subtract creation_date_question from creation_date_answer to create gap
___(gap = as.integer(___))