PYTHON

pandas remove repeated index

df[~df.index.duplicated()]

drop duplicate index pandas

df3 = df3[~df3.index.duplicated(keep='first')]

remove duplicates in dataframe by index python

# Remove by index
df = df[df.index.duplicated(keep='first')]

# Other methods to remove duplicates
import pandas as pd

df = df.drop_duplicates()

df = df.drop_duplicates(subset = "column")

df = df.drop_duplicates(subset = ["column", "column2"])

pandas remove repeated index

idx = pd.Index(['lama', 'cow', 'lama', 'beetle', 'lama', 'hippo'])
idx.drop_duplicates(keep='first')
Index(['lama', 'cow', 'beetle', 'hippo'], dtype='object')
idx.drop_duplicates(keep='last')
Index(['cow', 'beetle','lamb', 'hippo'], dtype='object')
idx.drop_duplicates(keep='False')
Index(['cow', 'beetle','hippo'], dtype='object')

pd df drop duplicates

df.drop_duplicates(subset=['brand', 'style'], keep='last')

df index drop duplicates

df3 = df3[~df3.index.duplicated(keep='first')]

drop duplicates data frame pandas python

df.drop_duplicates(keep=False, inplace=True)