A Python-based data pipeline that scrapes, downloads, and stores exchange rate and payment systems data from the official Bank of Zambia website. Designed to automate data collection for use in analytics and Power BI dashboards.
- Scrapes daily ZMW/USD exchange rates from
https://www.boz.zm/ - Downloads historical Payment Systems Statistics
.xlsxreports - Cleans and saves data to CSV files in a structured directory
- Logs all actions and errors to
.txtlog files - Cron-compatible for daily automation on macOS
- Power BI-ready CSV outputs - COMING SOON
BoZ/ ├── boz_scraper.py # Scrapes daily exchange rates ├── boz_payment_systems_downloader.py # Downloads payment systems .xlsx files ├── logs/ │ ├── boz_cron_log.txt │ └── payment_systems_log.txt ├── data/ │ ├── boz_usd_rates_YYYYMMDD.csv │ └── payment_systems/ # Downloaded .xlsx files ├── LICENSE ├── README.md └── .gitignore