使用Pandas展平包含列表值的嵌套JSON

import pandas as pd
import json

# 嵌套的JSON数据
nested_json = {
    "name": "John",
    "age": 30,
    "skills": [
        {"name": "Python", "level": "Advanced"},
        {"name": "Java", "level": "Intermediate"},
        {"name": "SQL", "level": "Intermediate"}
    ]
}

# 将JSON数据转换为DataFrame
df = pd.json_normalize(nested_json, record_path='skills', meta=['name', 'age'])

# 打印展平后的DataFrame
print(df)

     name  age      name         level
0    John   30    Python     Advanced
1    John   30      Java  Intermediate
2    John   30       SQL  Intermediate