<p>使用<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.rename.html" rel="nofollow noreferrer">^{<cd1>}</a>,那么您只需要<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.stack.html" rel="nofollow noreferrer">^{<cd2>}</a>(<strong><code>dropna = True</code></strong>默认情况下)+<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.unstack.html" rel="nofollow noreferrer">^{<cd4>}</a>:</p>
<pre><code> df = (df.rename(columns = {'home_player_2':'home_player_1',
'Count_2':'Count_1'}).stack().unstack()
.reindex(columns = df.columns[:2]))
print(df)
home_player_1 Count_1
0 Aaron 1
1 Adam 2
2 Ziggy 3
3 Zoltan 4
</code></pre>
<p>或<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.shift.html" rel="nofollow noreferrer">^{<cd5>}</a>与<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.where.html" rel="nofollow noreferrer">^{<cd6>}</a>:</p>
<pre><code>df.where(df.notna(),df.shift(-1,axis = 1)).iloc[:,:2]
home_player_1 Count_1
0 Aaron 1.0
1 Adam 2.0
2 Ziggy 3.0
3 Zoltan 4.0
</code></pre>
<p><strong>细节</strong></p>
<pre><code>print(df.where(df.notna(),df.shift(-1,axis = 1)))
home_player_1 Count_1 home_player_2 Count_2
0 Aaron 1.0 NaN NaN
1 Adam 2.0 NaN NaN
2 Ziggy 3.0 Ziggy 3.0
3 Zoltan 4.0 Zoltan 4.0
</code></pre>