擅长:python、mysql、java
<pre><code>>>> df.reset_index().groupby(['unit','year'])['SURQ'].mean()
unit year
10001 2012 89
2013 75
2014 36
10002 2012 83
2013 69
2014 59
10003 2012 88
2013 59
2014 84
Name: SURQ, dtype: int64
</code></pre>
<p>或使用数据透视表:</p>
<pre><code>>>> pd.pivot_table(df.reset_index(),columns=['unit','year'],aggfunc=np.mean)
unit year
SURQ 10001 2012 89
2013 75
2014 36
10002 2012 83
2013 69
2014 59
10003 2012 88
2013 59
2014 84
dtype: int64
</code></pre>