擅长:python、mysql、java
<p>如果要删除重复项,请使用以下代码:<code>pd.DataFrame.drop_duplicates</code></p>
<pre><code>import pandas as pd
df = pd.DataFrame({'col_1':['A','B','A','B','C'], 'col_2':[3,4,3,5,6], 'col_3':[0,0.1,0.2,0.3,0.4]})
print(df)
df.drop_duplicates(['col_1','col_2'], inplace = True)
print(df)
</code></pre>
<p>如果要传递所有列以定义唯一性,请改用<code>df.columns</code></p>
<pre><code>df.drop_duplicates(df.columns, inplace = True)
print(df)
</code></pre>
<p><strong>编辑:</strong></p>
<p>要传递列表中的所有数据帧,并且不想替换df,请使用下面的代码并说<code>inplace = False</code>(默认值)</p>
<pre><code>lst_df = [pd.DataFrame({'col_1':['A','B','A','B','C'], 'col_2':[3,4,3,5,6], 'col_3':[0,0.1,0.2,0.3,0.4]}), pd.DataFrame({'col_1':['A','B','A','B','C'], 'col_2':[3,4,3,5,6], 'col_3':[0,0.1,0.2,0.3,0.4]})]
new_lst_df = []
[new_lst_df.append(lst_df[i].drop_duplicates(['col_1', 'col_2'])) for i in range(len(lst_df))]
print(new_lst_df)
</code></pre>