#-*- 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()
python解析json文件
最新推荐文章于 2024-07-13 23:51:10 发布