How sort rows for specific columns in a DataFrame?

Question

I have a big DataFrame with 10 columns. I want to sort all rows just for specific columns (two). For example, if this be my data frame

I want it to sort it just for A and B but for rows so the answer should be like :

Thank you.

cs95 · Accepted Answer · 2019-06-08 00:22:00Z

2

Call np.sort on that specific subslice of columns and assign it back using loc:

# df.loc[:, ['A', 'B']] = np.sort(df.loc[:, ['A', 'B']], axis=1)   
df.loc[:, ['A', 'B']] = np.sort(df.loc[:, ['A', 'B']])                                                                 
df                                                                                                                     

   A  B  C
0  1  5  8
1  2  8  2
2  3  9  3

answered Jun 8, 2019 at 0:22

cs95

406k106 gold badges744 silver badges797 bronze badges

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

Comments

BENY · Accepted Answer · 2019-06-08 00:26:13Z

1

I am using sort

s=df[['A','B']]
s.values.sort()
df.update(s)
df
   A  B  C
0  1  5  8
1  2  8  2
2  3  9  3

answered Jun 8, 2019 at 0:26

BENY

324k22 gold badges176 silver badges250 bronze badges

Collectives™ on Stack Overflow

How sort rows for specific columns in a DataFrame?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related