组合多个JSON文件，解析成CSV

[
  {"name": "Alice", "age": 30, "city": "New York"},
  {"name": "Bob", "age": 25, "city": "Los Angeles"}
]

[
  {"name": "Charlie", "age": 35, "city": "Chicago"},
  {"name": "David", "age": 40, "city": "Houston"}
]

import json
import csv

# 读取多个JSON文件
json_files = ['file1.json', 'file2.json']
all_data = []

for file in json_files:
    with open(file, 'r') as f:
        data = json.load(f)
        all_data.extend(data)

# 将合并后的数据写入CSV文件
csv_file = 'output.csv'
keys = all_data[0].keys()

with open(csv_file, 'w', newline='') as output_file:
    dict_writer = csv.DictWriter(output_file, keys)
    dict_writer.writeheader()
    dict_writer.writerows(all_data)

name,age,city
Alice,30,New York
Bob,25,Los Angeles
Charlie,35,Chicago
David,40,Houston