如何以表格的形式打印嵌套的JSON数组数据？

import json
from tabulate import tabulate

# 示例嵌套JSON数据
nested_json = [
    {
        "id": 1,
        "name": "Alice",
        "scores": [85, 90, 88],
        "details": {
            "age": 24,
            "city": "New York"
        }
    },
    {
        "id": 2,
        "name": "Bob",
        "scores": [78, 92, 80],
        "details": {
            "age": 27,
            "city": "Los Angeles"
        }
    }
]

# 函数：将嵌套JSON转换为扁平化的列表
def flatten_json(y):
    out = {}

    def flatten(x, name=''):
        if type(x) is dict:
            for a in x:
                flatten(x[a], name + a + '.')
        elif type(x) is list:
            i = 0
            for a in x:
                flatten(a, name + str(i) + '.')
                i += 1
        else:
            out[name[:-1]] = x

    flatten(y)
    return out

# 扁平化所有JSON对象
flattened_data = [flatten_json(item) for item in nested_json]

# 获取所有列名
headers = set().union(*(d.keys() for d in flattened_data))

# 打印表格
print(tabulate(flattened_data, headers=headers, tablefmt="grid"))