首先是 2 個快速投球手，然后是兩個旋轉(zhuǎn)投球手，然后是一個快速投球手和全能投球手（擊球手 + 投球手）。其中的順序?qū)⒂伤扇〉男￠T數(shù)量決定。 Name Role run_scored wickets_taken19 P Fast Bowler 62 1318 Q Spin Bowler 65 1216 O Fast Bowler 32 915 N Batsman+Fast Bowler 114 814 K Fast Bowler 24 713 T Spin Bowler 17 6
1 回答
小怪獸愛吃肉
TA貢獻1852條經(jīng)驗 獲得超1個贊
您可以按 wickets 降序排序，創(chuàng)建一個將 Role 映射到數(shù)據(jù)幀切片的字典，然后根據(jù)您的規(guī)則連接結(jié)果。
# sort by 'wickets_taken'
df = df.sort_values('wickets_taken', ascending=False)
# group by 'Role'
g = dict(tuple(df.groupby('Role')))
# concatenate custom slices
res = pd.concat([g['FastBowler'].iloc[:2],
g['SpinBowler'],
g['FastBowler'].iloc[2:],
g['Batsman+FastBowler']],
ignore_index=True)
結(jié)果
print(res)
Name Role run_scored wickets_taken
0 P FastBowler 62 13
1 O FastBowler 32 9
2 Q SpinBowler 65 12
3 T SpinBowler 17 6
4 K FastBowler 24 7
5 N Batsman+FastBowler 114 8
添加回答
舉報
0/150
提交
取消