擅长:python、mysql、java
<p>示例数据:</p>
<pre><code> state District Year Item Unit Amount
0 TN Trichy 2016 Badam HA 4811
1 TN Trichy 2016 Badam N 59
2 TN Trichy 2016 Badam T 14558
3 TN Trichy 2016 Carrots HA 18973
4 TN Trichy 2016 Carrots N 123
5 TN Trichy 2016 Carrots T 35990
</code></pre>
<p>代码如下:</p>
<pre><code>res = df.pivot_table(index=['state','District','Year','Item'], values = 'Amount', columns =['Unit'])
Out[25]:
Unit HA N T
state District Year Item
TN Trichy 2016 Badam 4811 59 14558
Carrots 18973 123 35990
res.assign(result = res['T']/res['HA'])
Out[28]:
Unit HA N T result
state District Year Item
TN Trichy 2016 Badam 4811 59 14558 3.025982
Carrots 18973 123 35990 1.896906
</code></pre>