读取Json文件，提取数据并生成CSV文件

import json
import csv

def extract_data(json_file):
    with open(json_file, 'r') as file:
        data = json.load(file)
    
    # 提取数据
    extracted_data = data['key1']['key2']  # 根据实际的Json结构提取数据
    
    return extracted_data

def generate_csv(data, csv_file):
    with open(csv_file, 'w', newline='') as file:
        writer = csv.writer(file)
        
        # 写入表头
        writer.writerow(['Column1', 'Column2', 'Column3'])  # 根据实际的字段名定义表头
        
        # 写入数据
        for item in data:
            writer.writerow([item['field1'], item['field2'], item['field3']])  # 根据实际的字段名写入数据

# 调用函数进行数据提取和CSV生成
json_file = 'data.json'
csv_file = 'output.csv'

extracted_data = extract_data(json_file)
generate_csv(extracted_data, csv_file)