这是文本中名称出现的数据框架。名称" Sage"," Davies"one_answers" Asplund"同样发生时间。因此,我需要查询才能返回所有三个名字。
Name,Occurrence
Sage,6
Davies,6
Asplund,6
Goodwin,5
Panula,5
Arnold,4
........
使用,获取行
In [1876]: df[df['Occurrence'] == df['Occurrence'].max()]
Out[1876]:
Name Occurrence
0 Sage 6
1 Davies 6
2 Asplund 6
,要获得Name
S
In [1878]: df.loc[df['Occurrence'] == df['Occurrence'].max(), 'Name']
Out[1878]:
0 Sage
1 Davies
2 Asplund
Name: Name, dtype: object
In [1879]: df.loc[df['Occurrence'] == df['Occurrence'].max(), 'Name'].values.tolist()
Out[1879]: ['Sage', 'Davies', 'Asplund']
,要获取index
值
In [1880]: df[df['Occurrence'] == df['Occurrence'].max()].index
Out[1880]: Int64Index([0, 1, 2], dtype='int64')