我想使用id_type_sale和sale_type_description创建一个数组(查看输出中的object_sale_types),保留键email,date,order_id,store,但不要重复(假设它是相同的数据)。
输入值
{
"105": [
{
"id_type_sale": 2,
"email" : null,
"date" : "2016-05-18",
"order_id": 105,
"sale_type_description": "Coffee shop",
"store": "Ezio store"
},
{
"id_type_sale": 5,
"order_id": 105,
"email" : null,
"date" : "2016-05-18",
"sale_type_description": "Book shop",
"store": "Ezio store"
}
],
"106": [
{
"id_type_sale": 3,
"email" : null,
"date" : "2016-05-19",
"order_id": 106,
"sale_type_description": "Food",
"store": "Ezio store"
},
{
"id_type_sale": 8,
"order_id": 106,
"email" : null,
"date" : "2016-05-19",
"sale_type_description": "Articles",
"store": "Ezio store"
}]}
预期输出
{
"105":[
{
"email":null,
"date":"2016-05-18",
"order_id":105,
"store":"Ezio store",
"object_sale_types":[
{
"id_type_sale":2,
"sale_type_description":"Coffee shop"
},
{
"id_type_sale":5,
"sale_type_description":"Book shop"
}
]
}
],
"106":[
{
"email":null,
"date":"2016-05-19",
"order_id":106,
"store":"Ezio store",
"object_sale_types":[
{
"id_type_sale":3,
"sale_type_description":"Food"
},
{
"id_type_sale":8,
"sale_type_description":"Articles"
}
]
}
]}
我能怎么做?有什么更好的方法?我想使用python
首先,您需要使用加载JSON字符串json.loads
,然后可以遍历(key, value)
字典中的每一对,value
并使用每个对象的公共值和id_sale_type
andsale_type_description
值数组构建新的字典。然后,您可以使用来输出新的JSON json.dumps
:
d = json.loads(j)
r = {}
for key, value in d.items():
r[key] = { k : value[0][k] for k in ['email', 'date', 'order_id', 'store'] }
r[key]['object_sales_types'] = [ { 'id_type_sale' : s['id_type_sale'], 'sale_type_description' : s['sale_type_description'] } for s in value]
print(json.dumps(r, indent=4))
输出:
{
"105": {
"email": null,
"date": "2016-05-18",
"order_id": 105,
"store": "Ezio store",
"object_sales_types": [
{
"id_type_sale": 2,
"sale_type_description": "Coffee shop"
},
{
"id_type_sale": 5,
"sale_type_description": "Book shop"
}
]
},
"106": {
"email": null,
"date": "2016-05-19",
"order_id": 106,
"store": "Ezio store",
"object_sales_types": [
{
"id_type_sale": 3,
"sale_type_description": "Food"
},
{
"id_type_sale": 8,
"sale_type_description": "Articles"
}
]
}
}
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句