擅长:python、mysql、java
<p>我会选择<code>melt()</code>,它非常通用:</p>
<pre><code> teamname player.1 player.2 player.3
0 xyz abc NaN def
1 gh1 NaN hgf jnr
2 oed jeo NaN NaN
</code></pre>
<p>导致</p>
<pre><code>df.melt(id_vars=['teamname'], value_name='player').dropna().drop('variable', axis=1).sort_values(['teamname'], ascending=False).set_index('teamname')
player
teamname
xyz abc
xyz def
oed jeo
gh1 hgf
gh1 jnr
</code></pre>
<p>melt后面的部分删除了NAN,删除了一个我们不需要的列,并对数据帧进行了排序。最后,我们将<code>teamname</code>设置为索引</p>