Aggregate Propensity To Consume By Income Quintile - Experimental Statistics

Eurostat code: icw_sr_10 · (2010 - 2020)

@eurostat.icw_sr_10

Table List

2 tables(16.29 KB)

Aggregate Propensity To Consume By Income Quintile - Experimental Statistics - Raw

Aggregate Propensity To Consume By Income Quintile - Experimental Statistics - Unpivoted

Aggregate Propensity To Consume By Income Quintile - Experimental Statistics - Unpivoted

@eurostat.icw_sr_10.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.

7.67 KB
515 rows
6 columns

freq Freq	quant_inc Quant Inc	unit Unit	geo Geo	time_period Time Period	value Value
Annual	First quintile	Percentage of disposable income	Austria	2010	162.7
Annual	First quintile	Percentage of disposable income	Belgium	2010	140.4
Annual	First quintile	Percentage of disposable income	Bulgaria	2010	102.9
Annual	First quintile	Percentage of disposable income	Cyprus	2010	114.7
Annual	First quintile	Percentage of disposable income	Czechia	2010	92.6
Annual	First quintile	Percentage of disposable income	Germany	2010	127.4
Annual	First quintile	Percentage of disposable income	Denmark	2010	207.7
Annual	First quintile	Percentage of disposable income	Estonia	2010	107
Annual	First quintile	Percentage of disposable income	Greece	2010	180.3
Annual	First quintile	Percentage of disposable income	Spain	2010	160.1


CREATE TABLE tidy (
  "freq" 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.