Py学习  »  Python

如何在python中从json中提取多个值

user1471980 • 3 年前 • 1725 次点击  

我有这样一个JSON文件:

print(resp)
dataList = []
{
  "totalCount": 9812,
  "pageSize": 50,
  "nextPageKey": "12345",
  "problems": [
    {
      "problemId": "1234",
      "displayId": "test1",
      "title": "host memory saturation",
      "impactLevel": "INFRASTRUCTURE",
      "severityLevel": "RESOURCE_CONTENTION",
      "status": "OPEN"
     }
     ]
}

我需要提取“title”、“impactLevel”和“severityLevel”,并创建一个数据框架:

我试过:

dataList.append([resp['problems'][0]['title']['impactLevel']['severityLevel']])
hyperEntitydf = pd.DataFrame(dataList, columns=['Alert','Type','Severity'])
hyperEntitydf=hyperEntitydf.drop_duplicates()
print(hyperEntitydf.head())

在这一行:

 dataList.append([resp['problems'][0]['title']['impactLevel']['severityLevel']])

我得到了这个错误:

TypeError: string indices must be integers

一次调用可以提取多个字段吗?

dataList.append([resp['problems'][0]['title']['impactLevel']['severityLevel']])
Python社区是高质量的Python/Django开发社区
本文地址:http://www.python88.com/topic/128459
 
1725 次点击  
文章 [ 2 ]  |  最新文章 3 年前