Answers for "drop all coloumns based on duplicate in one row"

remove duplicates based on two columns in dataframe

df.drop_duplicates(['A','B'],keep= 'last')

drop row with duplicate value

import pandas as pd
df = pd.DataFrame({"A":["foo", "foo", "foo", "bar"], "B":[0,1,1,1], "C":["A","A","B","A"]})
df.drop_duplicates(subset=['A', 'C'], keep=False)