<p>您可以先从<code>aggfunc</code>中删除<code>[]</code>以避免列中的<code>MultiIndex</code>,然后使用<a href="http://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.mean.html" rel="nofollow noreferrer">^{<cd4>}</a>by rows(<code>axis=1</code>)和<a href="http://pandas.pydata.org/pandas-docs/stable/generated/pandas.Series.round.html" rel="nofollow noreferrer">^{<cd6>}</a>:</p>
<pre><code>pivot=pd.pivot_table(Data1,values=["Yield_2006", "Yield_2007", "Yield_2008", "Yield_2009"],
index=["District","Crop"],
aggfunc=np.mean,fill_value=False)
pivot['Average_Yield'] = pivot.mean(axis=1).round(4)
print (pivot)
Yield_2006 Yield_2007 Yield_2008 Yield_2009 \
District Crop
AHMEDNAGAR PADDY 809.212500 1214.1 983.45 398.1125
AMRAVATI PADDY 539.828571 799.9 370.90 272.8000
Average_Yield
District Crop
AHMEDNAGAR PADDY 851.2188
AMRAVATI PADDY 495.8571
</code></pre>
<p>对于select列,可以使用<a href="http://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.loc.html" rel="nofollow noreferrer">^{<cd7>}</a>或<code>subset</code>:</p>
^{pr2}$
<pre><code>pivot['Average_Yield'] = pivot[['Yield_2006','Yield_2007']].mean(axis=1).round(4)
print (pivot)
Yield_2006 Yield_2007 Yield_2008 Yield_2009 \
District Crop
AHMEDNAGAR PADDY 809.212500 1214.1 983.45 398.1125
AMRAVATI PADDY 539.828571 799.9 370.90 272.8000
Average_Yield
District Crop
AHMEDNAGAR PADDY 1011.6563
AMRAVATI PADDY 669.8643
</code></pre>