擅长:python、mysql、java
<p>枢轴的另一种方式:</p>
<pre><code>df['idx'] = df.name.eq('Country or Area').cumsum()
df.pivot(index='idx', columns='name', values='data')
</code></pre>
<p>输出:</p>
<pre><code>name Country or Area Item Value Year
idx
1 Aruba Population, total 54211 1960
2 Aruba Population, total 55438 1961
3 Aruba Population, total 56225 1962
4 Aruba Population, total 56695 1963
5 Aruba Population, total 57032 1964
</code></pre>