Context

The kernel aims to extract data from Wikipedia's list of countries by category, and visualize it. The database itself, contains a HUGE amount of analyzed data at different categories, waiting anxiously for someone to present them elegantly ( 😏 ), and compare the trends between the different countries.

               <img src="https://github.com/Daniboy370/Machine-Learning/blob/master/Misc/Animation/VID-out-Wiki.gif?raw=true" width="550">

Content

The list contains 143 analyses of countries with respect to a specific criterion. Practically, I will refer to several criteria that I found interesting, however the reader is free to add as much as he pleases :

The well processed data should be able to provide such a visualization ( for example ) :

                      <img src="https://github.com/Daniboy370/Uploads/blob/master/Kaggle-Dataset-Wiki.gif?raw=true" width="600">

Pipeline

Choose criterion >> Extract data >> Examine & Clean >> Convert to dataframe >> Visualize :

                      <img src="https://github.com/Daniboy370/Uploads/blob/master/VID-Globe.gif?raw=true" width="400">

\[ \text{Enjoy !}\]

Out of all 50 states, New York had the highest per-capita real gross domestic product (GDP) in 2024, at 92,341 U.S. dollars, followed closely by Massachusetts. Mississippi had the lowest per-capita real GDP, at 41,603 U.S. dollars. While not a state, the District of Columbia had a per capita GDP of more than 210,780 U.S. dollars. What is real GDP? A country’s real GDP is a measure that shows the value of the goods and services produced by an economy and is adjusted for inflation. The real GDP of a country helps economists to see the health of a country’s economy and its standard of living. Downturns in GDP growth can indicate financial difficulties, such as the financial crisis of 2008 and 2009, when the U.S. GDP decreased by 2.5 percent. The COVID-19 pandemic had a significant impact on U.S. GDP, shrinking the economy 2.8 percent. The U.S. economy rebounded in 2021, however, growing by nearly six percent. Why real GDP per capita matters Real GDP per capita takes the GDP of a country, state, or metropolitan area and divides it by the number of people in that area. Some argue that per-capita GDP is more important than the GDP of a country, as it is a good indicator of whether or not the country’s population is getting wealthier, thus increasing the standard of living in that area. The best measure of standard of living when comparing across countries is thought to be GDP per capita at purchasing power parity (PPP) which uses the prices of specific goods to compare the absolute purchasing power of a countries currency.

This dataset provides values for GDP PER CAPITA reported in several countries. The data includes current values, previous releases, historical highs and record lows, release frequency, reported unit and currency.

Gross domestic product (GDP) is a monetary measure of the market value of all the final goods and services produced and sold (not resold) in a specific time period by countries.[2][3] Due to its complex and subjective nature this measure is often revised before being considered a reliable indicator. GDP (nominal) per capita does not, however, reflect differences in the cost of living and the inflation rates of the countries; therefore, using a basis of GDP per capita at purchasing power parity (PPP) may be more useful when comparing living standards between nations, while nominal GDP is more useful comparing national economies on the international market.[4] Total GDP can also be broken down into the contribution of each industry or sector of the economy.[5] The ratio of GDP to the total population of the region is the per capita GDP (also called the Mean Standard of Living).

Source: https://en.wikipedia.org/wiki/Gross_domestic_product

This dataset is extracted from https://en.wikipedia.org/wiki/List_of_countries_by_GDP_-PPP-_per_capita. Context: There s a story behind every dataset and heres your opportunity to share yours.Content: What s inside is more than just rows and columns. Make it easy for others to get started by describing how you acquired the data and what time period it represents, too. Acknowledgements:We wouldn t be here without the help of others. If you owe any attributions or thanks, include them here along with any citations of past research.Inspiration: Your data will be in front of the world s largest data science community. What questions do you want to see answered?

GDP/NSDP

Net state domestic product (NSDP) is the state counterpart to a country's Net domestic product (NDP), which equals the gross domestic product (GDP) minus depreciation on a country's capital goods.

About Dataset

The following dataset gives some of the latest available nominal NSDP per capita figures for the Indian States of India at current prices in Indian rupees. This dataset also contains geometrical information about the states which allows the users to plot interesting visualizations on the Indian or State Maps

Credits

GDP per Capita Information: List of Indian states and union territories by GDP per capita Geometry Information: India GIS Data

This dataset is extracted from https://en.wikipedia.org/wiki/List_of_Mexican_states_by_GDP_per_capita. Context: There s a story behind every dataset and heres your opportunity to share yours.Content: What s inside is more than just rows and columns. Make it easy for others to get started by describing how you acquired the data and what time period it represents, too. Acknowledgements:We wouldn t be here without the help of others. If you owe any attributions or thanks, include them here along with any citations of past research.Inspiration: Your data will be in front of the world s largest data science community. What questions do you want to see answered?

Regional accounts give a description of the volume of the economic process in the various regions of a country consistent with national accounts. Elements in the economic process distinguished in national accounts are production, distribution of income, spending and financing. Regional accounts focus on the description of the production processes in the various regions.

Data available from: 1995

Status of the figures: The figures of the years 1995 to 2021 are final. Data of the year 2022 are also final, but the figures of the variables Full-time equivalent (fte), Employed persons and Hours worked are an exception, due to the late availability of annual data on self-employed persons. These final figures are published a year after. The figures of the year 2023 are provisional.

Changes as of December 23rd 2024: The figures for GDP, GDP per capita and gross value added, as well as the volume changes of gross value added and GDP on regional level were incorrect. This is corrected in this publication. The national figures for the Netherlands remain unchanged.

Changes as of December 9th 2024: None, this is a new table. Statistics Netherlands has carried out a revision of the national accounts. The Dutch national accounts are recently revised. New statistical sources, methods and concepts are implemented in the national accounts, in order to align the picture of the Dutch economy with all underlying source data and international guidelines for the compilation of the national accounts. This table contains revised data. For further information see section 3.

When will new figures be published? New figures will be published in December 2025.

This table shows the gross domestic product (GDP) per capita of Bonaire, St. Eustatius, Saba and total Caribbean Netherlands. GDP is a macroeconomic concept.

Note: GDP per capita has been calculated in all years using the most current figures for GDP and population size. No correction has been made for the following two breaks in population time series: - Between 1 January 2015 and 1 January 2016, the population register of St. Eustatius was updated. As a result, approximately 600 individuals were classified as emigrants. These people were still registered in the population register of St. Eustatius, but a check-up revealed that they did not live on the island anymore. - Between 1 Januari 2018 en 1 Januari 2019, the population register of both St. Eustatius and Saba was updated. As a result, approximately 200 individuals on Sint Eustatius and over 200 individuals on Saba were classified as emigrants. These people were still registered in the population register of respectively St. Eustatius and Saba, but a check-up revealed that they did not live on these islands anymore.

Data available from: 2012

Status of the figures: The figures in this table are final.

Changes as of 25 September 2025: Data of 2023 have been added to this table.

When will new figures be published? New figures of the GDP per capita of 2024 will be published in the autumn of 2026.

This dataset is extracted from https://en.wikipedia.org/wiki/List_of_countries_by_GDP_-nominal-_per_capita. Context: There s a story behind every dataset and heres your opportunity to share yours.Content: What s inside is more than just rows and columns. Make it easy for others to get started by describing how you acquired the data and what time period it represents, too. Acknowledgements:We wouldn t be here without the help of others. If you owe any attributions or thanks, include them here along with any citations of past research.Inspiration: Your data will be in front of the world s largest data science community. What questions do you want to see answered?

This dataset is extracted from https://en.wikipedia.org/wiki/List_of_Japanese_prefectures_by_GDP_per_capita. Context: There s a story behind every dataset and heres your opportunity to share yours.Content: What s inside is more than just rows and columns. Make it easy for others to get started by describing how you acquired the data and what time period it represents, too. Acknowledgements:We wouldn t be here without the help of others. If you owe any attributions or thanks, include them here along with any citations of past research.Inspiration: Your data will be in front of the world s largest data science community. What questions do you want to see answered?

GDP, GDP per capita, consistency with GDP, total value added, compensation of employees, taxes, subsidies, gross operating surplus by region 1995 - 2001 Changed on April 18 2006. Frequency: Discontinued.

The 'GDP Capital Expenditure QoQ' in Australia measures the quarterly change in the total value of new capital expenditures made by businesses, which is a key component of GDP.

This dataset is extracted from https://en.wikipedia.org/wiki/List_of_regions_by_past_GDP_-PPP-_per_capita. Context: There s a story behind every dataset and heres your opportunity to share yours.Content: What s inside is more than just rows and columns. Make it easy for others to get started by describing how you acquired the data and what time period it represents, too. Acknowledgements:We wouldn t be here without the help of others. If you owe any attributions or thanks, include them here along with any citations of past research.Inspiration: Your data will be in front of the world s largest data science community. What questions do you want to see answered?

This dataset contains the Gross Domestic Product of 193 countries per person per year in USD ranging from 1st January 1901 to 1st January 2011. The GDP is calculated for an interval of 5 years which can be seen from the date column. This data was collected from Wikipedia under CC BY SA 4.0 International License. Wikipedia further collected this data from the World Bank under Creative Commons 4.0 International License (CC BY 4.0).

This data can be used to contrast the difference between the geographical locations of a particular country. A basic visualization and analysis would let you know that there's a huge difference in the GDPs of the countries in the Middle East, North Africa, and Greater Arabia region and countries in the European region. A further similar analysis can also be done. Play with this data as you like. The region column is specifically given so that you can map out the difference in GDP based on the geographical location of that country on the map.

I downloaded this dataset from Wikipedia. I was startled when I came across a video to realise that the United States has the highest external debt among world countries. India and Brazil lie at around 20th positions. United Kingdom's external debt is a staggering 273% of their GDP while India's is 19.20 %. Brazil's external debt is 38% of their GDP. The United States' external debt is 96.40 % of their GDP while Japan has 101 % of its GDP as its external debt.

The dataset contains the country names, their external debt, their per capita external debt, the date of entering the data and the external debt as a percentage of their GDP.

The data can be cleaned and can form an excellent use case for LLM based data analytics. The data must be cleaned. The data can be combined with other financial data of the respective countries to form a complete database of financial metrics.

The gross domestic product (GDP) of Papua New Guinea (PNG) grew at an annual average rate of nearly 7% between 2007 and 2010, and is expected to perform even better in 2011. Moreover, the economy remained unaffected even at the peak of the global economic crisis, when most other major Southeast Asian and Pacific economies recorded low or negative GDP growth rates. Sound macroeconomic management in the recent past and planned initiatives such as the PNG LNG Project indicate that the economy will continue to perform well in the medium to long run. Nevertheless, the country faces a number of development challenges. Per capita GDP and its growth rate remain low. The economy is heavily dependent on the mining and resource sectors, and hence remains vulnerable to fluctuations in the global markets. A majority of the people in the labor force work in the informal sector, and opportunities for productive employment in the formal sector continue to grow very slowly. Provision of public services, including education, health, and safe drinking water and sanitation, remains inadequate, especially in the rural areas.

This dataset is extracted from https://en.wikipedia.org/wiki/List_of_OECD_regions_by_GDP_-PPP-_per_capita. Context: There s a story behind every dataset and heres your opportunity to share yours.Content: What s inside is more than just rows and columns. Make it easy for others to get started by describing how you acquired the data and what time period it represents, too. Acknowledgements:We wouldn t be here without the help of others. If you owe any attributions or thanks, include them here along with any citations of past research.Inspiration: Your data will be in front of the world s largest data science community. What questions do you want to see answered?

The following dataset gives some of the latest available GDP per capita figures for the Indian States of India at current prices in Indian rupees.

Source -- Wikipedia

**🌍 World Countries Dataset This World Countries Dataset contains detailed information about countries across the globe, offering insights into their geographic, demographic, and economic characteristics.

It includes various features such as population, area, GDP, languages, and regional classifications. This dataset is ideal for projects related to data visualization, statistical analysis, geographical studies, or machine learning applications such as clustering or classification of countries.

This dataset was manually compiled/collected from reliable open data sources (e.g., Wikipedia, World Bank, or other governmental datasets).

**🔍 Sample Questions Explored Using Python: - Q. 1) Which countries have the highest and lowest population? - Q. 2) What is the average area (in sq. km) of countries in each region? - Q. 3) Which countries have more than 100 million population and GDP above $1 trillion? - Q. 4) Which languages are most commonly spoken across countries? - Q. 5) Show a bar graph comparing GDPs of G7 nations. - Q. 6) How many countries are there in each continent or region? - Q. 7) Which countries have both a high population density and low GDP per capita? - Q. 8) Create a world map visualization of population or GDP distribution. - Q. 9) What are the top 10 most densely populated countries? - Q. 10) How many landlocked countries are there in the world?

**🧾 Features / Columns in the Dataset: - Country: The name of the country (e.g., "Pakistan", "France").

• Capital: The capital city of the country.

• Region: Broad geographical region (e.g., "Asia", "Europe").

• Subregion: More specific geographical grouping (e.g., "Southern Asia").

• Population: Total population of the country.

• Area (sq. km): Total land area in square kilometers.

• Population Density: Number of people per square kilometer.

• GDP (USD): Gross Domestic Product (in U.S. dollars).

• GDP per Capita: GDP divided by the population.

• Official Languages: Officially recognized language(s) spoken.

• Currency: Name of the currency used.

• Timezones: Timezones in which the country falls.

• Borders: List of bordering countries (if any).

• Landlocked: Whether the country is landlocked (Yes/No).

• Latitude / Longitude: Coordinates for geographical plotting.