how could i delete rows with repeating/duplicate index from dataframe

Question

I have a dataframe

>>> df
zeroa  zerob zeroc zerod zeroe zero
FSi                                     
1       10    100     a    ok   NaN   ok
1       11    110        temp   NaN  NaN
2       12    120     c  temp   NaN  NaN
3      NaN    NaN   NaN   NaN    ok  NaN

I want to keep only unique indexes, as index 1 is repeating I want its second instance to be dropped, how could I do that ? I want my result as

>>> df
     zeroa  zerob zeroc zerod zeroe zero
FSi                                     
1       10    100     a    ok   NaN   ok
2       12    120     c  temp   NaN  NaN
3      NaN    NaN   NaN   NaN    ok  NaN

While this question is a duplicate, the accepted answer is not the best answer IMO, so here is a link to the [best answer](http://stackoverflow.com/a/34297689/5276797). — IanS, Sep 21 '16 at 11:40

score 2 · Accepted Answer · answered Sep 21 '16 at 11:37

2

Without resetting the index:

df[~df.index.duplicated()]

answered Sep 21 '16 at 11:37

IanS

15,771
9
60
84

1

nice, I like your solution more then mine :) – milos.ai Sep 21 '16 at 11:39
I tried the `reset_index` route first, but Google saved me ;) – IanS Sep 21 '16 at 11:40
thanks it worked !!! :) – pratish_v Sep 21 '16 at 11:49

score 1 · Answer 2 · answered Sep 21 '16 at 11:35

Ok something like this should help:

df = df.reset_index().drop_duplicates(subset='FSi', keep='first').set_index('FSi')

Explanation: First we reset_index which creates a column FSi cause drop_duplicates works on columns and not on index. We keep the first one and set_index again back to FSi

how could i delete rows with repeating/duplicate index from dataframe

2 Answers2