Python - 解析JSON数据集 [英] Python - Parsing JSON Data Set
本文介绍了Python - 解析JSON数据集的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在尝试解析出一个如下所示的JSON数据集:
{data:[
{
休息:0,
状态:广告系列被移动到存档,
IsActive:否,
StatusArchive :是,
登录:some_login,
ContextStrategyName:默认,
CampaignID:1111111,
StatusShow:否 ,
StartDate:2013-01-20,
Sum:0,
StatusModerate:是,
点击:0,
显示:0,
ManagerName:XYZ,
StatusActivating:是,
StrategyName:HighestPosition,
SumAvailableForTransfer:0,
AgencyName:null,
名称:Campaign_01
},
{
休息:82.6200000000008,
状态:印象将从明天开始在10:00,
IsActive:是,
StatusArchive:否,
登录:some_login ,
ContextStrategyName:默认,
CampaignID:2222222,
StatusShow:是,
StartDate:2013-01-28,
Sum:15998,StatusModerate:是,
点击:7571,
显示:5535646,
ManagerName:XYZ,
StatusActivating:是,
策略名称:最高位置 ,
SumAvailableForTransfer:0,
AgencyName:null,
名称:Campaign_02
}
]
}
假设可以有很多这些数据集。
到目前为止,我的代码看起来像这样,我想要遍历每一个人,并获取名称和活动ID参数。 :
decoded_response = response.read()。decode(UTF-8)
data = json.loads (decode.response)
数据[0]中的项目:
为数据[0] [项目] ...
- >需要一个获取名称程序
- >需要获得campaign_id程序
可能非常简单!我对列表/词典不好:(
解决方案
使用 d [dict_key] code>或
d.get(dict_key,default)
(提供默认值):
jsonResponse = json.loads(decoded_response)
jsonData = jsonResponse [data]
for jsonData中的项目:
name = item.get(Name )
campaignID = item.get(CampaignID)
我建议您阅读有关词典。
I am trying to parse a JSON data set that looks something like this:
{"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"
}
]
}
Lets assume that there can be many of these data sets.
I would like to iterate through each one of them and grab the "Name" and the "Campaign ID" parameter.
So far my code looks something like this:
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
Probably quite straight forward! I am not good with lists/dictionaries :(
解决方案
Access dictionaries with d[dict_key]
or d.get(dict_key, default)
(to provide default value):
jsonResponse=json.loads(decoded_response)
jsonData = jsonResponse["data"]
for item in jsonData:
name = item.get("Name")
campaignID = item.get("CampaignID")
I suggest you read something about dictionaries.
这篇关于Python - 解析JSON数据集的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文