Guest User

Untitled

a guest
Feb 23rd, 2018
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.68 KB | None | 0 0
  1. np.random.seed(123)
  2.  
  3. N= 10
  4. df = pd.DataFrame({
  5. 'grp':np.random.choice(['aaa','bbb','ccc'], N, p=[0.3, .6, .1]),
  6. 'val':np.random.randint(100, size=N)
  7. })
  8.  
  9. In [119]: df
  10. Out[119]:
  11. grp val
  12. 0 bbb 46
  13. 1 aaa 96
  14. 2 aaa 25
  15. 3 bbb 83
  16. 4 bbb 78
  17. 5 bbb 36
  18. 6 ccc 96
  19. 7 bbb 80
  20. 8 bbb 68
  21. 9 bbb 49
  22.  
  23. In [120]: df['grp'].value_counts()
  24. Out[120]:
  25. bbb 7
  26. aaa 2
  27. ccc 1
  28. Name: grp, dtype: int64
  29.  
  30. idx = (df.groupby('grp')['val'].transform('count')).sort_values(ascending=False).index
  31.  
  32. df.reindex(idx)
  33.  
  34. In [126]: df.reindex(idx)
  35. Out[126]:
  36. grp val
  37. 9 bbb 49
  38. 8 bbb 68
  39. 7 bbb 80
  40. 5 bbb 36
  41. 4 bbb 78
  42. 3 bbb 83
  43. 0 bbb 46
  44. 2 aaa 25
  45. 1 aaa 96
  46. 6 ccc 96
Add Comment
Please, Sign In to add comment