如何将更复杂的JSON转换为CSV？

import json
import csv

def convert_json_to_csv(json_data):
    # 1. 解析JSON数据
    data = json.loads(json_data)

    # 2. 遍历JSON数据
    rows = []
    process_json(data, rows)

    # 3. 构建CSV表头
    headers = list(set([key for row in rows for key in row.keys()]))

    # 4. 构建CSV数据行
    csv_rows = [headers]
    for row in rows:
        csv_row = [row.get(header, "") for header in headers]
        csv_rows.append(csv_row)

    # 5. 写入CSV文件
    with open('output.csv', 'w', newline='') as file:
        writer = csv.writer(file)
        writer.writerows(csv_rows)

def process_json(data, rows, current_row=None, current_path=""):
    if isinstance(data, dict):
        for key, value in data.items():
            new_path = f"{current_path}.{key}" if current_path else key
            process_json(value, rows, current_row, new_path)
    elif isinstance(data, list):
        for index, item in enumerate(data):
            new_row = current_row.copy() if current_row else {}
            new_path = f"{current_path}[{index}]" if current_path else f"[{index}]"
            process_json(item, rows, new_row, new_path)
    else:
        if current_row is not None:
            current_row[current_path] = data
        else:
            rows.append({current_path: data})

# 示例JSON数据
json_data = """
{
  "employees": [
    {
      "firstName": "John",
      "lastName": "Doe",
      "email": "john@example.com",
      "phoneNumbers": [
        {
          "type": "home",
          "number": "1234567890"
        },
        {
          "type": "work",
          "number": "0987654321"
        }
      ]
    },
    {
      "firstName": "Jane",
      "lastName": "Smith",
      "email": "jane@example.com",
      "phoneNumbers": [
        {
          "type": "home",
          "number": "9876543210"
        },
        {
          "type": "work",
          "number": "0123456789"
        }
      ]
    }
  ]
}
"""

convert_json_to_csv(json_data)

firstName,lastName,email,phoneNumbers[0].type,phoneNumbers[0].number,phoneNumbers[1].type,phoneNumbers[1].number
John,Doe,john@example.com,home,1234567890,work,0987654321
Jane,Smith,jane@example.com,home,9876543210,work,0123456789