递归地将JSON切片为Dataframe列

import pandas as pd

def json_to_dataframe(json_data, prefix=''):
    if isinstance(json_data, dict):
        for key, value in json_data.items():
            new_prefix = prefix + '_' + key if prefix else key
            json_to_dataframe(value, new_prefix)
    elif isinstance(json_data, list):
        for i, item in enumerate(json_data):
            new_prefix = prefix + '_' + str(i) if prefix else str(i)
            json_to_dataframe(item, new_prefix)
    else:
        # 将解析后的值添加到Dataframe的列中
        dataframe[new_prefix] = json_data

# 创建一个空的Dataframe
dataframe = pd.DataFrame()

# 假设json_data是包含嵌套结构的JSON数据
json_data = {
    "name": "John",
    "age": 30,
    "address": {
        "street": "123 Main St",
        "city": "New York"
    },
    "hobbies": ["reading", "painting"]
}

# 调用递归函数将JSON切片为Dataframe列
json_to_dataframe(json_data)

# 打印结果
print(dataframe)

   name  age address_street address_city hobbies_0 hobbies_1
0  John   30    123 Main St     New York   reading  painting