pandas multi index sort directly

Question

I asked this question: pandas multi index sort specific fields as a follow up I would like to improve a little bit and perform the sorting directly with multi indices:

Here is a sample df

df = pd.DataFrame({'modelName':['model1','model1', 'model2', 'model2'],
                           'scoringValue':[7,8,9,7]})

Which results in the following overview

overview = df.groupby([df.modelName]).describe().unstack(fill_value=0).loc[:, pd.IndexSlice[:, ['mean','std']]]
print(overview)

          scoringValue          
                  mean       std
modelName                       
model1             7.5  0.707107
model2             8.0  1.414214

I want to sort the models by mean of scoringValue, but retain the grouped relationship to std

This could be achieved by

overview.columns = ['{0[0]}_{0[1]}'.format(tup) for tup in overview.columns]
overview.sort_values('scoringValue_mean', ascending=False)

But I rather would like to work directly with the Multi-index (nicer visual representation) and get a result like this one:

          scoringValue          
                  mean       std
modelName                       
model2             8.0  1.414214 
model1             7.5  0.707107

MaxU - stand with Ukraine · Accepted Answer · 2016-10-23 10:54:09Z

1

What about using DataFrame.sort_index(level=1)?

In [77]: overview.sort_index(level=1, ascending=0)
Out[77]:
          scoringValue
                  mean       std
modelName
model2             8.0  1.414214
model1             7.5  0.707107

answered Oct 23, 2016 at 10:54

MaxU - stand with Ukraine

212k37 gold badges402 silver badges436 bronze badges

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

2 Comments

Georg Heiler Over a year ago

great! Thanks again.

MaxU - stand with Ukraine Over a year ago

@GeorgHeiler, sure! It was a perfect question - very clear and fully reproducible (including python code) - good job! :)

Collectives™ on Stack Overflow

pandas multi index sort directly

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related