Pandas - remove duplicate items completely from dataframe [duplicate]

Question

I want to remove duplicate items completely from a pandas dataframe. For example, I have the dataframe:

  location     area
0  mountain view  1044ft2
1      palo alto     None
2  mountain view   890ft2
3     san carlos  1000ft2
4        belmont     None

What I want to do is find unique values in column location and remove any items that had duplicates altogether, completely, etc.. So the final product will look like this (notice mountain view is gone):

  location     area
1      palo alto     None
3     san carlos  1000ft2
4        belmont     None

Thanks.

Very simple! Thanks, didn't notice a duplicate question on SO, but appreciate your help @anky — irahorecka
– irahorecka, Commented Jul 19, 2020 at 17:56

Balaji Ambresh · Accepted Answer · 2020-07-19 17:57:30Z

2

Use

df.drop_duplicates(subset='location', keep=False)

answered Jul 19, 2020 at 17:57

Balaji Ambresh

5,0022 gold badges7 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Pandas - remove duplicate items completely from dataframe [duplicate]

1 Answer 1

Comments

Hot Network Questions