将JSON响应转换为pandas数据帧

import pandas as pd
import json

# 假设JSON响应存储在response变量中
response = '''
{
  "data": [
    {
      "name": "Alice",
      "age": 25,
      "city": "New York"
    },
    {
      "name": "Bob",
      "age": 30,
      "city": "London"
    },
    {
      "name": "Charlie",
      "age": 35,
      "city": "Tokyo"
    }
  ]
}
'''

# 解析JSON为Python字典
data_dict = json.loads(response)

# 将字典转换为数据帧
df = pd.DataFrame(data_dict['data'])

# 打印数据帧
print(df)

      name  age      city
0    Alice   25  New York
1      Bob   30    London
2  Charlie   35     Tokyo