Json parsing Python



data.json content

{
  "response": {
    "numFound": 1,
    "data_block": [
      {
        "Number": "11097",
        "ID": -61000,
        "Version": "18",
        "Sequence": [
          "1",
          "2",
          "3"
        ],
        "Status": [
          "Booked",
          "Canceled",
          "Canceled"
        ],
        "Name": "abc",
        "EmailAddress": "abc@test.com"
      }
    ]
  }
}

我希望获得以下格式的值

编号~序列~状态

11097~1|2|3~预订|已取消|取消

在下面尝试,但得到

密钥错误:"data_block">

import json
from pprint import pprint
data = json.load(open('data.json'))
pprint(data)
data["data_block"][0]["Number"]
data["response"]["data_block"][0]["Number"]

尝试上面的行

最新更新