Exercise

Calculate time offset in days - part 2

Great work! Now, we have six different data sets with year, month and day values for Invoice and Cohort dates - invoice_year, cohort_year, invoice_month, cohort_month, invoice_day, and cohort_day.

In this exercise you will calculate the difference between the Invoice and Cohort dates in years, months and days separately and then calculate the total days difference between the two. This will be your days offset which we will use in the next exercise to visualize the customer count. The online data has been loaded, you can print its header to the console by calling online.head().

Instructions

100 XP
  • Find the difference in years between the moment of the invoice and the moment the cohort was created.
  • Find the difference in months between the moment of the invoice and the moment the cohort was created.
  • Find the difference in days between the moment of the invoice and the moment the cohort was created.
  • Calculate the number of days for the CohortIndex (assume 365 days in a year, and 30 days in a month).