擅长:python、mysql、java
<p>尝试使用<code>concat</code>,然后展平多索引</p>
<pre><code>out = df.assign(key=df.groupby('Game_ID').cumcount().astype(str)).set_index(['Game_ID','key']).unstack('key').sort_index(level=1,axis=1)
out.columns=out.columns.map('_'.join)
out
Out[444]:
Abrv_0 Pts_0 Team_ID_0 Abrv_1 Pts_1 Team_ID_1
Game_ID
111 LAL 101 123 NOP 110 124
112 NYK 98 125 WAS 116 126
</code></pre>