从json转换到dataframe ?

Question

我正在尝试将JSON转换为dataframe。

API的JSON输出如下:

{
"code": 0,
"data": {
"list": [
{
"address": "abcdxyz",
"name": "Jack",
"shares": "396",
"amount": "490",
"active": true
},
{
"adress": "efghklm",
"name": "Mary",
"shares": "789",
"amount": "890",
"active": true
}
],
"page": 1,
"size": 5,
"maxPage": 1,
"totalSize": 2
}
}

当试

response = requests.get(url)
json_data = json.loads(response.text)
df = pd.DataFrame(json_data['data'])

其输出如下

list                   page  size  maxPage  totalSize
0  {'address': 'abcd...    1     5        1          2
1  {'address': 'efgh...    1     5        1          2

我怎样才能达到这样的输出?:

address    name  shares  amount active
0     abcdxyz    Jack    396    490    true
1     efghklm    Mary    789    890    true

我尝试了几件事，但我无法从列表中打印正确的方式。提前感谢

Answer 1

你只需要再深入一层就可以访问整个"数据";但是具体的"list":

response = requests.get(url)
json_data = json.loads(response.text)
df = pd.DataFrame(json_data['data']['list'])