Pandas dataframe sort on unique values [duplicate]

Question

I have a dataframe as follow:

df 

Col1     Col2
M1        4
M1        2
M1        1
M1        3
M2        3
M2        1
M2        2

I would like to sort the dataframe on python to achieve

Col1     Col2
M1        1
M1        2
M1        3
M1        4
M2        1
M2        2
M2        3

Any suggestion how to achieve this? Thank you

df.sort_values(['Col1','Col2'], inplace=True)?

Quang Hoang
– Quang Hoang

2019-09-26 00:06:22 +00:00
Commented Sep 26, 2019 at 0:06 — Quang Hoang
– Quang Hoang, Commented Sep 26, 2019 at 0:06

foglerit · Accepted Answer · 2019-09-26 00:07:29Z

0

Try

>>> df = df.sort_values(by=["Col1", "Col2"])
>>> print(df)

  Col1  Col2
2   M1     1
1   M1     2
3   M1     3
0   M1     4
5   M2     1
6   M2     2
4   M2     3

answered Sep 26, 2019 at 0:07

foglerit

8,4369 gold badges52 silver badges70 bronze badges

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

Collectives™ on Stack Overflow

Pandas dataframe sort on unique values [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related