Multi-Index - Not able to sort multiple indexes in a single line

Question

I am trying to sort multiple indexes in Python using following code which gives me the error as provided below the code:

raw_data.sort_index(level='employee_id',ascending=False,inplace=True).sort_index(level='PAYCODE_ID',ascending=True,inplace=True)

---------------------------------------------------------------------------
AttributeError                            Traceback (most recent call last)
<ipython-input-732-d2ad9fdef0b4> in <module>
----> 1 raw_data.sort_index(level='employee_id',ascending=False,inplace=True).sort_index(level='PAYCODE_ID',ascending=True,inplace=True)

AttributeError: 'NoneType' object has no attribute 'sort_index'

I think the python results into 'None' object type after first 'sort_index' method. As per the python documentation, if the 'inplace' parameter is set to True, the return object would be a Data Frame.

Also to note that when i split the methods into following two line of code, it stores the sorted result into the raw_data dataframe:

raw_data.sort_index(level='employee_id',ascending=False,inplace=True)
raw_data.sort_index(level='PAYCODE_ID',ascending=True,inplace=True)

Quang Hoang · Accepted Answer · 2020-09-27 15:34:38Z

2

If you pass inplace=True to sort_index, the function will operate inplace and returns None. So either remove inplace=True and assign back if you want to chain the commands, or do the two separate commands like you posted.

Also, you can pass multiple levels to sort_index

raw_data.sort_index(level=['employee_id', 'PAYCODE_ID'],
                    ascending=[False, True],inplace=True)

answered Sep 27, 2020 at 15:34

Quang Hoang

151k11 gold badges64 silver badges86 bronze badges

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

1 Comment

AAKASH RAJU Udasi Over a year ago

Thank you. I misread the documentation. :) The code you have posted worked too.

Collectives™ on Stack Overflow

Multi-Index - Not able to sort multiple indexes in a single line

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related