python提取json数据索引必须是整数_分析JSON时python pandas TypeError:字符串索引必须是整数...

JSON文件中的记录如下所示(请注意“营养素”是什么样子)：{

"id": 21441,

"description": "KENTUCKY FRIED CHICKEN, Fried Chicken, EXTRA CRISPY,

Wing, meat and skin with breading",

"tags": ["KFC"],

"manufacturer": "Kentucky Fried Chicken",

"group": "Fast Foods",

"portions": [

{

"amount": 1,

"unit": "wing, with skin",

"grams": 68.0

},

...

],

"nutrients": [

{

"value": 20.8,

"units": "g",

"description": "Protein",

"group": "Composition"

},

{'description': 'Total lipid (fat)',

'group': 'Composition',

'units': 'g',

'value': 29.2}

...

]

}

以下是练习*一书中的代码。它包括一些争吵，并将每种食物的营养成分汇集到一张大桌子上：

^{pr2}$

但是，我得到了以下错误，我不知道为什么：TypeError Traceback (most recent call last)

in ()

1 for rec in db:

----> 2 fnuts = pd.DataFrame(rec["nutrients"])

3 fnuts["id"] = rec["id"]

4 nutrients.append(fnuts)

5

TypeError: string indices must be integers