Pandas DataFrame Sort every Column [duplicate]

Question

What is a nice way of sorting every column alphabetically in a pandas DataFrame?

Example:

df = DataFrame({'A':['Bob','Rob','Dob'],'B':['Dob','Bob','Rob'],'C':['Rob','Bob','Dob']})

df

     A   B   C
0   Bob Dob Rob
1   Rob Bob Bob
2   Dob Rob Dob

I want:

     A   B   C
0   Bob Bob Bob
1   Dob Dob Dob
2   Rob Rob Rob

@miradulo Really, the top voted answer there uses apply + sort_values... for shame — cs95
– cs95, Commented Apr 21, 2018 at 2:35
@cᴏʟᴅsᴘᴇᴇᴅ This is another with your answer at the top: stackoverflow.com/questions/43280322/… — miradulo
– miradulo, Commented Apr 21, 2018 at 2:35

cs95 · Accepted Answer · 2018-04-21 02:32:36Z

2

Use np.sort along the first axis.

df[:] = np.sort(df, axis=0)

Or, even simpler,

df.values.sort(axis=0)

df
     A    B    C
0  Bob  Bob  Bob
1  Dob  Dob  Dob
2  Rob  Rob  Rob

answered Apr 21, 2018 at 2:32

cs95

406k106 gold badges744 silver badges797 bronze badges

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

Collectives™ on Stack Overflow

Pandas DataFrame Sort every Column [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related