在这种情况下，如何正确使用df[df['Event\u gender']=='X']？

Question

假设：有一个数据帧：

country       Edition     sports       Athletes           Medal  Event_gender
Germany          1990    Aquatics  HAJOS, Alfred          gold     X
Germany          1990    Aquatics  HIRSCHMANN, Otto       silver   X
Germany          1990    Aquatics  DRIVAS, Dimitrios      silver   M
US               2008    Athletics MALOKINIS, Ioannis     gold     M
US               2008    Athletics HAJOS, Alfred          silver   W
US               2009    Athletics CHASAPIS, Spiridon     gold     X
France           2010    Athletics CHOROPHAS, Efstathios  gold     X
France           2010    Athletics CHOROPHAS, Efstathios  gold     M
France           2010    golf      HAJOS, Alfred          silver   M
France           2011    golf      ANDREOU, Joannis       silver   W
Spain            2011    golf      BURKE, Thomas          gold     W

我想知道有多少国家获得过项目性别等于“X”的金牌

所以我想解决它，但我被卡住了。我做到了：

df[df['Medal']== 'gold']['country'].nunique() 

现在我知道了获得金牌的国家的数目，但我正在努力增加

df[df['Event_gender']== 'X']

根据上述逻辑得出最终结果。有人能帮我吗

Answer 1

IIUC，是的

df.loc[(df['Medal']=='gold') & (df['Event_gender']=='X'), 'country'].nunique()