World Hapiness Report Analysis (Py, SPSS, Tableau)
Analytical Study of World Hapiness Report Using Python, SPSS, Tableau
@kaggle.abdullahalkamal_world_hapiness_report_2015_2019
Analytical Study of World Hapiness Report Using Python, SPSS, Tableau
@kaggle.abdullahalkamal_world_hapiness_report_2015_2019
CREATE TABLE data_2015 (
"country" VARCHAR,
"region" VARCHAR,
"rank_2015" BIGINT,
"score_2015" DOUBLE,
"gdp_2015" DOUBLE,
"family_2015" DOUBLE,
"life_expectancy_2015" DOUBLE,
"freedom_2015" DOUBLE,
"trust_2015" DOUBLE,
"generosity_2015" DOUBLE,
"dystopia_residual" DOUBLE
);
CREATE TABLE data_2016 (
"country" VARCHAR,
"region" VARCHAR,
"rank_2016" BIGINT,
"score_2016" DOUBLE,
"gdp_2016" DOUBLE,
"family_2016" DOUBLE,
"life_expectancy_2016" DOUBLE,
"freedom_2016" DOUBLE,
"trust_2016" DOUBLE,
"generosity_2016" DOUBLE,
"dystopia_residual" DOUBLE
);
CREATE TABLE data_2017 (
"country" VARCHAR,
"region" VARCHAR,
"rank_2017" BIGINT,
"score_2017" DOUBLE,
"gdp_2017" DOUBLE,
"family_2017" DOUBLE,
"life_expectancy_2017" DOUBLE,
"freedom_2017" DOUBLE,
"trust_2017" DOUBLE,
"generosity_2017" DOUBLE,
"dystopia_residual" DOUBLE
);
CREATE TABLE data_2018 (
"country" VARCHAR,
"region" VARCHAR,
"rank_2018" BIGINT,
"score_2018" DOUBLE,
"gdp_2018" DOUBLE,
"family_2018" DOUBLE,
"life_expectancy_2018" DOUBLE,
"freedom_2018" DOUBLE,
"trust_2018" DOUBLE,
"generosity_2018" DOUBLE
);
CREATE TABLE data_2019 (
"country" VARCHAR,
"region" VARCHAR,
"rank_2019" BIGINT,
"score_2019" DOUBLE,
"gdp_2019" DOUBLE,
"family_2019" DOUBLE,
"life_expectancy_2019" DOUBLE,
"freedom_2019" DOUBLE,
"trust_2019" DOUBLE,
"generosity_2019" DOUBLE
);
Anyone who has the link will be able to view this.