python操作json和excel

excel表格展示

import json
import xlwt

d = json.load(open("D:\\笔记\\22.txt", 'r',encoding="utf-8"))
# for item in d:
#     print(item["_source"])

xls=xlwt.Workbook()
sht1 = xls.add_sheet("Sheet1")

#设置excel表头一行四列
sht1.write(0,0,"ipv4_addr")
sht1.write(0,1,"port_num")
sht1.write(0,2,"application_protocol")
sht1.write(0,3,"domain_url")

#循环填充表格数据
line=1
for item in d:
    sht1.write(line,0,item["_source"]["ipv4_addr"])
    sht1.write(line,1,item["_source"]["port_num"])
    sht1.write(line,2,item["_source"]["application_protocol"])
    sht1.write(line,3,item["_source"]["domain_url"])
    line=line+1
xls.save(r"D:\\ab.xls")

View Code

[
      {
        "_index" : "common_asset_info_20220114",
        "_type" : "_doc",
        "_id" : "175.222.248.145-222-h4ujgn2.cachenode.cn",
        "_score" : 1.0,
        "_source" : {
          "ipv4_addr" : "175.222.248.145",
          "application_protocol" : "http",
          "domain_url" : "h4ujgn2.cachenode.cn",
          "port_num" : 222
        }
      },
      {
        "_index" : "common_asset_info_20220114",
        "_type" : "_doc",
        "_id" : "222.2253-9785-lh47ff3.cachenode.cn",
        "_score" : 1.0,
        "_source" : {
          "ipv4_addr" : "222.243.22.53",
          "application_protocol" : "http",
          "domain_url" : "lh47ff3.cachenode.cn",
          "port_num" : 9785
        }
      }
]

json内容

 通过python解析json内容并把相关数据生成一个新的excel文件