擅长:python、mysql、java
<p>有一种方法。在</p>
<pre><code>df['CentralFlag'] = (df['source'] == 'Central')
df = df.sort_values('CentralFlag', ascending=False)\
.drop_duplicates(['vend_name', 'quantity'])\
.drop('CentralFlag', 1)
# vend_number vend_name quantity source
# 0 CHARLS Charlie&Associates $5,700.00 Central
# 4 HUGHES Hughinos $3,800.00 Central
# 6 FERNAS FernandaIndustries $3,500.00 South
# 8 FERNAS FernandaIndustries $3,000.00 West
</code></pre>
<p><strong>说明</strong></p>
<ul>
<li>创建一个标志列,按此降序排序,这样就可以优先使用中心列。在</li>
<li>按<code>vend_name</code>和<code>quantity</code>排序,然后删除标志列。在</li>
</ul>