import json, os
from collections import Counter
P = '/Users/liuxinyuan/Desktop/Hermes输出-工作类/数据/mcp_complaints.json'
d = json.load(open(P))
items = d.get('items', [])
print('total_field:', d.get('total'), 'len_items:', len(items), 'updated:', d.get('updated'))
keys = Counter()
for it in items:
    for k in it.keys():
        keys[k] += 1
print('keys:', dict(keys))
cr = Counter(it.get('creator') for it in items)
print('creator top:', cr.most_common(12))
print('黄明月 count:', cr.get('黄明月', 0), '张立娅:', cr.get('张立娅', 0), '刘子研:', cr.get('刘子研', 0))
st = Counter(it.get('status') for it in items)
print('status:', st.most_common(10))
ar = Counter(it.get('area') for it in items)
print('area:', ar.most_common(10))
print('sample:', json.dumps(items[0], ensure_ascii=False)[:400])