How to sort a list element in a DataFrame column

Question

I have a dataframe as follows:

        venue        innings     batting_team                  bowling_team            score       batsmen
M Chinnaswamy Stadium   1   Kolkata Knight Riders          Royal Challengers Bangalore  61     [SC Ganguly, BB McCullum, RT Ponting]
M Chinnaswamy Stadium   2   Royal Challengers Bangalore    Kolkata Knight Riders        26     [R Dravid, W Jaffer, V Kohli, JH Kallis, CL White, MV Boucher]
Feroz Shah Kotla        1   Rajasthan Royals               Delhi Daredevils             40     [T Kohli, YK Pathan, SR Watson, M Kaif]
Feroz Shah Kotla        2   Delhi Daredevils               Rajasthan Royals             55     [G Gambhir, V Sehwag, S Dhawan]
Wankhede Stadium        1   Mumbai Indians                 Royal Challengers Bangalore  47     [L Ronchi, ST Jayasuriya, DJ Thornely, RV Uthappa, PR Shah]
Wankhede Stadium        2   Royal Challengers Bangalore    Mumbai Indians               40     [S Chanderpaul, R Dravid, LRPL Taylor]
Eden Gardens            1   Deccan Chargers                Kolkata Knight Riders        39     [AC Gilchrist, Y Venugopal Rao, VVS Laxman, A Symonds]
Eden Gardens            2   Kolkata Knight Riders          Deccan Chargers              26     [WP Saha, BB McCullum, RT Ponting, SC Ganguly, DJ Hussey]
Sawai Mansingh Stadium  1   Kings XI Punjab                Rajasthan Royals             54     [K Goel, JR Hopes, KC Sangakkara]
Sawai Mansingh Stadium  2   Rajasthan Royals               Kings XI Punjab              53     [M Kaif, YK Pathan, Kamran Akmal, SR Watson, DS Lehmann]

As it can be seen, the batsmen column has lists as its elements. Now I need to sort each list. I used the code

df['batsmen'] = df['batsmen'].sort()

but I get the error as Series object as no attribute 'sort'. How can I achieve this so that each list in the column gets sorted in ascending order?

Got an error as operands could not be broadcast together with shapes (2,) (3,). — Mujeebur Rahman
– Mujeebur Rahman, Commented Apr 20, 2021 at 14:27

Ynjxsjmh · Accepted Answer · 2021-04-20 14:28:10Z

2

Try

df['batsmen'] = df['batsmen'].apply(sorted)

If you want to reverse the list, you can do

df['batsmen'] = df['batsmen'].apply(lambda x: sorted(x, reversed=True))

answered Apr 20, 2021 at 14:28

Ynjxsjmh

30.3k7 gold badges43 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Даниил Цыбульников · Accepted Answer · 2021-04-20 14:32:27Z

1

Try df.sort_values(by="batsmen").head() https://pandas.pydata.org/docs/getting_started/intro_tutorials/07_reshape_table_layout.html

answered Apr 20, 2021 at 14:32

Даниил Цыбульников

112 bronze badges

1 Comment

Mujeebur Rahman Over a year ago

Getting error as operands could not be broadcast together with shapes (2,) (3,) .

Andrej Kesely · Accepted Answer · 2021-04-20 14:39:08Z

1

Another solution, if you want to do it in-place:

df["batsmen"].apply(list.sort)
print(df)

EDIT: For numpy.ndarray:

df["batsmen"].apply(np.ndarray.sort)
print(df)

edited Apr 20, 2021 at 14:39

answered Apr 20, 2021 at 14:29

Andrej Kesely

196k15 gold badges60 silver badges105 bronze badges

1 Comment

Mujeebur Rahman Over a year ago

Getting error as descriptor 'sort' for 'list' objects doesn't apply to a 'numpy.ndarray' object.

Collectives™ on Stack Overflow

How to sort a list element in a DataFrame column

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related