Skip to content

Latest commit

Β 

History

History
31 lines (24 loc) Β· 1.05 KB

README.md

File metadata and controls

31 lines (24 loc) Β· 1.05 KB

Bank of Zambia Data Pipeline

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.


Features

  • Scrapes daily ZMW/USD exchange rates from https://www.boz.zm/
  • Downloads historical Payment Systems Statistics .xlsx reports
  • Cleans and saves data to CSV files in a structured directory
  • Logs all actions and errors to .txt log files
  • Cron-compatible for daily automation on macOS
  • Power BI-ready CSV outputs - COMING SOON

πŸ“‚ Project Structure

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