Advertisement
Guest User

Untitled

a guest
Apr 1st, 2020
112
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.75 KB | None | 0 0
  1. yield_2019 = AFLT[AFLT["YEAR"] == 2019]["LOGYIELD"]
  2. yield_2019 *= 100
  3.  
  4.  
  5.  
  6. k = int(1 + 3.322 * np.log(len(yield_2019)) / np.log(10))
  7. R = max(yield_2019) - min(yield_2019)
  8. h = round(R / k,2)
  9. interval = [round(i,2) for i in np.arange(min(yield_2019) + delta,max(yield_2019) - delta,h)]
  10. interval.append(round(interval[-1] + h,2))
  11. interval
  12.  
  13. sorted_yields = sorted(yield_2019)
  14.  
  15.  
  16. def cnt_range(li, min, max):
  17. ctr = 0
  18. for x in li:
  19. if min < x <= max:
  20. ctr += 1
  21. return ctr
  22. rows, cols = [], []
  23. for i in range(len(interval) - 1):
  24. a, b = interval[i], interval[i+1]
  25. cols.append(f'({a}:{b}]')
  26. rows.append(cnt_range(sorted_yields, a, b))
  27.  
  28. df_yields = pd.DataFrame(data=[rows], columns=cols, index = ['count'])
  29. df_yields
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement