Pupils And Students Enrolled By Education Level, Sex And Age

Eurostat code: educ_uoe_enra02 · (2012 - 2023)

@eurostat.educ_uoe_enra02

Table List

2 tables(3.22 MB)

Pupils And Students Enrolled By Education Level, Sex And Age - Raw

Pupils And Students Enrolled By Education Level, Sex And Age - Unpivoted

Pupils And Students Enrolled By Education Level, Sex And Age - Unpivoted

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

1.57 MB
687250 rows
8 columns

freq Freq	unit Unit	age Age	sex Sex	isced11 Isced11	geo Geo	time_period Time Period	value Value
Annual	Number	Total	Females	Primary education	Germany	2012	1428630
Annual	Number	Total	Females	Lower secondary education	Germany	2012	2304520
Annual	Number	Total	Females	Upper secondary education	Germany	2012	1207048
Annual	Number	Total	Females	Post-secondary non-tertiary education	Germany	2012	261728
Annual	Number	Total	Females	Bachelor's or equivalent level	Germany	2012	84500
Annual	Number	Total	Females	Doctoral or equivalent level	Germany	2012	84500
Annual	Number	Total	Males	Primary education	Germany	2012	1508121
Annual	Number	Total	Males	Lower secondary education	Germany	2012	2464463
Annual	Number	Total	Males	Upper secondary education	Germany	2012	1438456
Annual	Number	Total	Males	Post-secondary non-tertiary education	Germany	2012	286371


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.