擅长:python、mysql、java
<p>这应该可以完成以下工作:</p>
<pre><code>df['total_state_compensataion'] = df.groupby('State')['Compensation'].transform(sum)
df['total_state_fund_compensataion'] = df.groupby(['State','Fund'])['Compensation'].transform(sum)
df['ratio']=df['total_state_fund_compensataion'].div(df['total_state_compensataion'])
>>>df.groupby(['State','Fund'])['ratio'].mean().to_dict()
out[1] {('AL', '1000'): 0.38461538461538464,
('AL', '3000'): 0.6153846153846154,
('FL', '2000'): 1.0,
('NC', '4000'): 1.0}
</code></pre>