Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- def compress_data_to_excel(self, data):
- minimum = min(i.get('year') for i in data)
- maximum = max(i.get('year') for i in data)
- year_range = maximum - minimum + 1
- datasets = {minimum + x: [] for x in range(int(minimum), int(maximum + 1))}
- all_years = [minimum + x for x in range(0, int(year_range))]
- copy = data[:]
- for row in data:
- y = all_years[:]
- for inner in copy:
- if row.get('project_id') == inner.get('project_id'):
- year = inner.get('year')
- y.remove(year)
- datasets[year].append(self._build_dataset_blocks(year, inner.get('months')))
- else:
- for year in y:
- datasets[year].append(self._build_dataset_blocks(year, {}))
- print(datasets)
- return data
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement