擅长:python、mysql、java
<p>如果您愿意使用<code>pandas</code>:</p>
<pre><code>import pandas as pd
# setup
l = [['ID32', 'TRED', 'PLUS', '434', '0.34', '11.9', '4.8'],
['ID32', 'TRED', 'PLUS', '994', '0.84', '44.3', '1.11'],
['ID32', 'PROP', 'MINUS', '234', '0.56', '44.3', '1.11']]
df = pd.DataFrame(l)
print (df.assign(ratio=df[3].astype(float)/df[4].astype(float))
.sort_values([0,1,2,"ratio"], ascending=False)
.drop_duplicates([0,1,2], keep="first")
.sort_index()
.drop("ratio", 1)
.to_numpy())
</code></pre>
<p>结果:</p>
<pre><code>[['ID32' 'TRED' 'PLUS' '434' '0.34' '11.9' '4.8']
['ID32' 'PROP' 'MINUS' '234' '0.56' '44.3' '1.11']]
</code></pre>