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

Eurostat code: educ_uoe_enrs02 · (2012 - 2023)

@eurostat.educ_uoe_enrs02

Table List

2 tables(488.48 KB)

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

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

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

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

226.08 KB
92586 rows
8 columns

freq Freq	unit Unit	isced11 Isced11	sex Sex	age Age	geo Geo	time_period Time Period	value Value
Annual	Number	Lower secondary education	Females	Total	Germany	2012	2304520
Annual	Number	Lower secondary education	Females	Unknown	Germany	2012
Annual	Number	Lower secondary education	Females	10 years	Germany	2012	200940
Annual	Number	Lower secondary education	Females	11 years	Germany	2012	356613
Annual	Number	Lower secondary education	Females	12 years	Germany	2012	373645
Annual	Number	Lower secondary education	Females	13 years	Germany	2012	383185
Annual	Number	Lower secondary education	Females	14 years	Germany	2012	391156
Annual	Number	Lower secondary education	Females	15 years	Germany	2012	315316
Annual	Number	Lower secondary education	Females	16 years	Germany	2012	169593
Annual	Number	Lower secondary education	Females	17 years	Germany	2012	63890


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

Share link

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