擅长:python、mysql、java
<p>通过使用<code>pd.crosstab</code>,而且,<code>pivot</code>也可以实现这一点:-)</p>
<pre><code>pd.crosstab(index =df['MaturityYear'],columns =df['Type'],values =df['Notional'],aggfunc=np.sum).fillna(0)
Out[877]:
Type FIXED FLOATING
MaturityYear
2020 600.0 0.0
2021 750.0 250.0
2025 700.0 0.0
</code></pre>