擅长:python、mysql、java
<p>可以使用<code>shift(-1, axis=1)</code>移动列,使用<code>df[df.home_player_1.isna() & df.Count_1.isna()]</code>指定要影响的行。移动的行应该在数据帧中重写</p>
<pre><code>df = pd.DataFrame([['Aaron', 1, None, None],
['Adam', 2, None, None],
[None, None, 'Ziggy', 3],
[None, None, 'Zoltan', 4]],
columns=['home_player_1', 'Count_1', 'home_player_2', 'Count_2'])
home_player_1 Count_1 home_player_2 Count_2
Aaron 1.0 None NaN
Adam 2.0 None NaN
None NaN Ziggy 3.0
None NaN Zoltan 4.0
df[df.home_player_1.isna() & df.Count_1.isna()] = df[df.home_player_1.isna() & df.Count_1.isna()].shift(-1, axis=1)
home_player_1 Count_1 home_player_2 Count_2
Aaron 1.0 None NaN
Adam 2.0 None NaN
Ziggy 3.0 NaN NaN
Zoltan 4.0 NaN NaN
</code></pre>