Exercise

Grouping and counting by multiple columns

Stakeholders have begun competing to see whose channel had the best retention rate from the campaign. You must first determine how many subscribers came from the campaign and how many of those subscribers have stayed on the service.

It's important to identify how each marketing channel is performing because this will affect company strategy going forward. If one channel is outperforming others, it might signal the channel merits further investment.

You will build on what we have learned about .groupby() in previous exercises, this time grouping by multiple columns.

Instructions 1/2

undefined XP
  • 1
    • Use .groupby() to calculate subscribers by subscribing_channel and date_subscribed.
  • 2
    • Use .groupby() to calculate retained subscribers by subscribing_channel and date_subscribed.