回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<div>
</div>
<p>我有这样的数据</p>
<pre><code>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'}]
</code></pre>
<p>我编写了将数据转换为json格式的代码:</p>
<pre><code>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']}]})
</code></pre>
<p>我得到的输出是这样的</p>
<pre><code>[{'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'}]
</code></pre>
<p>
我想要的方式如下所示</p>
<pre><code> [
{
"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
}
]
}
}
}
]
</code></pre>
<p>我试图根据下面的逻辑对值进行分组</p>
<p>如果天气状况为“良好”,压载标志可以为“B”或“L”
将B和L的所有键和值分组。同样,当天气状况为“恶劣”时</p>
<p>在我最初的输出中,我无法将三个东西(速度、里程、燃油许可证)放入安定器标志内</p>
<p>在我目前的代码中,我不知道如何根据天气状况和压舱物标志对它们进行分组</p>