python - Mongodb中数组元素的个数统计

问题描述

问 题

集合中的记录格式如下：

{"ID":"0001",
 "Fir":"0",
 "Sec":"1",
 "FirCard_NE":["0402003","0101002","0201001","0503001","0402003","0204001","0204002","0301001","0101001","0402003","0501001","0501002","0503001","0503002","0501002"],
 "SecCard_NE":["0101001","0101001","0201001","0202001","0203001","0204001","0204002","0301001","0301004","0204001","0501001","0501002","0503001","0503002","0301004"]
}

现在想统计在"Fir"为"0"的情况下，FirCard_NE字段中某个数组元素在整个集合中出现的次数
（如统计在"Fir"为"0"的情况下，FirCard_NE中出现"0402003"的总次数）

解决方案

if d['Fir'] == '0':
    print(d['FirCard_NE'].count('0402003'))

这篇关于python - Mongodb中数组元素的个数统计的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！