Advertisement
sreejith2904

Untitled

Dec 13th, 2019
211
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.53 KB | None | 0 0
  1. def monthly_average(warehouse_name, year, month):
  2.  
  3.     if warehouse_name in data.keys():
  4.         _data = data[warehouse_name]
  5.  
  6.         _dates = [list(tmp.keys())[0] for tmp in _data]
  7.         dates = [t.split("-") for t in dates]
  8.         indices = [index for index, date in enumerate(dates) if date[0] == year and date[1] == month]
  9.        
  10.         filtered_data = [_data[index] for index in indices]
  11.  
  12.         values = [list(tmp.values())[0] for tmp in filtered_data]
  13.  
  14.         avg = sum(values)/len(values)
  15.  
  16.         return avg
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement