擅长:python、mysql、java
<p>您可以使用<code>pandas</code>库执行以下操作:</p>
<p>安装熊猫,如:</p>
<pre><code>pip install pandas
</code></pre>
<p>您的代码是:</p>
<pre><code>In [2271]: import pandas as pd
In [2272]: l = [["Edibles", "Fruit", "Apple", 3],
...: ["Edibles", "Fruit", "Grapes", 8],
...: ["Edible", "Candy", "Hershey", 4],
...: ["Edible", "Candy", "Snickers", 6],
...: ["NonEdible", "Bikes", "Yamaha", 5],
...: ["NonEdible", "Bikes", "Suzuki", 7],
...: ["NonEdible", "Cars", "Kia", 8],
...: ["NonEdible", "Cars", "Toyota", 9]]
In [2275]: df = pd.DataFrame(l, columns=['category','type','item','score'])
In [2284]: df.groupby(['category','type'], as_index=False).agg(max).values.tolist()
Out[2284]:
[['Edible', 'Candy', 'Snickers', 6],
['Edibles', 'Fruit', 'Grapes', 8],
['NonEdible', 'Bikes', 'Yamaha', 7],
['NonEdible', 'Cars', 'Toyota', 9]]
</code></pre>