How panimalar1913/international_debt_analysis_system works
International Debt Analysis System combines a Streamlit dashboard for exploring debt indicators with scripts for cleaning World Bank datasets, running statistical analyses, and loading cleaned CSVs into MySQL. The dashboard loads lookup lists, applies country/indicator/year selections, queries debt records, and presents summaries, charts, and a data preview. Separately, the analysis script reads cleaned data and emits statistical results and plots. The README gives no further capability details; relationships are included only where visible in the excerpts.
Main entry points: app.py Debt dashboard · clean.py Dataset cleaning · Output Cleaned datasets · Analysis.py Debt analysis
Components 11
Interactive dashboard
- Debt dashboard
app.py - Charts and preview
app.py
Data preparation
- Source datasets
data - Dataset cleaning
clean.py - Cleaned datasets
Output
Debt analysis
- Debt analysis
Analysis.py - Analysis outputs
Output/analysis
MySQL persistence
- CSV table loader
sql/load_debt.py - Loader CSV inputs
sql - MySQL debt database
Other components
- Analyst
Connections 9
- Analyst → Debt dashboard: uses
app.py - Debt dashboard → MySQL debt database: queries
app.py - Debt dashboard → Charts and preview: renders
app.py - Source datasets → Dataset cleaning: supplies data
- Dataset cleaning → Cleaned datasets: writes
clean.py - Cleaned datasets → Debt analysis: supplies data
- Debt analysis → Analysis outputs: writes
Analysis.py - Loader CSV inputs → CSV table loader: supplies CSVs
sql/load_debt.py - CSV table loader → MySQL debt database: creates and loads
sql/load_debt.py