Ratio Of Pupils To Teachers And Teacher Aides By Education Level And Programme Orientation

Eurostat code: educ_uoe_perp05 · (2013 - 2023)

@eurostat.educ_uoe_perp05

Table List

2 tables(23.15 KB)

Ratio Of Pupils To Teachers And Teacher Aides By Education Level And Programme Orientation - Raw

Ratio Of Pupils To Teachers And Teacher Aides By Education Level And Programme Orientation - Unpivoted

Ratio Of Pupils To Teachers And Teacher Aides By Education Level And Programme Orientation - Unpivoted

@eurostat.educ_uoe_perp05.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.79 KB
1371 rows
6 columns

freq Freq	isced11 Isced11	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Early childhood education	Rate	France	2013	16.4
Annual	Early childhood education	Rate	Malta	2013	8.4
Annual	Early childhood education	Rate	Slovenia	2013	8.1
Annual	Early childhood educational development	Rate	Slovenia	2013	6.2
Annual	Pre-primary education	Rate	Greece	2013	11.9
Annual	Pre-primary education	Rate	France	2013	16.4
Annual	Pre-primary education	Rate	Hungary	2013	11.2
Annual	Pre-primary education	Rate	Malta	2013	8.4
Annual	Pre-primary education	Rate	Portugal	2013	16.6
Annual	Pre-primary education	Rate	Romania	2013	15.6


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

Share link

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