将json数据存入csv文件中

import json
import pandas as p
import sys
reload(sys)
sys.setdefaultencoding('utf8')

# json数据要进习惯压缩之后才能够将数据转换为字典的形式

with open("a.json",'r') as f:
    for line in f:
        a = json.loads(line)
        # print(type(a))
        for k,v in a.items():
            for kk,vv in v.items():
                print(vv)
                area_code = kk
                name = vv.get('name')
                latitude=vv.get('latitude')
                longitude = vv.get('longitude')
                with open('c.csv','a') as f:
                    f.write('{},{},{},{}\n'.format(area_code,name,latitude,longitude))