python实现Json内容转化到excel表格中

import json
import time
import pandas
import datetime
import argparse

def json_to_excel(json_path, excel_path):
     jsonObj = json.load(open(json_path, 'r', encoding="utf-8"))

     dataOutput = {}
     dataOutput_id = []
     for key, value in jsonObj[0].items():
         dataOutput_id.append(key)
         dataOutput[key] = []
     indexNum = 1
     for line in jsonObj:
        for key, value in line.items():
            if key not in dataOutput_id:
                dataOutput[key] = []
            else:
                dataOutput[key].append(value)
        print("正在处理第"+str(indexNum) + "行")
        indexNum += 1
     currentTime = datetime.datetime.now()
     # dataForm = pandas.DataFrame.from_dict(dataOutput, orient='index')
     dataForm = pandas.DataFrame(pandas.DataFrame.from_dict(dataOutput, orient='index').values.T, columns=list(dataOutput.keys()))
     dataForm.to_excel(excel_path + "\\json-to-excel-" + currentTime.strftime("%Y%m%d") + ".xlsx")

def parse_args():
    parser = argparse.ArgumentParser(description='json路径 和 excel路径')
    parser.add_argument('--json_path', type=str, help="", default="")
    parser.add_argument('--excel_path', type=str, help="", default="")
    args = parser.parse_args()
    return args

if __name__ == "__main__":
    args = parse_args()
    json_path = args.json_path
    excel_path = args.excel_path
    json_to_excel(json_path, excel_path)