如何从api响应中获取json并将其扁平化为panda df

import requests
import json
import pandas as pd

# 发起API请求并获取响应
response = requests.get(api_url)

# 解析JSON响应
json_data = json.loads(response.text)

# 扁平化JSON数据
def flatten_json(data, prefix=''):
    flattened_data = {}
    for key, value in data.items():
        new_key = prefix + '_' + key if prefix else key
        if isinstance(value, dict):
            flattened_data.update(flatten_json(value, new_key))
        else:
            flattened_data[new_key] = value
    return flattened_data

flattened_json = flatten_json(json_data)

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

# 将扁平化的数据添加到DataFrame中
for key, value in flattened_json.items():
    df[key] = [value]

# 打印DataFrame
print(df)