使用python将嵌套的json文件更改为数据框

import json
import pandas as pd

def flatten_json(json_obj, parent_key='', sep='_'):
    flattened_dict = {}
    if isinstance(json_obj, dict):
        for key, value in json_obj.items():
            new_key = parent_key + sep + key if parent_key else key
            flattened_dict.update(flatten_json(value, new_key, sep))
    elif isinstance(json_obj, list):
        for i, value in enumerate(json_obj):
            new_key = parent_key + sep + str(i) if parent_key else str(i)
            flattened_dict.update(flatten_json(value, new_key, sep))
    else:
        flattened_dict[parent_key] = json_obj
    return flattened_dict

# 读取JSON文件
with open('data.json') as file:
    json_data = json.load(file)

# 将嵌套的JSON转换为扁平的字典
flattened_data = flatten_json(json_data)

# 将字典转换为数据框
df = pd.DataFrame([flattened_data])

# 打印数据框
print(df)