python读取json文件并转成csv或excel文件

最新推荐文章于 2024-07-05 03:53:55 发布

gm2178

最新推荐文章于 2024-07-05 03:53:55 发布

阅读量182

点赞数 3

文章标签： python json excel

本文链接：https://blog.csdn.net/gm2178/article/details/139960275

版权

执行前需安装依赖包

pip install pandas openpyxl

python 代码

#!/usr/bin/python3
import json
import collections
import glob
import pandas
from dataclasses import make_dataclass

#读取json文件列表path（windows系统）
jsonfiles = glob.glob('C:\\Users\\os-hui.guo\\Desktop\\py\\systeminfo*.json')
#读取json文件列表path（linux系统）
#jsonfiles = glob.glob('/usr/local/systeminfo*.json')
#输出文件path
outCsvPath = "out.csv"
outXlsxPath = "out.xlsx"
#输出文件表头
Model = make_dataclass("Model", [("model", str), ("count", int), ("model2", str), ("count2", int), ("model3", str), ("count3", int)])

modelList = []
#输出处理文件列表
print(jsonfiles)
for file in jsonfiles:
    sysFile = open(file,"r")
    sysJson = json.load(sysFile)
    allList = sysJson['system_info']['System']
    modalList = []
    for aitem in allList:
        modalList.append(aitem['Model'])
    countList = collections.Counter(modalList).items()
    model = Model('','','','','','')
    for citem in countList:
        if model.model == '':
            model.model = citem[0]
            model.count = citem[1]
        elif model.model2 == '':
            model.model2 = citem[0]
            model.count2 = citem[1]
    sysFile.close()
    modelList.append(model)

data = pandas.DataFrame(modelList)
#生成csv文件
data.to_csv(outCsvPath,header=True,index=False,sep=",")
#生成xlsx文件
data.to_excel(outXlsxPath,header=True,index=False)