回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>给定一个多索引<code>df</code>,如下所示</p>
<pre><code>mylevelA caseA VAR_A mylevelA_caseA__VAR_A bar one -0.054973 -0.092080
caseC VAR_B mylevelA_caseC__VAR_B bar two -0.282347 0.882559
VAR_A mylevelA_caseC__VAR_A baz one -0.691023 0.879495
caseB VAR_B mylevelA_caseB__VAR_B baz two -0.321049 1.036407
caseA VAR_C mylevelA_caseA__VAR_C foo one -0.411117 0.523282
caseB VAR_C_D mylevelA_caseB__VAR_C_D foo two -0.998682 0.232587
caseC VAR_E mylevelA_caseC__VAR_E qux one 0.690079 0.985688
caseD VAR_A mylevelA_caseD__VAR_A qux two -2.151700 0.554983
</code></pre>
<p>我想根据列表对level=1进行排序</p>
<pre><code>order_list=[caseC,caseB,caseD,caseA]
</code></pre>
<p>这将产生以下结果:</p>
<pre><code> col1 col2
mylevelA
caseC VAR_A mylevelA_caseC__VAR_A baz one 1.135174 -0.547376
VAR_E mylevelA_caseC__VAR_E qux one 0.021435 -0.047488
VAR_B mylevelA_caseC__VAR_B bar two -0.892378 2.649619
caseB VAR_C_D mylevelA_caseB__VAR_C_D foo two 1.945302 -1.848938
VAR_B mylevelA_caseB__VAR_B baz two -2.552820 1.025900
caseD VAR_A mylevelA_caseD__VAR_A qux two -0.833289 -1.478944
caseA VAR_C mylevelA_caseA__VAR_C foo one 1.269452 0.956567
</code></pre>
<p>我觉得这可以用<code>sort_values</code>和<code>sort_index</code>来解决</p>
<pre><code>df=df.sort_values(df.columns.tolist()).sort_index(level=1, ascending=False,
sort_remaining=False)
</code></pre>
<p>但是,<code>sort_index</code>上只有参数<code>ascending</code></p>
<p>另外,使用上面的表达式,我得到了以下输出</p>
<pre><code>import pandas as pd
import numpy as np
import re
from itertools import chain
arrays = [["mylevelA_caseA__VAR_A", "mylevelA_caseC__VAR_B", "mylevelA_caseC__VAR_A",
"mylevelA_caseB__VAR_B", "mylevelA_caseA__VAR_C", "mylevelA_caseB__VAR_C_D",
"mylevelA_caseC__VAR_E", "mylevelA_caseD__VAR_A"],
["bar", "bar", "baz", "baz", "foo", "foo", "qux", "qux"],
["one", "two", "one", "two", "one", "two", "one", "two"]]
df = pd.DataFrame(np.random.randn(8, 2), index=arrays,columns=['col1','col2'])
df.index = pd.MultiIndex.from_tuples([re.split('__?',e[0], maxsplit=2)+list(e)
for e in df.index])
df=df.sort_values(df.columns.tolist()).sort_index(level=1, ascending=False,
sort_remaining=False)
</code></pre>
<p>输出</p>
<pre><code> col1 col2
mylevelA caseD VAR_A mylevelA_caseD__VAR_A qux two 1.240834 -0.097545
caseC VAR_B mylevelA_caseC__VAR_B bar two -0.293481 1.342649
VAR_E mylevelA_caseC__VAR_E qux one -0.581308 -1.370208
VAR_A mylevelA_caseC__VAR_A baz one -1.179519 1.006746
caseB VAR_C_D mylevelA_caseB__VAR_C_D foo two 0.430511 0.447371
VAR_B mylevelA_caseB__VAR_B baz two -0.355763 -1.794507
caseA VAR_A mylevelA_caseA__VAR_A bar one 0.747331 -0.476303
VAR_C mylevelA_caseA__VAR_C foo one -0.702220 0.237277
</code></pre>
<p>我的问题是,如何使用给定的<code>list_order</code>对多索引顺序进行排序</p>