python - 从python for Excel中的json数组中提取数据

Question

{
  "result" : [{
      "conf" : 1.000000,
      "end" : 0.300000,
      "start" : 0.000000,
      "word" : "bright"
    }, {
      "conf" : 1.000000,
      "end" : 0.720000,
      "start" : 0.330000,
      "word" : "bright"
    }, {
      "conf" : 1.000000,
      "end" : 1.950000,
      "start" : 1.710000,
      "word" : "bright"
    }],
  "text" : "bright bright bright"
}

我有这个 JSON 数组。我需要从表格格式的“结果”中提取所有细节。例如，

   conf       start      end        word
1.000000    0.000000   0.300000    bright
1.000000    0.330000   0.720000    bright
1.000000    1.710000   1.950000    bright

如何从“结果”部分中提取这些值并将详细信息附加到 excel 中？

Answer 1

使用 csv 内置模块。

import csv

json = {
  "result" : [{
      "conf" : 1.000000,
      "end" : 0.300000,
      "start" : 0.000000,
      "word" : "bright"
    }, {
      "conf" : 1.000000,
      "end" : 0.720000,
      "start" : 0.330000,
      "word" : "bright"
    }, {
      "conf" : 1.000000,
      "end" : 1.950000,
      "start" : 1.710000,
      "word" : "bright"
    }],
  "text" : "bright bright bright"
}

header = json['result'][0].keys()
with open('results.csv', 'w', newline='') as file_:
    dict_writer = csv.DictWriter(file_, fieldnames=header)
    dict_writer.writeheader()
    dict_writer.writerows(json['result'])