print d
Sp Mt Value Count
ID
4 MM2 S4 bg 10
5 MM2 S4 dgd 1
6 MM4 S2 rd 2
7 MM4 S2 cb 8
8 MM4 S2 uyi 8
>>> d.groupby('Sp').apply(lambda t: t[t.Count==t.Count.max()]) Sp Mt Value CountSp IDMM2 4 MM2 S4 bg 10MM4 7 MM4 S2 cb 8 8 MM4 S2 uyi 8


