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.
This exercise is part of the course
Analyzing Marketing Campaigns with pandas
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Count the subs by subscribing channel and day
retention_total = marketing.____(['date_subscribed',
____])____
# Print results
print(retention_total.head())