json文件中的单变量嵌套列表，转换为数据帧行

import json
import csv

# 读取JSON文件
with open('data.json', 'r') as file:
    json_data = json.load(file)

# 获取嵌套列表
nested_list = json_data['nested_list']

# 转换为数据帧行
rows = []
for item in nested_list:
    row = [item['variable1'], item['variable2'], item['variable3']]
    rows.append(row)

# 存储数据帧行到CSV文件
with open('output.csv', 'w', newline='') as file:
    writer = csv.writer(file)
    writer.writerows(rows)

{
  "nested_list": [
    {
      "variable1": "value1",
      "variable2": "value2",
      "variable3": "value3"
    },
    {
      "variable1": "value4",
      "variable2": "value5",
      "variable3": "value6"
    },
    ...
  ]
}