Advertisement
Guest User

Untitled

a guest
Apr 23rd, 2017
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.88 KB | None | 0 0
  1. def compress_data_to_excel(self, data):
  2. minimum = min(i.get('year') for i in data)
  3. maximum = max(i.get('year') for i in data)
  4. year_range = maximum - minimum + 1
  5. datasets = {minimum + x: [] for x in range(int(minimum), int(maximum + 1))}
  6. all_years = [minimum + x for x in range(0, int(year_range))]
  7.  
  8. copy = data[:]
  9. for row in data:
  10. y = all_years[:]
  11. for inner in copy:
  12. if row.get('project_id') == inner.get('project_id'):
  13. year = inner.get('year')
  14. y.remove(year)
  15. datasets[year].append(self._build_dataset_blocks(year, inner.get('months')))
  16. else:
  17. for year in y:
  18. datasets[year].append(self._build_dataset_blocks(year, {}))
  19.  
  20. print(datasets)
  21. return data
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement