【python】-【转换】JOSN转CSV

import json
import csv

# JSON文件路径
json_data = r'F:FlightSummary.json'

# 读取JSON数据
with open(json_data, 'r', encoding='utf-8') as file:
    data = json.load(file)

# 检查数据是否为字典
if isinstance(data, dict):
    # 定义CSV文件的表头
    headers = ["FlightNumber", "Origin", "Destination"]

    # CSV文件路径
    csv_file = r'FlightSummary.csv'

    # 写入CSV文件
    with open(csv_file, 'w', newline='', encoding='utf-8') as file:
        writer = csv.writer(file)
        
        # 写入表头
        writer.writerow(headers)
        
        # 写入数据行
        for flight_number, flight_info in data.items():
            row = [flight_number, flight_info["origin"], flight_info["destination"]]
            writer.writerow(row)

    print(f"CSV文件已成功生成：{csv_file}")
else:
    print("JSON数据格式不符合预期，无法转换为CSV。")