作者:v时光i | 来源:互联网 | 2022-12-10 14:05
1> jezrael..:
用途get_level_values
为选择第二级MultiIndex
与duplicated
布尔面具,反转条件和过滤器通过boolean indexing
:
df = df[~df.index.get_level_values(1).duplicated()]
print (df)
given_name surname dob phone_number_1_clean
985 2414 1.0 1.0 0.0 1.0
122864 1.0 1.0 0.0 0.0
167863 1.0 1.0 0.0 0.0
418911 1.0 1.0 0.0 0.0
516362 1.0 1.0 0.0 0.0
详细说明:
print (df.index.get_level_values(1))
Int64Index([ 2414, 122864, 167863, 418911, 516362, 122864, 167863, 418911,
516362, 167863, 418911, 516362, 418911, 516362, 516362],
dtype='int64')
print (df.index.get_level_values(1).duplicated())
[False False False False False True True True True True True True
True True True]
print (~df.index.get_level_values(1).duplicated())
[ True True True True True False False False False False False False
False False False]