如何使用来自JSON输出的数据创建数据帧

{
    "name": ["Alice", "Bob", "Charlie"],
    "age": [24, 27, 22],
    "city": ["New York", "Los Angeles", "Chicago"]
}

import pandas as pd

# JSON数据
json_data = {
    "name": ["Alice", "Bob", "Charlie"],
    "age": [24, 27, 22],
    "city": ["New York", "Los Angeles", "Chicago"]
}

# 创建DataFrame
df = pd.DataFrame(json_data)

print(df)

      name  age         city
0    Alice   24     New York
1      Bob   27  Los Angeles
2  Charlie   22      Chicago

import json
import pandas as pd

# 假设json_str是从API获取的JSON字符串
json_str = '{"people": [{"name": "Alice", "age": 24, "city": "New York"}, {"name": "Bob", "age": 27, "city": "Los Angeles"}]}'

try:
    # 解析JSON字符串
    data = json.loads(json_str)
    
    # 使用json_normalize处理嵌套的JSON数据
    df = pd.json_normalize(data, record_path=['people'])
    
    print(df)
except json.JSONDecodeError as e:
    print(f"JSON解析错误: {e}")