数据如下:
print(sex_s)
'''
%
Pclass Sex Survived
1 female 0 0.031915
1 0.968085
male 0 0.631148
1 0.368852
2 female 0 0.078947
1 0.921053
male 0 0.842593
1 0.157407
3 female 0 0.500000
1 0.500000
male 0 0.864553
1 0.135447
'''
Pclass,Sex,Survived构成了层次化索引
需要筛选出Sex为female,Survived为1的数据
可以使用reset_index()
方法将层次化索引转为列,然后进行筛选
另外也可以使用.index.get_level_values()
方法直接对索引值进行筛选:
sex_s[(sex_s.index.get_level_values('Sex') == 'female') & (sex_s.index.get_level_values('Survived') ==1 )]
'''
%
Pclass Sex Survived
1 female 1 0.968085
2 female 1 0.921053
3 female 1 0.500000
'''