Prepare data for Shipment Visualisation - Sunburst 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_sunburstchart.md

(2) Data Output:
sunburst_receiving_category_count.json
sunburst_receiving_category_needs.json
sunburst_receiving_group_count.json
sunburst_receiving_group_needs.json
sunburst_sending_category_count.json
sunburst_sending_category_needs.json
sunburst_sending_group_count.json
sunburst_sending_group_needs.json