pandas语法用于更复杂的sql查询

Question

我正在寻找pandas语法做以下聚合到pandas数据帧。我找不到一个如何在pandas中完成以下sql查询的示例。在

#sum and divide
select
 click,
 ctr,
 SUM(click)/SUM(imp) as ctr
from mytable
group by website

#normalize each subgroup 
select
 imp,
 imp/SUM(imp) Over (partition website) as n_imp
from mytable

Answer 1

SQL语言：

#normalize each subgroup 
select
 imp,
 imp/SUM(imp) Over (partition website) as n_imp
from mytable

熊猫：

^{pr2}$