pandas.errors.UnsortedIndexError

exception pandas.errors.UnsortedIndexError

Error raised when slicing a MultiIndex which has not been lexsorted.

Subclass of KeyError.

See also

DataFrame.sort_index

Sort a DataFrame by its index.

DataFrame.set_index

Set the DataFrame index using existing columns.

Examples

>>> df = pd.DataFrame(
...     {
...         "cat": [0, 0, 1, 1],
...         "color": ["white", "white", "brown", "black"],
...         "lives": [4, 4, 3, 7],
...     },
... )
>>> df = df.set_index(["cat", "color"])
>>> df
            lives
cat  color
0    white    4
     white    4
1    brown    3
     black    7
>>> df.loc[(0, "black") : (1, "white")]
Traceback (most recent call last):
UnsortedIndexError: 'Key length (2) was greater
than MultiIndex lexsort depth (1)'