How to list unique combinations in a pandas dataframe

Question

I have dataframe in pandas with columns. I want list only the unique combinations .How can do it.

**Input**

data[['Month','Ratio']]

Month  Ratio
3      0.7169653 
3      0.7169653      
3      0.7169653
6      0.6789213
6      0.6789213
7      0.2345671
7      0.2345671
7      0.2345671
7      0.2345671
12     0.5623451
12     0.5623451
12     0.5623451
1      0.9808901


**Expected Output**

Month  Ratio
3      0.7169653 
6      0.6789213
7      0.2345671
12     0.5623451
1      0.9808901

How to do this in python

`data.drop_duplicates()`. Did you google anything before posting here? — user3483203, Aug 11 '18 at 10:05
`data.drop_duplicates(subset=['Month','Ratio'], inplace=True)` should give you what you want. — user2906838, Aug 11 '18 at 10:06

score 0 · Accepted Answer · answered Aug 11 '18 at 10:16

0

I used drop_duplicates() function

 Month_unique= data[['Month','Month_Ontime_Delivery_Ratio']].drop_duplicates()

This resolved the issue.

answered Aug 11 '18 at 10:16

Rahul rajan

1,186
4
18
32

How to list unique combinations in a pandas dataframe

1 Answers1