擅长:python、mysql、java
<p>尝试:</p>
<pre><code>cumcount = df.groupby('Game_ID').cumcount()
renamer = {0: 'Home', 1: 'Away'}
df = df.set_index(['Game_ID', cumcount]).rename(renamer, level=1).unstack()
Team_ID Abrv Pts
Away Home Away Home Away Home
Game_ID
111 124 123 NOP LAL 110 101
112 126 125 WAS NYK 116 98
</code></pre>
<p>微小变化</p>
<pre><code>cumcount = df.groupby('Game_ID').cumcount()
renamer = {0: 'Home', 1: 'Away'}
df = df.set_index(['Game_ID', cumcount]).rename(renamer, level=1) \
.unstack().swaplevel(0, 1, 1).sort_index(1)
Away Home
Abrv Pts Team_ID Abrv Pts Team_ID
Game_ID
111 NOP 110 124 LAL 101 123
112 WAS 116 126 NYK 98 125
</code></pre>