Pupils Enrolled In Upper-secondary Education By Programme Orientation, Sex And Age

Eurostat code: educ_uoe_enrs05$dv_2144

@eurostat.educ_uoe_enrs05_dv_2144

Table List

2 tables(84.08 KB)

Pupils Enrolled In Upper-secondary Education By Programme Orientation, Sex And Age - Raw

Pupils Enrolled In Upper-secondary Education By Programme Orientation, Sex And Age - Unpivoted

Pupils Enrolled In Upper-secondary Education By Programme Orientation, Sex And Age - Unpivoted

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

39.33 KB
5497 rows
8 columns

freq Freq	unit Unit	age Age	sex Sex	isced11 Isced11	geo Geo	time_period Time Period	value Value
Annual	Number	15 years	Total	Upper secondary education	Austria	2014	76273
Annual	Number	15 years	Total	Upper secondary education	Belgium	2014	108113
Annual	Number	15 years	Total	Upper secondary education	Bulgaria	2014	50294
Annual	Number	15 years	Total	Upper secondary education	Switzerland	2014	22370
Annual	Number	15 years	Total	Upper secondary education	Cyprus	2014	8655
Annual	Number	15 years	Total	Upper secondary education	Czechia	2014	40630
Annual	Number	15 years	Total	Upper secondary education	Germany	2014	154456
Annual	Number	15 years	Total	Upper secondary education	Denmark	2014	634
Annual	Number	15 years	Total	Upper secondary education	Estonia	2014	176
Annual	Number	15 years	Total	Upper secondary education	Greece	2014	90807


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

Share link

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