import pandas as pd
df = pd.DataFrame({'class':['A','A','A','B','B','B','C','C'],
'id':['a','b','c','a','b','c','a','b'],
'value':[1,2,3,4,5,6,7,8]})
df
df=df.set_index(['class','id'])
df.loc[('A',slice(None)),:]
df.loc[(slice(None),'a'),:]
df2 = pd.DataFrame({'课程':['语文','语文','数学','数学'],'得分':['最高','最低','最高','最低'],'分值':[90,50,100,60]})
df2 = df2.set_index(['课程','得分'])
df2
df2.loc[('语文',slice(None)),:]
df2.index.is_lexsorted()
df2=df2.sort_index(level='课程')
df2
df2.loc[('语文',slice(None)),:]