#!/usr/bin/env python3
import json, collections, os
os.chdir(os.path.dirname(os.path.abspath(__file__)))
d = json.load(open('mcp_complaints.json'))
print('updated:', d['updated'])
print('total:', d['total'])
it = d['items'][0]
print('keys:', sorted(it.keys()))
print('sample:', {k: it.get(k) for k in ('id','creator','area','status','created')})
c = collections.Counter(x['creator'] for x in d['items'])
print('creator top10:', c.most_common(10))
print('黄明月残留:', c.get('黄明月'), '张立娅残留:', c.get('张立娅'), '刘子研:', c.get('刘子研'))
print('空值数:', {k: sum(1 for x in d['items'] if not x.get(k)) for k in ('creator','area','status','created')})