Name: WORLD DATA By Country (2020)
Creator: Kaggle
License: https://creativecommons.org/licenses/by-sa/4.0/

About this Dataset

WORLD DATA By Country (2020)

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.

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 :

Criterion	File
GDP per capita	df_{GDP}
Population growth	df_{Pop-Growth}
Life expectancy	df_{Life-exp}
Median age	df_{Med-age}
Meat consumption	df_{Meat-cons}
Sex-ratio	df_{GDP}
Suicide rate	df_{Suicide}
Urbanization	df_{Urban}
Fertility rate	df_{Fertile}

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

Pipeline

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

$$ \text{Enjoy !}$$

Tables

Fertility

@kaggle.daniboy370_world_data_by_country_2020.fertility

6.24 KB
201 rows
3 columns


CREATE TABLE fertility (
  "country" VARCHAR,
  "fertility" DOUBLE,
  "iso_code" VARCHAR
);

Gdp Per Capita

@kaggle.daniboy370_world_data_by_country_2020.gdp_per_capita

6.95 KB
191 rows
3 columns


CREATE TABLE gdp_per_capita (
  "country" VARCHAR,
  "gdp_per_capita" DOUBLE,
  "iso_code" VARCHAR
);

Life Expectancy

@kaggle.daniboy370_world_data_by_country_2020.life_expectancy

6.45 KB
185 rows
3 columns


CREATE TABLE life_expectancy (
  "country" VARCHAR,
  "life_expectancy" DOUBLE,
  "iso_code" VARCHAR
);

Meat Consumption

@kaggle.daniboy370_world_data_by_country_2020.meat_consumption

6.73 KB
187 rows
3 columns


CREATE TABLE meat_consumption (
  "country" VARCHAR,
  "meat_consumption" DOUBLE,
  "iso_code" VARCHAR
);

Median Age

@kaggle.daniboy370_world_data_by_country_2020.median_age

7.21 KB
223 rows
3 columns


CREATE TABLE median_age (
  "country" VARCHAR,
  "median_age" DOUBLE,
  "iso_code" VARCHAR
);

Population Growth

@kaggle.daniboy370_world_data_by_country_2020.population_growth

7.01 KB
207 rows
3 columns


CREATE TABLE population_growth (
  "country" VARCHAR,
  "population_growth" DOUBLE,
  "iso_code" VARCHAR
);

Sex Ratio

@kaggle.daniboy370_world_data_by_country_2020.sex_ratio

6.73 KB
226 rows
3 columns


CREATE TABLE sex_ratio (
  "country" VARCHAR,
  "sex_ratio" DOUBLE,
  "iso_code" VARCHAR
);

Suicide Rate

@kaggle.daniboy370_world_data_by_country_2020.suicide_rate

6.21 KB
182 rows
3 columns


CREATE TABLE suicide_rate (
  "country" VARCHAR,
  "suicide_rate" DOUBLE,
  "iso_code" VARCHAR
);

Urbanization Rate

@kaggle.daniboy370_world_data_by_country_2020.urbanization_rate

7.4 KB
218 rows
3 columns


CREATE TABLE urbanization_rate (
  "country" VARCHAR,
  "urbanization_rate" DOUBLE,
  "iso_code" VARCHAR
);