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.
Este exercício faz parte do curso
Analyzing Marketing Campaigns with pandas
Instruções do exercício
- Group the
marketingDataFrame bydate_servedand count the number of unique users per day. - Isolate converted users in
marketingwhile grouping bydate_servedand counting the number of unique converted users per day.
Exercício interativo prático
Experimente este exercício completando este código de exemplo.
# 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)