<p>首先,可以将数据帧从宽到长进行融合,使用<code>Year</code>和<code>Country</code>作为id,<code>IncomeLevel</code>,<code>CPC_qtr_root</code>,和{<cd5>}作为值:</p>
<pre><code>df3 = pd.melt(df2, id_vars=['Year', 'Country'], value_vars=['IncomeLevel', 'CPC_qtr_root', 'Rate'])
</code></pre>
<p>然后可以旋转桌子:</p>
^{pr2}$
<p>这将返回:</p>
<pre><code>Country Afghanistan Albania Angola
Year variable
2000 CPC_qtr_root 0.134938 0.120672 0.110177
IncomeLevel Lower Income Upper Middle Income Lower Middle Income
Rate 27 95 36
2001 CPC_qtr_root 0.143537 0.049033 0.155105
IncomeLevel Lower Income Upper Middle Income Lower Middle Income
Rate 37 95 65
2002 CPC_qtr_root 0.103599 0.0476409 0.164784
IncomeLevel Lower Income Upper Middle Income Lower Middle Income
Rate 35 96 66
2003 CPC_qtr_root 0.0771533 0.0400869 0.0918947
IncomeLevel Lower Income Upper Middle Income Lower Middle Income
Rate 39 93 52
2004 CPC_qtr_root 0.0667594 0.0387958 0.0359603
IncomeLevel Lower Income Upper Middle Income Lower Middle Income
Rate 48 96 52
</code></pre>