python json文件写入到excel

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


def json_excel(data):
    # 创建excel工作表
    workbook = xlwt.Workbook(encoding='utf-8')
    worksheet = workbook.add_sheet('skiing')
    # 写表头
    for index, val in enumerate(data[0].keys()):
        worksheet.write(0, index, label=val)

    # 写数据
    for row, list_item in enumerate(data):
        row += 1
        col = 0
        for key, value in list_item.items():
            worksheet.write(row, col, value)
            col += 1

    # 保存
    workbook.save('./excel_file/20220207_143920-dong.xls')


if __name__ == '__main__':
    json_data = [{'id': '0', 'Nose_x': 190.7252960205078, 'Nose_y': 210.91796875, 'LEye_x': 73.22344970703125, 'LEye_y': 139.49526977539062, 'REye_x': 70.91949462890625, 'REye_y': 130.27944946289062, 'LEar_x': 70.91949462890625, 'LEar_y': 132.58340454101562, 'REar_x': 73.22344970703125, 'REar_y': 125.6715316772461, 'Head_x': 179.20550537109375, 'Head_y': 210.91796875, 'Neck_x': 68.61553955078125, 'Neck_y': 116.45570373535156}]
    json_excel(json_data)

结果：