pandas - Dropping duplicates based on other column values (Python)

Question

I have a dataframe with 3 columns. I would like to drop duplicates in column A based on values in other columns. I have searched tirelessly and cant find a solution like this.

example:

A	B	C
Family1	nan	nan
Family1	nan	1234
Family1	1245	nan
Family1	3456	78787
Family2	nan	nan
Family3	nan	nan

question from:https://stackoverflow.com/questions/65836993/dropping-duplicates-based-on-other-column-values-python

Answer 1

You were not very clear. I suspect you want to drop any duplicates in column A if both columns B and C are NaN. If so, please try;

df[~(df.A.duplicated(keep=False)&(df.B.isna()&df.C.isna()))]