This is a SQL project which analyzes the international debt data collected by the World Bank. We seek to find total debt owned by conuntries, the country with the highest debt amount and more relevant info.
It's not that we humans only take debts to manage our necessities. A country may also take debt to manage its economy. For example, infrastructure spending is one costly ingredient required for a country's citizens to lead comfortable lives. The World Bank is the organization that provides debt to countries.
In this notebook, we are going to analyze international debt data collected by The World Bank. The dataset contains information about the amount of debt (in USD) owed by developing countries across several categories. We are going to find the answers to questions like:
What is the total amount of debt that is owed by the countries listed in the dataset? Which country owns the maximum amount of debt and what does that amount look like? What is the average amount of debt owed by countries across different debt indicators?
- Download the Jupyter Notebook above on your computer.
-
Make sure you use Python 3.
-
requires a Python sql library.
-
Run the jupyter notebook.
Project status: Finished
This project inspired me to improve my SQL skills for their application to a real world database for successful analysis.
Feel free to contact , drop an mail to pranshu1921@gmail.com