Proportion Of Consumption Decile By Income Decile - Experimental Statistics

Eurostat code: icw_sr_07 · (2010 - 2020)

@eurostat.icw_sr_07

Table List

2 tables(39.98 KB)

Proportion Of Consumption Decile By Income Decile - Experimental Statistics - Raw

Proportion Of Consumption Decile By Income Decile - Experimental Statistics - Unpivoted

Proportion Of Consumption Decile By Income Decile - Experimental Statistics - Unpivoted

@eurostat.icw_sr_07.tidy

This table contains the same data as the raw table, but in a tidy format: time period values are unpivoted into rows under a single time_period column, making the dataset easier to analyze and visualize.

18.08 KB
8600 rows
7 columns

freq Freq	quant_expn Quant Expn	quant_inc Quant Inc	unit Unit	geo Geo	time_period Time Period	value Value
Annual	First decile	First decile	Percentage of households	Austria	2010	42.5
Annual	First decile	First decile	Percentage of households	Belgium	2010	43.2
Annual	First decile	First decile	Percentage of households	Cyprus	2010	64.7
Annual	First decile	First decile	Percentage of households	Czechia	2010	62.2
Annual	First decile	First decile	Percentage of households	Germany	2010	65.4
Annual	First decile	First decile	Percentage of households	Denmark	2010	36.3
Annual	First decile	First decile	Percentage of households	Estonia	2010	38.3
Annual	First decile	First decile	Percentage of households	Greece	2010	35.6
Annual	First decile	First decile	Percentage of households	Spain	2010	47
Annual	First decile	First decile	Percentage of households	Finland	2010	41.2


CREATE TABLE tidy (
  "freq" VARCHAR,
  "quant_expn" VARCHAR,
  "quant_inc" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

Anyone who has the link will be able to view this.