python解析json文件

#-*- coding:utf-8 -*-
import json
import xlwt


class importDataSceneOne():
    def __int__(self):
        pass
    def loadFont():
        f = open("2020110383037436.json", encoding='utf-8')
        setting = json.load(f)
        family = setting['hits']['hits'] #[0]['_source']['cust_ser_acct_no']
        pin_list=[]
        shop_supplier_id=[]
        shop_supplier_name=[]
        order_d7_sale_qtty=[]
        est_pass_rate=[]
        receive_qtty=[]
        new_resp_avg_duration=[]
        workbook = xlwt.Workbook(encoding='utf-8')
        data_sheet: object = workbook.add_sheet('demo')
        data_sheet.write(0, 0, label='客服pin')
        data_sheet.write(0, 1, label='电话')
        data_sheet.write(0, 2, label='姓名')
        data_sheet.write(0, 3, label='店铺id')
        data_sheet.write(0, 4, label='店铺名称')
        data_sheet.write(0, 5, label='7天销售量')
        data_sheet.write(0, 6, label='满意度')
        data_sheet.write(0, 7, label='接待量')
        data_sheet.write(0, 8, label='新平响')
        data_sheet.write(0, 9, label='是否实名认证')
        data_sheet.write(0, 10, label='是否绑卡')

        for i in family:
            pin = i['_source']['cust_ser_acct_no']
            shop_id = i['_source']['shop_supplier_id']
            shop_name = i['_source']['shop_supplier_name']
            order_d7_qtty = i['_source']['order_d7_sale_qtty']
            est_rate = i['_source']['est_pass_rate']
            receive = i['_source']['receive_qtty']
            new_avg_duration=i['_source']['new_resp_avg_duration']
            pin_list.append(pin)
            shop_supplier_id.append(shop_id)
            shop_supplier_name.append(shop_name)
            order_d7_sale_qtty.append(order_d7_qtty)
            est_pass_rate.append(est_rate)
            receive_qtty.append(receive)
            new_resp_avg_duration.append(new_avg_duration)

        for i in range(len(pin_list)):
            data_sheet.write(i+1, 0, pin_list[i])
            data_sheet.write(i+1, 3, shop_supplier_id[i])
            data_sheet.write(i+1, 4, shop_supplier_name[i])
            data_sheet.write(i+1, 5, int(order_d7_sale_qtty[i]))
            data_sheet.write(i+1, 6, float(est_pass_rate[i]))
            data_sheet.write(i+1, 7, int(receive_qtty[i]))
            data_sheet.write(i+1, 8, float(new_resp_avg_duration[i]))


        workbook.save('2020110362095475.xls')



    loadFont()