python - Pandas 计数字典中值的出现

Question

给定一个 DF:

pd.DataFrame({"A":[1,2,3],
              "B": [{"Mon":"Closed", "Tue":"Open", "Wed":"Closed"},
                    {"Mon":"Open", "Tue":"Open", "Wed":"Closed"},
                    {"Mon":"Open", "Tue":"Open", "Wed":"Open"}]
              })

我如何计算“关闭”出现在字典中的次数？

A  B    count
1 {..}  2
2 {..}  1 
3 {..}  0

我真的不知道如何开始尝试

Answer 1

你可以做一个 apply :

df['count'] = df.B.apply(pd.Series).eq('Closed').sum(1)

输出:

   A                                                  B  count
0  1  {'Mon': 'Closed', 'Tue': 'Open', 'Wed': 'Closed'}      2
1  2    {'Mon': 'Open', 'Tue': 'Open', 'Wed': 'Closed'}      1
2  3      {'Mon': 'Open', 'Tue': 'Open', 'Wed': 'Open'}      0