search

Home  >  Q&A  >  body text

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"的总次数）

巴扎黑巴扎黑2890 days ago601

reply all(1)I'll reply

  • 黄舟

    黄舟2017-04-17 17:47:07

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

    reply
    0
  • Cancelreply