Prepare data for Shipment Visualisation - Area Bump Chart

[ChienChen99]

As we are building the visualisations of shipment data using Nivo (a visualisation app), the data has to be prepared in a specific format for Nivo to build specific charts (different charts require different data structures). Here, I have manipulated the excel file "7 - Exportable _ Shareable Data [EXT].xlsx" into the format required using Python. Attached are: (1) readme with code explanations for each step; and (2) the resulting data in json format.

(1) Code File with Readme:
README_areabumpchart.md

(2) Data Output
area_bump_project_count.json
area_bump_project_needs.json
area_bump_shipment_count.json
area_bump_shipment_needs.json