在Python中从元数据中抓取数据

Question

我需要从以下语句中获取数据：

{"info":{"symbol":"NIFTY","companyName":"NIFTY","identifier":"none","activeSeries":[],"debtSeries":[],"isFNOSec":true,"isCASec":false,"isSLBSec":false,"isDebtSec":false,"isSuspended":false},"filter":{"expiryDate":"Invalid date","strikePrice":""},"underlyingValue":11655.25,"vfq":7501,"fut_timestamp":"28-Aug-2020 15:29:23","opt_timestamp":"28-Aug-2020 15:29:25","stocks":[{"metadata":{"instrumentType":"Index Options","expiryDate":"03-Sep-2020","optionType":"Call","strikePrice":11700,"identifier":"OPTIDXNIFTY03-09-2020CE11700.00","openPrice":50,"highPrice":85.4,"lowPrice":42.75,"closePrice":0,"prevClose":43.1,"lastPrice":66.9,"change":23.800000000000004,"pChange":55.220417633410676,"numberOfContractsTraded":507931,"totalTurnover":23603.55},"underlyingValue":11655.25,"volumeFreezeQuantity":7501,"marketDeptOrderBook":{"totalBuyQuantity":514575,"totalSellQuantity":236475,"bid":[{"price":66.85,"quantity":75},{"price":66.8,"quantity":75},{"price":66.6,"quantity":1425},{"price":66.55,"quantity":900},{"price":66.5,"quantity":1875}],"ask":[{"price":66.9,"quantity":225},{"price":66.95,"quantity":375},{"price":67,"quantity":2100},{"price":67.05,"quantity":1950},{"price":67.1,"quantity":975}],"carryOfCost":{"price":{"bestBuy":66.85,"bestSell":66.9,"lastPrice":66.9},"carry":{"bestBuy":-31396.45257775595,"bestSell":-31391.904290939718,"lastPrice":-31391.904290939718}},

Answer 1

这里的数据看起来像JSON数据

考虑如下：

parsed = json.loads("INSERT JSON DATA HERE")

或者，如果将JSON数据存储在文件中，则可以使用以下方法：

import json
with open('jsonDataFile.json', 'r') as data:
    parsed = json.load(data)

下面是一个很好的资源，可以帮助您理解JSON数据以及如何在Python中使用它：Using JSON in Python