Answered by : sachin-verma

import pandas as pd
# making data frame from csv file
data = pd.read_csv("employees.csv")
# sorting by first name
data.sort_values("First Name", inplace = True)
# dropping ALL duplicte values
data.drop_duplicates(subset ="First Name",keep = False, inplace = True)
# displaying data
print(data)

Source : | Last Update : Sun, 05 Jul 20

Answered by : clean-chimpanzee-x9xh2muu92w1

data = data.drop_duplicates(subset=['City'], keep='first')

Source : https://duckduckgo.com/?q=pandas+drop+duplicates+from+column&t=brave&ia=web | Last Update : Sun, 22 May 22

Answered by : happy-hawk

df = df.loc[:,~df.columns.duplicated()]

Source : https://stackoverflow.com/questions/14984119/python-pandas-remove-duplicate-columns | Last Update : Thu, 04 Jun 20

Answered by : jose-santiago-bordas

# Drop duplicate columns
df2 = df.T.drop_duplicates().T
print(df2)

Source : https://sparkbyexamples.com/pandas/pandas-remove-duplicate-columns-from-dataframe/ | Last Update : Fri, 22 Jul 22

Answered by : or-berger

df.loc[:,~df.columns.duplicated()]

Source : | Last Update : Wed, 08 Jun 22

Answered by : perfect-penguin-a1nt3r09ybl6

df = df.loc[:,~df.columns.duplicated()].copy()
# https://stackoverflow.com/questions/14984119/python-pandas-remove-duplicate-columns

Source : | Last Update : Mon, 10 Oct 22