Sort dataframe with multi index

Question

A simple example, let's say I have this DataFrame:

raw = pd.DataFrame(np.array([
    [1, 2, 5, 'User 1', 5],
    [1, 2, 3, 'User 2', 3],
    [1, 2, 2, 'User 3', 5],
    [3, 2, 4, 'User 4', 7],
    [3, 2, 3, 'User 5', 2],
    [3, 1, 6, 'User 6', 5],
    [2, 2, 6, 'User 7', 1],
    [2, 2, 5, 'User 8', 4],
    [2, 2, 3, 'User 9', 8],
]), columns=['a', 'b', 'c', 'd', 'e'])

and below that code:

raw.set_index(['a', 'b', 'c'], inplace=True)
raw.sort_index()
raw.head(9)

The output looks like that:

Instead of sorting it first by a, then by b, then by c. ( the whole row ) How could it be solved?

jezrael · Accepted Answer · 2019-12-19 12:58:10Z

1

Add inplace=True parameter DataFrame.sort_index:

raw.sort_index(inplace=True)

Or assign output back:

raw = raw.sort_index()

print (raw)
            d  e
a b c           
1 2 2  User 3  5
    3  User 2  3
    5  User 1  5
2 2 3  User 9  8
    5  User 8  4
    6  User 7  1
3 1 6  User 6  5
  2 3  User 5  2
    4  User 4  7

answered Dec 19, 2019 at 12:58

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

Collectives™ on Stack Overflow

Sort dataframe with multi index

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related