International Debt Statistics - PPG Bilateral Debt
Umar Shaikh
International Debt Statistics - PPG Bilateral Debt
Objective
If you have been following new recently, you may have come across various headlines like "South Asia in Chinese Debt Trap", "Economic crisis in Sri Lanka", "Failing economy of Pakistan", etc. These news articles made me curious to look into bilateral lendings between 2 countries. Using python, I developed a script to download PPG Bilateral Debt data between 2 countries using World Bank API..
My project collects data of PPG bilateral lending between India and its neighbouring countries which include Bangladesh, Bhutan, Sri Lanka, Nepal, Maldives & Myanmar. I have wrangled and analysed data from last 20 years of each country individually and visualized the data in form of excel dashboard for easy understanding of lending trend. Check out the project report
About the dataset
Dataset includes details of PPG Bilateral debt data between India & Bangladesh/Bhutan/Sri Lanka/Maldives/Myanmar/Nepal obtained using World Bank API. Each dataset contains 4 columns: 'Year': Year of debt, 'Debtor': Debtor country code,'Debt in US$': Amount of debt in US$, 'YoY Growth %': Year on year growth percentage of bilateral debt. All 6 datasets are combined, cleaned, wrangled and analysed here
Guidelines to use the script:
Use the PPG Bilateral Debt Script
Conclusion of project
Total PPG Bilateral Lending has increased from less than 500 million $ in 2000 to about 45 billion $ in 2020
Bhutan has been the biggest debtor country receiving almost 18 billion $ over the period of 20 years
Nepal has received the least bilateral lending amounting to less than 1 billion $
Total bilateral lending show a positive growth rate since last 20 years
Total bilateral lending to neighbouring countries is approx. 1.2% of overall GDP of India
In the event of default by any neighboring country in future, its impact on India’s financial sector will be minimal (Considering only the above data)
