Early Leavers From Education And Training By Sex And Country Of Birth

Eurostat code: edat_lfse_02 · (2004 - 2024)

@eurostat.edat_lfse_02

Table List

2 tables(110.3 KB)

Early Leavers From Education And Training By Sex And Country Of Birth - Raw

Early Leavers From Education And Training By Sex And Country Of Birth - Unpivoted

Early Leavers From Education And Training By Sex And Country Of Birth - Unpivoted

@eurostat.edat_lfse_02.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.72 KB
20294 rows
9 columns

freq Freq	sex Sex	wstatus Wstatus	c_birth C Birth	age Age	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Females	Population	Foreign country	From 18 to 24 years	Percentage	Austria	2004	25.2
Annual	Females	Population	Foreign country	From 18 to 24 years	Percentage	Belgium	2004	29.5
Annual	Females	Population	Foreign country	From 18 to 24 years	Percentage	Switzerland	2004	21.2
Annual	Females	Population	Foreign country	From 18 to 24 years	Percentage	Cyprus	2004	35.1
Annual	Females	Population	Foreign country	From 18 to 24 years	Percentage	Czechia	2004	38.7
Annual	Females	Population	Foreign country	From 18 to 24 years	Percentage	Germany	2004	23.5
Annual	Females	Population	Foreign country	From 18 to 24 years	Percentage	Euro area – 20 countries (from 2023)	2004	27.4
Annual	Females	Population	Foreign country	From 18 to 24 years	Percentage	Greece	2004	36.7
Annual	Females	Population	Foreign country	From 18 to 24 years	Percentage	Spain	2004	42.9
Annual	Females	Population	Foreign country	From 18 to 24 years	Percentage	European Union - 27 countries (from 2020)	2004	26.6


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

Share link

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