CommencerCommencer gratuitement

Aggregating by date

The marketing team wants to know whether there is any difference in the conversion rate based on when in the month, your users saw an ad. In this exercise, you will practice .groupby() again, this time looking at how metrics have evolved.

Cet exercice fait partie du cours

Analyzing Marketing Campaigns with pandas

Afficher le cours

Instructions

  • Group the marketing DataFrame by date_served and count the number of unique users per day.
  • Isolate converted users in marketing while grouping by date_served and counting the number of unique converted users per day.

Exercice interactif pratique

Essayez cet exercice en complétant cet exemple de code.

# Group by date_served and count unique users
total = ____

# Group by date_served and count unique converted users
subscribers = ____

# Calculate the conversion rate per day
daily_conversion_rate = subscribers/total
print(daily_conversion_rate)
Modifier et exécuter le code