擅长:python、mysql、java
<p>假设您有一个1.数据帧我建议用这样简单的方法。你知道吗</p>
<pre><code>>>> df
Soft Hand_ID Table_Size Blinds Day No_of_players Seat_1 Seat_2 Seat_3 Seat_4 Seat_5 Seat_6
PokerStars 172109655423 6-max €0.50/€1.00 2017/06/22 4 KO fasolakia14 Johnii141 bogec 0 0
PokerStars 143736274858 6-max £0.25/£0.50 2015/11/13 6 Racushniak koluha1000 Bantina DMIGNN Johnii141 vor4mohs
</code></pre>
<p>只需将您的座位列添加到一个列中</p>
<pre><code>>>> df['Seats'] = df['Seat_1'] + " " + df['Seat_2'] + " " + df['Seat_3'] + " " + df['Seat_4'] + " " + df['Seat_5'] + " " + df['Seat_6']
>>> df.drop(['Seat_1', 'Seat_2', 'Seat_3', 'Seat_4', 'Seat_5', 'Seat_6'], axis=1)
</code></pre>
<p>你会得到想要的结果</p>
<pre><code>Soft Hand_ID Table_Size Blinds Day No_of_players Seats
PokerStars 172109655423 6-max €0.50/€1.00 2017/06/22 4 KO fasolakia14 Johnii141 bogec 0 0
PokerStars 143736274858 6-max £0.25/£0.50 2015/11/13 6 Racushniak koluha1000 Bantina DMIGNN Johnii141...
</code></pre>