擅长:python、mysql、java
<p>好的,首先使用<a href="http://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.groupby.html" rel="nofollow noreferrer">groupby</a>得到如下表:</p>
<pre><code>AID Sum(ANumOfF)
1 6
2 36
</code></pre>
<p>然后<a href="http://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.join.html" rel="nofollow noreferrer">join</a>该数据帧与原始数据帧:</p>
<pre><code>AID FID ANumOfF TotalNum
1 X 1 6
1 Y 5 6
2 Z 6 36
2 A 1 36
2 X 11 36
2 B 18 36
</code></pre>
<p>最后用<code>ANumOfF</code>列除以<code>TotalNum</code>列得到百分比</p>
<p>希望这有帮助</p>