我有这样的数据
data = [{'vesselId': '1',"vesselName": "ALPHA 01",'weatherStatus': 'Good','ballastFlag':'B','milesPerMT_min': 'cycling','milesPerMT_max': 3,'milesPerMT_avg':6,"fuelPerMilesPerCargo": nan,'milesPerMT_avg': 3,'speedRange':'10-15'},
{'vesselId': '1',"vesselName": "ALPHA 01",'weatherStatus': 'Good','ballastFlag':'L','milesPerMT_min': 'cycling','milesPerMT_max': 45,"fuelPerMilesPerCargo": nan,'milesPerMT_avg': 3,'speedRange':'5-10'},
{'vesselId': '1',"vesselName": "ALPHA 01", 'weatherStatus': 'ROUGH','ballastFlag':'L','milesPerMT_min': 'reading', 'milesPerMT_max': 3.0,"fuelPerMilesPerCargo": nan,'milesPerMT_avg': 3,'speedRange':'10-15'},
{'vesselId': '1',"vesselName": "ALPHA 01", 'weatherStatus': 'ROUGH','ballastFlag':'L','milesPerMT_min': 'reading', 'milesPerMT_max': 3.0,"fuelPerMilesPerCargo": nan,'milesPerMT_avg': 3,'speedRange':'15-20'}]
我编写了将数据转换为json格式的代码:
new_data = []
not_found = True
for item in data:
for vesselId in new_data:
not_found = True
if item['vesselId'] == vesselId['vesselId']:
not_found = False
for weatherStatus in vesselId['Fuel_Performance']:
if item['weatherStatus'] == weatherStatus['weatherStatus'] :
weatherStatus['milesPerMT'].append({'milesPerMT_min':item['milesPerMT_min'], 'milesPerMT_max':item['milesPerMT_max'],'milesPerMT_avg':item['milesPerMT_avg']})
else:
vesselId['Fuel_Performance'].append({'weatherStatus':item['weatherStatus'],'ballastFlag':item['ballastFlag'], 'milesPerMT':[{'milesPerMT_min':item['milesPerMT_min'], 'milesPerMT_max':item['milesPerMT_max'],'milesPerMT_avg':item['milesPerMT_avg'],'Speed':item['speedRange']}]})
break
if not_found:
new_data.append({'vesselId':item['vesselId'],'vesselName':item['vesselName'] , 'Fuel_Performance':[{'weatherStatus':item['weatherStatus'], \
'ballastFlag':item['ballastFlag'],'milesPerMT':[{'milesPerMT_min':item['milesPerMT_min'], 'milesPerMT_max':item['milesPerMT_max'],'milesPerMT_avg':item['milesPerMT_avg']}],'fuelPerMilesPerCargo': item['fuelPerMilesPerCargo'],'Speed':item['speedRange']}]})
我得到的输出是这样的
[{'Fuel_Performance': [{'Speed': '10-15',
'ballastFlag': 'B',
'fuelPerMilesPerCargo': nan,
'milesPerMT': [{'milesPerMT_avg': 6,
'milesPerMT_max': 3,
'milesPerMT_min': 8},
{'milesPerMT_avg': 3,
'milesPerMT_max': 45,
'milesPerMT_min': 9}],
'weatherStatus': 'Good'},
{'ballastFlag': 'L',
'milesPerMT': [{'Speed': '10-15',
'milesPerMT_avg': 3,
'milesPerMT_max': 3.0,
'milesPerMT_min': 10},
{'milesPerMT_avg': 3,
'milesPerMT_max': 3.0,
'milesPerMT_min': 10},
{'milesPerMT_avg': 3,
'milesPerMT_max': 3.0,
'milesPerMT_min': 11}],
'weatherStatus': 'ROUGH'},
{'ballastFlag': 'L',
'milesPerMT': [{'Speed': '15-20',
'milesPerMT_avg': 3,
'milesPerMT_max': 3.0,
'milesPerMT_min': 11},
{'milesPerMT_avg': 3,
'milesPerMT_max': 3.0,
'milesPerMT_min': 11}],
'weatherStatus': 'ROUGH'}],
'vesselId': '1',
'vesselName': 'ALPHA 01'}]
我想要的方式如下所示
[
{
"vesselId": 1,
"vesselName": "ALPHA 01",
"fuelPerformance": {
"Good": {
"B": [
{
"speed": "10 - 15",
"milesPerMT": {
"Min": 8,
"Max": 3,
"Avg": 6
},
"fuelPerMilesPerCargo": nan
}
],
"L": [
{
"speed": "5 - 10",
"milesPerMT": {
"Min": 9,
"Max": 45,
"Avg": 3
},
"fuelPerMilesPerCargo": nan
}
]
},
"Rough": {
"L": [
{
"speed": "10 - 15",
"milesPerMT": {
"Min": 10,
"Max": 3,
"Avg": 3
},
"fuelPerMilesPerCargo": nan
},
{
"speed": "15 - 20",
"milesPerMT": {
"Min": 11,
"Max": 3,
"Avg": 3
},
"fuelPerMilesPerCargo": nan
}
]
}
}
}
]
我试图根据下面的逻辑对值进行分组
如果天气状况为“良好”,压载标志可以为“B”或“L” 将B和L的所有键和值分组。同样,当天气状况为“恶劣”时
在我最初的输出中,我无法将三个东西(速度、里程、燃油许可证)放入安定器标志内
在我目前的代码中,我不知道如何根据天气状况和压舱物标志对它们进行分组
我是这样做的:
输出:
对于通过
new_data
循环并检查是否存在某些元素的问题,我采取了维护一个小型元目录的方法,该目录保存vessleId、weatherStatus和;民谣旗帜如下python脚本:
返回以下输出:
相关问题 更多 >
编程相关推荐