首页 > Mongodb中数组元素的个数统计

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'))
【热门文章】
【热门文章】