Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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],
- '10_deg': [47, 41, 46, -18, 4, 16, 12, 34, -52, 31, 16, 12, 34, -71, 2, 9, 52, 34, -6, 9],
- '20_deg': [46, 43, -56, 29, 6, 14, 13, 33, 43, 6, 14, 13, 37, 43, 3, 14, 13, 25, 40, 8],
- '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])
- df = df.set_index('Number')
- def f(x):
- x1 = x.abs().stack()
- x2 = x.stack()
- x = x2.iloc[np.argsort(-x1)].head(b)
- return x
- groups = (df.index == 5).cumsum()
- df1 = df.groupby(groups).apply(f).reset_index(level=[1,2])
- df1.columns = ['Number','Angle','Value']
- print (df1)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement