Pandas在深度嵌套的JSON中创建字典

import pandas as pd

import json

# 假设我们有一个深度嵌套的JSON数据
json_data = {
    "name": "John",
    "age": 30,
    "address": {
        "street": "123 Main St",
        "city": "New York",
        "state": "NY"
    },
    "education": {
        "degree": "Bachelor",
        "major": "Computer Science",
        "university": "ABC University"
    }
}

# 将JSON数据转换为DataFrame
df = pd.json_normalize(json_data)

name = df['name'][0]
age = df['age'][0]
street = df['address.street'][0]
city = df['address.city'][0]
state = df['address.state'][0]
degree = df['education.degree'][0]
major = df['education.major'][0]
university = df['education.university'][0]