我有两个JSON
字符串作为示例:
json_1 = [
{
"breadth": 48.04,
"vessel_id": 1,
"vessel_name": "SHIP-01",
"vessel_type": "Crude Oil Tanker",
"year_built": 2012
},
{
"breadth": 42,
"vessel_id": 2,
"vessel_name": "SHIP-02",
"vessel_type": "Crude Oil Tanker",
"year_built": 2016
}
]
json_2 = [
{
"Ballast_miles": 43575.8,
"Ballast_miles_pct": 36.1,
"org_id": 1,
"port_days": 383.5,
"sea_days": 414.9,
"total_days": 798.4,
"vessel_id": 1
},
{
"Ballast_miles": 21642.7,
"Ballast_miles_pct": 29.8,
"org_id": 1,
"port_days": 325.7,
"sea_days": 259.8,
"total_days": 585.5,
"vessel_id": 2
}
]
我想结合这两个基于vessel_id
的JSON。你知道吗
我的输出格式应该如下所示:
[{ vesselId: 1,
json1:{},
json2:{}
},
{ vesselId: 2,
json1:{},
json2:{}
}]
到目前为止我试过的是:
data = {'First_Json': json_1, 'Second_Json': json_2}
json.dumps(data)
但是这完全结合在一起,而不需要基于vessel_id
进行检查。你知道吗
像这样的?你知道吗
输出:
如果要删除冗余的
vessel_id
,请尝试在每个dict上使用带有del
命令的for
循环相关问题 更多 >
编程相关推荐