我希望能够解析出 JSON 数组中的某个变量。我的脚本允许用户输入纬度/经度/SKU,因为 URL 是围绕这些参数构建的。然后,我想打印 JSON 数据,但我只关心一个变量:"AddressCityStateZip"。代码完美运行……当只有一个“变量集”时(我为缺乏术语表示歉意)但是,当结果返回多个商店时,我只得到返回的第一个值。例如,如果返回此 JSON:
[{"DisplayName":"Bridgewater Plaza","AddressStreet":"233 Broad ST","AddressCityStateZip":"Bridgewater, MA 02324","Phone":"5086970422","Latitude":41.996038893609,"Longitude":-70.9730786855837,"DistanceNumber":1.4091862149476761089787,"Distance":"1.4 Mi","StoreNumber":3776,"IsNewAvailable":false,"IsPreOwnedAvailable":true,"IsDigitalAvailable":true,"IsHopsEnabled":true},{"DisplayName":"Crescent Plaza","AddressStreet":"715 Crescent St","AddressCityStateZip":"Brockton, MA 02302","Phone":"5084275334","Latitude":42.0811691880226,"Longitude":-70.9903740137815,"DistanceNumber":5.62995717249044434817,"Distance":"5.6 Mi","StoreNumber":2225,"IsNewAvailable":false,"IsPreOwnedAvailable":true,"IsDigitalAvailable":true,"IsHopsEnabled":true},
我只会打印“Bridgewater, MA 02324”,而不是“Bridgewater, MA 02324”和“Brockton, MA 02302”。
这是我计算这个的代码的一部分,我做错了什么?
lat = raw_input("Enter the lat: ") #THIS IS WHERE WE NEED TO STORE VALUES OPENED FROM FILE: LATS.CSV (OR LATS.TXT ?)
lon = raw_input("Enter the lon: ") #THIS IS WHERE WE NEED TO STORE VALUES OPENED FROM FILE: LONS.CSV (OR LONS.TXT ?)
sku = raw_input("Enter the SKU: ") #THIS IS WHERE WE STORE USER INPUT FOR GAME SKU. ITS /NOT/ DERIVED FROM A FILE...YET.
url = "http://www.gamestop.com/PickUpAtStore/Stores/GetStoresByLocation?latitude=%s&longitude=-%s&newSku=&usedSku=%s&digitalSku=%s&displayMode=HOPS&displaySku=%s" % (lat, lon, sku, sku, sku)
print
print url
print
r = requests.get(url,)
mm = r.json()[0]["AddressCityStateZip"]
print mm
请您参考如下方法:
您只是通过使用 [0] 访问它来打印 json 数组中的第一个元素。相反,您可以遍历它:
for j in r.json():
print j["AddressCityStateZip"]
