擅长:python、mysql、java
<p>您可以<code>concat</code>将df放在一起,按数量排序,然后删除重复项</p>
<pre><code>dfResult = pd.concat([dfA,dfB]).sort_values(by='amout',ascending = False).drop_duplicates(subset=['client_id','date'],keep='first').reset_index().sort_values(by=['client id','date'],ascending = (True,False))
</code></pre>