擅长:python、mysql、java
<p>您可以按<code>drop_duplicates</code>之前的银行帐户进行排序,将重复项放在<code>NaN</code>最后:</p>
<pre class="lang-py prettyprint-override"><code>uniq_indx = (df.dropna(subset=['firstname', 'lastname', 'email'])
.applymap(lambda s:s.lower() if type(s) == str else s)
.applymap(lambda x: x.replace(" ", "") if type(x)==str else x)
.sort_values(by='bank') # here we sort values by bank column
.drop_duplicates(subset=['firstname', 'lastname', 'email'], keep='first')).index
</code></pre>