How to drop duplicated rows in a DataFrame with Pandas using Python

1 min

In order to drop duplicated rows or columns, you can use the DataFrame.drop_duplicates() method.

The example

Imagine we have a DataFrame that has two similar rows but you want to eliminate one of the duplicates.

Here is the code

# To work with dataframes
import pandas as pd

# We create a sample dataframe
df = pd.DataFrame({"col1" : [0, 10, 3, 11, 3, 12],
                   "col2" : [1, 2, 2, 12, 2, 12]})

# We assign the dataframe
df = df.drop_duplicates()

# We print the dataframe
print(df)

Here you are! You now know how to drop duplicated rows in a DataFrame with Pandas using Python.

More on DataFrames

If you want to know more about DataFrame and Pandas. Check out the other articles I wrote on the topic, just here :

Pandas - The Python You Need
We gathered the only Python essentials that you will probably ever need.