df_by_query = (df
               .groupby("query")
               .agg({"clicks": "sum", "impressions": "sum", "position": "mean"})
               .sort_values("clicks",ascending=False))
df_by_query["ctr"] = (df_by_query.clicks / df_by_query.impressions)*100
df_by_query.head(5)