remove duplicates from dataframe

Question

I have a dataframe "df" like the sample below. I would like to use address and business_id as a unique key, and filter the dataframe so it only has unique records based on the combination of address and business_id. Can anyone suggest how to do that?

Code:

print df[["address","business_id","city"]][1:3]

Sample Data:

               address             business_id       city
1       2824 Milton Rd  mLwM-h2YhXl2NCgdS84_Bw  Charlotte
2  337 Danforth Avenue  v2WhjAB3PIBA8J8VxG3wEg    Toronto

Possible duplicate of [Drop all duplicate rows in Python Pandas](https://stackoverflow.com/questions/23667369/drop-all-duplicate-rows-in-python-pandas) — DJK, Oct 27 '17 at 04:13

score -1 · Answer 1 · answered Oct 25 '17 at 23:23

-1

Along with removing the duplicate, you want to use df.set_index

df.set_index(keys=["address","business_id"])

answered Oct 25 '17 at 23:23

Mikell-S

42
3

remove duplicates from dataframe

1 Answers1