如何迭代json输出并在dataframe中得到想要的结果？

import pandas as pd
import json

# 读取JSON数据
json_data = '''
[
    {
        "name": "John",
        "age": 30,
        "city": "New York"
    },
    {
        "name": "Alice",
        "age": 25,
        "city": "San Francisco"
    },
    {
        "name": "Bob",
        "age": 35,
        "city": "Chicago"
    }
]
'''

# 解析JSON数据
data = json.loads(json_data)

# 创建空的DataFrame对象
df = pd.DataFrame()

# 迭代JSON数据并提取所需的数据
for item in data:
    name = item['name']
    age = item['age']
    city = item['city']
    
    # 将数据添加到DataFrame中
    df = df.append({'Name': name, 'Age': age, 'City': city}, ignore_index=True)

# 打印DataFrame
print(df)

    Name  Age           City
0   John   30       New York
1  Alice   25  San Francisco
2    Bob   35        Chicago