Pandas get DataFrame with unique column combinations

Question

I have a DataFrame like this:

df = pd.DataFrame({'orig': ['ORD', 'AUS', 'AUS'], 'dest': ['LAX', 'JFK', 'JFK']}

I'd like to be able to turn that into a DataFrame that has two columns orig and dest that contain all of the unique combinations of orig and dest in df like this:

  orig   dest
1 ORD    LAX
2 AUS    JFK

so that I can iterate over each row and call a separate method that I've created for each orig and dest.

Is this possible? Most other answers that I've seen on here don't return a DataFrame object.

Yes that does it. Thanks. I will accept the answer when I can - it's not letting me accept for another 9 minutes. Thanks! — gr1zzly be4r, Feb 23 '17 at 15:42

score 2 · Accepted Answer · answered Feb 23 '17 at 15:40

2

You want to add below code to your code. It will give you dataframe with all unique rows. Please read this

df = df.drop_duplicates()

answered Feb 23 '17 at 15:40

Rohan

5,121
1
17
19

score 1 · Answer 2 · answered Feb 23 '17 at 15:48

1

You can do that with drop_duplicates éethod

print(df.drop_duplicates())

answered Feb 23 '17 at 15:48

Diane Delallée

123
2
9

Pandas get DataFrame with unique column combinations

2 Answers2