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

Eurostat code: edat_lfse_02$dv_1868

@eurostat.edat_lfse_02_dv_1868

Table List

2 tables(92.48 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_dv_1868.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.

33.17 KB
16727 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	Reporting country	From 18 to 24 years	Percentage	Austria	2004	6.5
Annual	Females	Population	Reporting country	From 18 to 24 years	Percentage	Belgium	2004	9
Annual	Females	Population	Reporting country	From 18 to 24 years	Percentage	Switzerland	2004	5.5
Annual	Females	Population	Reporting country	From 18 to 24 years	Percentage	Cyprus	2004	9.7
Annual	Females	Population	Reporting country	From 18 to 24 years	Percentage	Czechia	2004	6.2
Annual	Females	Population	Reporting country	From 18 to 24 years	Percentage	Germany	2004	9.3
Annual	Females	Population	Reporting country	From 18 to 24 years	Percentage	Denmark	2004	6.9
Annual	Females	Population	Reporting country	From 18 to 24 years	Percentage	Euro area – 20 countries (from 2023)	2004	12.4
Annual	Females	Population	Reporting country	From 18 to 24 years	Percentage	Estonia	2004	8.2
Annual	Females	Population	Reporting country	From 18 to 24 years	Percentage	Greece	2004	8.9


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.