Python-解析JSON D

2024-09-28 22:32:17 发布

您现在位置:Python中文网/ 问答频道 /正文

我试图解析一个JSON数据集,它看起来像这样:

{"data":[
    {
    "Rest":0,
    "Status":"The campaign is moved to the archive",
    "IsActive":"No",
    "StatusArchive":"Yes",
    "Login":"some_login",
    "ContextStrategyName":"Default",
    "CampaignID":1111111,
    "StatusShow":"No",
    "StartDate":"2013-01-20",
    "Sum":0,
    "StatusModerate":"Yes",
    "Clicks":0,
    "Shows":0,
    "ManagerName":"XYZ",
    "StatusActivating":"Yes",
    "StrategyName":"HighestPosition",
    "SumAvailableForTransfer":0,
    "AgencyName":null,
    "Name":"Campaign_01"
    },
    {
    "Rest":82.6200000000008,
    "Status":"Impressions will begin tomorrow at 10:00",
    "IsActive":"Yes",
    "StatusArchive":"No",
    "Login":"some_login",
    "ContextStrategyName":"Default",
    "CampaignID":2222222,
    "StatusShow":"Yes",
    "StartDate":"2013-01-28",
    "Sum":15998,"StatusModerate":"Yes",
    "Clicks":7571,
    "Shows":5535646,
    "ManagerName":"XYZ",
    "StatusActivating":"Yes",
    "StrategyName":"HighestPosition",
    "SumAvailableForTransfer":0,
    "AgencyName":null,
    "Name":"Campaign_02"
    }
    ]
}

假设这些数据集可以有很多。

我想遍历它们中的每一个并获取“Name”和“Campaign ID”参数。

到目前为止,我的代码看起来是这样的:

decoded_response = response.read().decode("UTF-8")
data = json.loads(decoded.response)

    for item in data[0]:
        for x in data[0][item] ...
            -> need a get name procedure
            -> need a get campaign_id procedure

可能挺直接的!我不擅长使用列表/词典:


Tags: 数据nonamerestdataresponsestatuslogin
1条回答
网友
1楼 · 发布于 2024-09-28 22:32:17

使用d[dict_key]d.get(dict_key, default)访问字典(以提供默认值):

jsonResponse=json.loads(decoded_response)
jsonData = jsonResponse["data"]
for item in jsonData:
    name = item.get("Name")
    campaignID = item.get("CampaignID")

我建议你读点关于dictionaries的东西。

相关问题 更多 >