从JSON文件刮擦数据

Question

我正在尝试从JSON文件刮擦 name ，但它们向我显示字符串索引必须是整数，如您所见 JSON文件：

 "prodBean": {
            "subProdTerms": null,
            "friendlyUrl": "/brakes-wheel-end/brake-drums-rotors/brake-drum/otr-brake-drum-otr1601b",
            "name": "OTR 16.5 x 7 Brake Drum, Balanced",
            "showSubscriptionSelection": false,
            "UnitOfMeasure": "EA",
            "qtyPerUnit": 1.0,
            "sequence": 2,
            "availMsg": null,
            "ProductStatus": "Released",
            "ProductType": "Product",
            "sku": "OTR-OTR1601B",
            "id": "a8G1W000000Y7DfUAK",
            "showNewSubscriptionSelection": false,
            "savings": 405.49,
            "basePrice": 405.492,
            "price": 0.0,
            "ECrossReferencesS"

代码

import json

with open("test.json","r") as file:
    temp=json.load(file)

for item in temp:
    title=item['prodBean']['name']
    print(title)

Answer 1

在您的情况下，加载语句返回dict。当您用单个参数迭代dict时，您只会得到键：

>>> for item in temp:
...     print(item)
...
prodBean

您需要使用.items（）迭代dict，那么您将可以访问数据：

>>> for k, v in temp.items():
...     item = v['name']
...     print(item)
...
OTR 16.5 x 7 Brake Drum, Balanced