如何从API请求将json文本字符串转换为pandas数据框架?

Question

这里是一个微不足道的问题，但我如何将我的api请求数据转换为pandas df

我只能通过执行print(response1.text)来查看数据我希望它是一个数据框架

url = "https://alpha-vantage.p.rapidapi.com/query"
querystring = {"interval":"1min","function":"TIME_SERIES_INTRADAY_EXTENDED","symbol":"GME","datatype":"json","slice":'year1month8'}
headers = {
'x-rapidapi-host': "alpha-vantage.p.rapidapi.com",
'x-rapidapi-key': "(omitted)"
}
response1 = requests.request("GET", url, headers=headers, params=querystring)

Answer 1

import requests
import pandas as pd    
url = "https://alpha-vantage.p.rapidapi.com/query"
querystring = {"interval":"1min","function":"TIME_SERIES_INTRADAY_EXTENDED","symbol":"GME","datatype":"json","slice":'year1month8'}
headers = {
'x-rapidapi-host': "alpha-vantage.p.rapidapi.com",
'x-rapidapi-key': "(omitted)"
}
response1 = requests.request("GET", url, headers=headers, params=querystring)
response1_json = response1.json()
df = pd.json_normalize(response1_json)
print(df)