Advertisement
Guest User

Untitled

a guest
Jun 18th, 2019
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.80 KB | None | 0 0
  1. df=pd.DataFrame({'0_deg': [43, 50, 45, -17, 5, 19, 11, 32, 36, 41, 19, 11, 32, 36, 1, 19, 7, 1, 36, 10],
  2. '10_deg': [47, 41, 46, -18, 4, 16, 12, 34, -52, 31, 16, 12, 34, -71, 2, 9, 52, 34, -6, 9],
  3. '20_deg': [46, 43, -56, 29, 6, 14, 13, 33, 43, 6, 14, 13, 37, 43, 3, 14, 13, 25, 40, 8],
  4. '30_deg': [-46, 16, -40, -11, 9, 15, 33, -39, -22, 21, 15, 63, -39, -22, 4, 6, 25, -39, -22, 7]}, index=[5, 10, 12, 101, 130, 5, 10, 12, 101, 130, 5, 10, 12, 101, 130, 5, 10, 12, 101, 130])
  5.  
  6. df = df.set_index('Number')
  7.  
  8. def f(x):
  9. x1 = x.abs().stack()
  10. x2 = x.stack()
  11. x = x2.iloc[np.argsort(-x1)].head(b)
  12. return x
  13.  
  14. groups = (df.index == 5).cumsum()
  15. df1 = df.groupby(groups).apply(f).reset_index(level=[1,2])
  16. df1.columns = ['Number','Angle','Value']
  17. print (df1)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement