python - Python - 根据另一个单元格条件选择行单元格

Question

我正在写一些python来绘制饼图。我试图找出使用某种阵型进了多少球。每行的格式为：

date        home_team      away_team home_score away_score  home_formation  away_formation
14/06/2018  Russia      Saudi Arabia         5           0         4-2-3-1         4-1-4-1

如果主队有 4-2-3-1 阵型，我想说的是，将 home_score 添加到计数器中。最后，我会将这些目标显示为饼图

for x in df:
if df.home_formation == '4-1-4-1':
    counter += df.home_score

formationScore1 = counter 

我的问题：我如何浏览 CSV 文件，检查格式是否是我想要的格式并将该行得分添加到变量中

标签： pythonpandasdata-analysis

Answer 1

formations = ['4-1-4-1', '4-2-3-1']  #Add as many as you'd like

formation_scores = {formation: df[df['home_formation'] == formation]['home_score'].sum() for formation in formations}