About this Dataset

Happiness And Corruption 2015-2020

The purpose of this dataset is to calculate the world happiness score.

Finding correlations between other variables and possibly find which variable mostly affect the happiness rank would make it a good challenge. Please feel free to use this dataset and submit your answers.

CONTENT:
I preprocessed and aggregated all valid data for countries with existent data from year 2015 to 2020 using Pandas and i added the corruption perception index taken from transparency .
I then merged the datasets based on Country and Year to transform the data into a long data format!
Government_trust may already be taken from CPI scores , but CPI scores make it clearer to understand and contrast it with the dependent variable in our case happiness_score.

Acknowledgements:
I am grateful to the Sustainable Development Solutions Network's dataset for making it possible for us to contribute to their amazing study!

Note: You might want to add that I filled missing data with 0's.

Please check my data viz made with tableau for a quick overview.

Tables

Worldhappiness Corruption 2015–2020

@kaggle.eliasturk_world_happiness_based_on_cpi_20152020.worldhappiness_corruption_2015_2020

62.43 KB
792 rows
13 columns


CREATE TABLE worldhappiness_corruption_2015_2020 (
  "country" VARCHAR,
  "happiness_score" DOUBLE,
  "gdp_per_capita" DOUBLE,
  "family" DOUBLE,
  "health" DOUBLE,
  "freedom" DOUBLE,
  "generosity" DOUBLE,
  "government_trust" DOUBLE,
  "dystopia_residual" DOUBLE,
  "continent" VARCHAR,
  "year" BIGINT,
  "social_support" DOUBLE,
  "cpi_score" BIGINT
);