Htykuut

I have a dataframe with 3 indexes, and i am trying to sort them. Unfortunately depending on the order that I try and sort the indexes I sometimes get the following error:

Traceback (most recent call last):



  File "<ipython-input-30-30a4bb212256>", line 1, in <module>

    df_srmc_lrmc.sort_index(axis='index', level=['Station_Type', 'Generator','Year'], inplace=True)



  File "E:Python35WinPython-64bit-3.5.4.0Qt5python-3.5.4.amd64libsite-packagespandascoreframe.py", line 3236, in sort_index

    sort_remaining=sort_remaining)



  File "E:Python35WinPython-64bit-3.5.4.0Qt5python-3.5.4.amd64libsite-packagespandascoreindexesmulti.py", line 1714, in sortlevel

    primary = tuple(labels.pop(lev - i) for i, lev in enumerate(level))



  File "E:Python35WinPython-64bit-3.5.4.0Qt5python-3.5.4.amd64libsite-packagespandascoreindexesmulti.py", line 1714, in <genexpr>

    primary = tuple(labels.pop(lev - i) for i, lev in enumerate(level))



IndexError: pop index out of range

Looking at my dataframe, you can see the following indexes:

df_srmc_lrmc.index.names

Out[32]: FrozenList(['Year', 'Generator', 'Station_Type'])

The following sort commands work:

df_srmc_lrmc.sort_index(axis='index', level=['Generator','Year','Station_Type'], inplace=True)

df_srmc_lrmc.sort_index(axis='index', level=['Year','Station_Type', 'Generator'], inplace=True)

df_srmc_lrmc.sort_index(axis='index', level=['Year','Generator','Station_Type'], inplace=True)

df_srmc_lrmc.sort_index(axis='index', level=['Station_Type', 'Year','Generator'], inplace=True)

But the following don't, they throw the error mentioned above:

df_srmc_lrmc.sort_index(axis='index', level=['Generator','Station_Type','Year'], inplace=True)

df_srmc_lrmc.sort_index(axis='index', level=['Station_Type', 'Generator','Year'], inplace=True)

As I am sure you have guessed, I am wanting one of the sort orders that doesn't work :(

My pandas version info:

pd.__version__

Out[34]: '0.20.3'

Can someone tell me what is going on, or what I am doing wrong? I am quite new to Python so the more handholding the better.

Thanks