python - 如何根据pandas数据框中其他列的应用条件提取列值

Question

print("Someone has killed {:.4f} with headshot, have {} kills, while the most kills ever recorded is {}.".format(pubg_main_df['headshotKills'].max(), pubg_main_df[pubg_main_df['headshotKills']==pubg_main_df['headshotKills'].max()]['kills'], pubg_main_df['kills'].max()))

我想要的是在 headshotKills 最大的情况下获取“Kills”的值。

但我得到:

有人爆头杀死了 26.0000 人，有 910050 60 人名称:杀戮，数据类型:int64 杀戮，而记录的最多杀戮是 60。

应该是:

有人爆头杀死了 26.0000 人，共击杀 42 人，而历史记录最多击杀人数为 60 人。

变量的类型是:

headshotKills int64

杀死 int64

请帮忙。 :)

Answer 1

使用set_index与 idxmax :

#sample data
pubg_main_df= pd.DataFrame({'kills':[60,  42], 'headshotKills':[3, 26]})

print("Someone has killed {:.4f} with headshot, have {} kills, while the most kills ever recorded is {}."
            .format(pubg_main_df['headshotKills'].max(), 
                    pubg_main_df.set_index('kills')['headshotKills'].idxmax(), 
                    pubg_main_df['kills'].max()))


Someone has killed 26.0000 with headshot, have 42 kills, while the most kills ever recorded is 60.