pandas - How sort multiindex dataframe by column value and maintain multiindex structure?

Question

I have a multiindex (TestName and TestResult.Outcome) dataframe, want to sort descending by a column value and maintain the visual multiindex pair (TestName and TestResult.Outcome). How can I achieve that?

For example, I want to sort desc by column "n * %" for TestResult.Outcome index value "Failed" the following table:

I want to achieve the following outcome, maintaining the Pass Fail pairs in the indices:

I tried this:

orderedByTotalNxPercentDesc = myDf.sort_values(['TestResult.Outcome','n * %'], ascending=False)

but this orders firstly by index values = "Passed" and breaks the Passed Failed index pairs

Answer 1

This can help you:

import pandas as pd
import numpy as np

arrays = [np.array(["bar", "bar", "baz", "baz", "foo", "foo", "qux", "qux"]),np.array(["one", "two", "one", "two", "one", "two", "one", "two"])]

df = pd.DataFrame(np.random.randn(8, 4), index=arrays)

df.reset_index().groupby(["level_0"]).apply(lambda x: x.sort_values([3], ascending = False)).set_index(['level_0','level_1'])

In your case 3 is your column n * %, level_0 is your index TestName and level_1 is your TestResult.Outcome.

Becomes: