我有这样一个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']])