BaşlayınÜcretsiz Başlayın

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?

Bu egzersiz

Joining Data with dplyr

kursunun bir parçasıdır
Kursu Görüntüle

Egzersiz talimatları

  • Use an inner join to combine the questions and answers tables using the suffixes "_question" and "_answer", respectively.
  • Subtract creation_date_question from creation_date_answer within the as.integer() function to create the gap column.

Uygulamalı interaktif egzersiz

Bu örnek kodu tamamlayarak bu egzersizi bitirin.

questions %>%
  # Inner join questions and answers with proper suffixes
  ___ %>%
  # Subtract creation_date_question from creation_date_answer to create gap
  ___(gap = as.integer(___))
Kodu Düzenle ve Çalıştır