Developed to automate the workflow of downloading Panjiva data, transforming the data and pasting the data into a template pptx report.
- Python 3
- pandas
- numpy
- python-pptx
- geopandas
- The csv file(s) from Panjiva (e.g. Panjiva-China_Exports.csv)
- Template files: hs_lookup.csv and template.pptx
Keep the scripts and required files in the same folder.
python3 main.py
- Formatting. Center align text and merge cells of some tables.
- Master view - automatically edits caompany name in the master slide (?)