展平嵌套的JSON并使用pandas连接到dataframe

import pandas as pd
import json

def flatten_json(json_data, prefix=''):
    flattened_data = {}
    for key, value in json_data.items():
        new_key = prefix + '_' + key if prefix else key
        if isinstance(value, dict):
            flattened_data.update(flatten_json(value, new_key))
        else:
            flattened_data[new_key] = value
    return flattened_data

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

# 展平嵌套的JSON数据
flattened_data = flatten_json(json_data)

# 将展平后的数据连接到dataframe
df = pd.DataFrame([flattened_data])

# 打印dataframe
print(df)

  name  age address_street address_city address_state        hobbies_0  hobbies_1
0  John   30    123 Main St     New York            NY          reading  traveling

import pandas as pd
import json

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

# 使用json_normalize函数展平嵌套的JSON数据
df = pd.json_normalize(json_data)

# 打印dataframe
print(df)