The full problem statement is available to Pro members.
preloaded fixtures
import pandas as pd
import numpy as np
search_events = pd.DataFrame({
"query": ["pizza near me", "weather", "pizza near me", "flight to tokyo", "weather", "weather", "python tutorial", "flight to tokyo"],
"device": ["mobile", "desktop", "mobile", "desktop", "mobile", "tablet", "desktop", "mobile"],
"impressions": [10, 8, 12, 5, 9, 7, 6, 4],
"clicks": [3, 1, 5, 2, 4, 0, 2, 1],
})
This is a Pro problem
“Click-through rate per query” is part of the Pro problem set. Upgrade to unlock the harder half of every track — SQL, Python and pandas.
The first problems in each track stay free.