擅长:python、mysql、java
<p>如果你有大量的数据,就用1.数据帧它的清洁阅读和维护。你知道吗</p>
<pre><code>import pandas as pd
my_list = [
{'score': '192', 'imageId': '6184de26-e11d-4a7e-9c44-a1af8012d8d0', 'label': 'Door'},
{'score': '61', 'imageId': 'fffffe26-e11d-4a7e-9c44-a1af8012d8d0', 'label': 'misc'},
{'score': '761', 'imageId': '6184de26-e11d-4a7e-9c44-a1af8012d8d0', 'label': 'Sliding Door'},
{'score': '45', 'imageId': '6184de26-e11d-4a7e-9c44-a1af8012d8d0', 'label': 'Door'},
]
# create dataframe
df = pd.DataFrame(my_list)
# your score is string! convert it to int
df['score'] = df['score'].astype('int')
# sort values
df = df.sort_values(by=['imageId', 'score'], ascending=False)
# drop duplicates
df = df.drop_duplicates('imageId', keep='first')
imageId label score
1 fffffe26-e11d-4a7e-9c44-a1af8012d8d0 misc 61
2 6184de26-e11d-4a7e-9c44-a1af8012d8d0 Sliding Door 761
</code></pre>