Satisfaction With The Dwelling By Level Of Satisfaction, Sex, Age And Educational Attainment

Eurostat code: ilc_pw17 · (2023 - 2023)

@eurostat.ilc_pw17

Table List

2 tables(82.59 KB)

Satisfaction With The Dwelling By Level Of Satisfaction, Sex, Age And Educational Attainment - Raw

Satisfaction With The Dwelling By Level Of Satisfaction, Sex, Age And Educational Attainment - Unpivoted

Satisfaction With The Dwelling By Level Of Satisfaction, Sex, Age And Educational Attainment - Unpivoted

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

41.7 KB
24340 rows
9 columns

freq Freq	isced11 Isced11	lev_satis Lev Satis	age Age	sex Sex	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Less than primary, primary and lower secondary education (levels 0-2)	Good	From 16 to 24 years	Females	Percentage	Austria	2023	34
Annual	Less than primary, primary and lower secondary education (levels 0-2)	Good	From 16 to 24 years	Females	Percentage	Belgium	2023	57.1
Annual	Less than primary, primary and lower secondary education (levels 0-2)	Good	From 16 to 24 years	Females	Percentage	Bulgaria	2023	67.5
Annual	Less than primary, primary and lower secondary education (levels 0-2)	Good	From 16 to 24 years	Females	Percentage	Cyprus	2023	58.7
Annual	Less than primary, primary and lower secondary education (levels 0-2)	Good	From 16 to 24 years	Females	Percentage	Czechia	2023	65.3
Annual	Less than primary, primary and lower secondary education (levels 0-2)	Good	From 16 to 24 years	Females	Percentage	Germany	2023	53.6
Annual	Less than primary, primary and lower secondary education (levels 0-2)	Good	From 16 to 24 years	Females	Percentage	Denmark	2023	34.4
Annual	Less than primary, primary and lower secondary education (levels 0-2)	Good	From 16 to 24 years	Females	Percentage	Euro area – 20 countries (from 2023)	2023	57.2
Annual	Less than primary, primary and lower secondary education (levels 0-2)	Good	From 16 to 24 years	Females	Percentage	Estonia	2023	53.6
Annual	Less than primary, primary and lower secondary education (levels 0-2)	Good	From 16 to 24 years	Females	Percentage	Greece	2023	71.9


CREATE TABLE tidy (
  "freq" VARCHAR,
  "isced11" VARCHAR,
  "lev_satis" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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