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.

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 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.

GDP YoY in the UK measures the percentage change in the country's Gross Domestic Product compared to the same quarter in the previous year, indicating the economy's growth rate.

Dataset Description: Wikipedia World Statistics (2023)

This dataset provides a comprehensive snapshot of global country statistics for the year 2023. It was scraped from various Wikipedia pages using BeautifulSoup, consolidating key indicators and metrics for 142 countries. The dataset covers diverse aspects such as land area, water area, Human Development Index (HDI), GDP forecasts, internet usage, and population changes.

Key Columns and Metrics:

1. Country: The name of the country.
2. Total in km2: Total area of the country.
3. Land in km2: Land area excluding water bodies.
4. Water in km2: Area covered by water bodies.
5. Water %: Percentage of the total area covered by water.
6. HDI: Human Development Index, a measure of a country's overall achievement in its social and economic dimensions.
7. %HDI Growth: Percentage growth in HDI.
8. IMF Forecast GDP(Nominal): International Monetary Fund's forecast for Gross Domestic Product in nominal terms.
9. World Bank Forecast GDP(Nominal): World Bank's forecast for Gross Domestic Product in nominal terms.
10. UN Forecast GDP(Nominal): United Nations' forecast for Gross Domestic Product in nominal terms.
11. IMF Forecast GDP(PPP): IMF's forecast for Gross Domestic Product in purchasing power parity terms.
12. World Bank Forecast GDP(PPP): World Bank's forecast for Gross Domestic Product in purchasing power parity terms.
13. CIA Forecast GDP(PPP): Central Intelligence Agency's forecast for Gross Domestic Product in purchasing power parity terms.
14. Internet Users: Number of internet users in the country.
15. UN Continental Region: Continental region classification by the United Nations.
16. UN Statistical Subregion: Statistical subregion classification by the United Nations.
17. Population 2022: Population of the country in the year 2022.
18. Population 2023: Population of the country in the year 2023.
19. Population %Change: Percentage change in population from 2022 to 2023.

Dataset Sources:

The dataset is sourced from various Wikipedia pages using BeautifulSoup, providing a consolidated and accessible resource for individuals interested in global country statistics. It spans a wide range of topics, making it a valuable asset for exploratory data analysis and research in fields such as economics, demographics, and international relations.

Feel free to explore and analyze this dataset to gain insights into the socio-economic dynamics of countries worldwide.

This table presents annual data on the output components, the final expenditure categories and the income components of gross domestic product of the Netherlands. In the national accounts gross domestic product is approached from three points of view: from the output, from the generation of income and from the final expenditure. Gross domestic product is a main macroeconomic indicator. The volume change of gross domestic product is a measure for the economic growth of a country.

Data available from: 1995.

Status of the figures: Data from 1995 up to and including 2023 are final. Data of 2024 are provisional.

Changes as of June 24th 2025: Data of 2024 have been added to this table.

When will new figures be published? Provisional data are published 6 months after the end of the reporting year. Final data are released 18 months after the end of the reporting year.

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?

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.

The 'GDP Growth Rate YoY Final' in the UK measures the percentage change in the value of all goods and services produced in the economy compared to the same quarter of the previous year.

The 'GDP Growth Rate QoQ Final' in the USA measures the percentage change in the Gross Domestic Product from one quarter to the next, adjusted for inflation.

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.

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: 2010

Status of the figures: The figures of the period 2010 - 2014 are final. Data of the year 2015 are also final, but the figures on jobs, labour years and hours worked by self-employed persons and total employed persons are an exception, due to the late availability of annual data on self-employed persons. These final figures are published a year after.

Changes as of February 1st 2018: The figures of the topics GDP, GDP per capita and Value added for the year 2016 have been corrected for the 4 groups of provincies. The figures of the 4 groups of provincies were not correct. Now they sum up to the National total of these topics.

When will new figures be published? Provisional and final data will be published in October 2018.

The Dataset contains all the real GDP ( Gross Domestic Product) by all countries from 1980 to 2022. This Data is gathered from the International Monitory fund. The GDP will be reflecting the socio economic and political status of country. It will give overall picture and it reflects the implications of various decisions good and bad.

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.

The city of Paris in France had an estimated gross domestic product of 757.6 billion Euros in 2021, the most of any European city. Paris was followed by the spanish capital, Madrid, which had a GDP of 237.5 billion Euros, and the Irish capital, Dublin at 230 billion Euros. Milan, in the prosperous north of Italy, had a GDP of 228.4 billion Euros, 65 billion euros larger than the Italian capital Rome, and was the largest non-capital city in terms of GDP in Europe. The engine of Europe Among European countries, Germany had by far the largest economy, with a gross domestic product of over 4.18 trillion Euros. The United Kingdom or France have been Europe's second largest economy since the 1980s, depending on the year, with forecasts suggesting France will overtake the UK going into the 2020s. Germany however, has been the biggest European economy for some time, with five cities (Munich, Berlin, Hamburg, Stuttgart and Frankfurt) among the 15 largest European cities by GDP. Europe's largest cities In 2023, Moscow was the largest european city, with a population of nearly 12.7 million. Paris was the largest city in western Europe, with a population of over 11 million, while London was Europe's third-largest city at 9.6 million inhabitants.

This table presents economic growth data (percentage volume changes of gross domestic product) and the contributions to economic growth by expenditure components.

Gross domestic product can be calculated as the sum of final consumptions, gross capital formation and net exports. This expenditure approach allows to estimate the contribution of the various components of final expenditure to the volume change of GDP. For estimating the contribution, final expenditure components have to be adjusted for the incorporated imports. The adjusted final expenditure components sum up to GDP and are the bases of the calculation of the contribution of GDP growth. The attribution of imports to final expenditure components is performed using input-output analysis.

Contributions of final expenditure to GDP are provided in percentage points of GDP growth.

Data available from 2016.

Status of the figures: Data of 2016 are final. Data of 2017 are provisional.

Changes as of June 22nd 2018: None. This is a new table. Statistics Netherlands has carried out a revision of the national accounts recently. New statistical sources and estimation methods have been used during the revision. This table provides the data after revision. It replaces table Contribution final expenditure to volume growth of GDP; NA, 1995-2016. For further information see section 3.

When will new figures be published? Provisional data are published 6 months after the end of the reporting year. Final data are released 18 months after the end of the reporting year.

The 'GDP Growth Rate QoQ Adv' in the USA refers to the preliminary estimate of the quarterly change in the Gross Domestic Product, expressed as a percentage.

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 statistic shows the projected top ten largest national economies in 2050. By 2050, China is forecasted to have a gross domestic product of over ** trillion U.S. dollars.