Number Of Foreign Languages Known (self-reported) By Sex

Eurostat code: edat_aes_l21$dv_1602

@eurostat.edat_aes_l21_dv_1602

Table List

2 tables(30.51 KB)

Number Of Foreign Languages Known (self-reported) By Sex - Raw

Number Of Foreign Languages Known (self-reported) By Sex - Unpivoted

Number Of Foreign Languages Known (self-reported) By Sex - Unpivoted

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

13.18 KB
3081 rows
8 columns

freq Freq	age Age	n_lang N Lang	unit Unit	sex Sex	geo Geo	time_period Time Period	value Value
Annual	From 25 to 64 years	No languages	Percentage	Females	Austria	2007	20.1
Annual	From 25 to 64 years	No languages	Percentage	Females	Belgium	2007	33.6
Annual	From 25 to 64 years	No languages	Percentage	Females	Bulgaria	2007	42.7
Annual	From 25 to 64 years	No languages	Percentage	Females	Cyprus	2007	16.7
Annual	From 25 to 64 years	No languages	Percentage	Females	Czechia	2007	29.6
Annual	From 25 to 64 years	No languages	Percentage	Females	Germany	2007	28.6
Annual	From 25 to 64 years	No languages	Percentage	Females	Denmark	2007	12
Annual	From 25 to 64 years	No languages	Percentage	Females	Euro area – 20 countries (from 2023)	2007	35.6
Annual	From 25 to 64 years	No languages	Percentage	Females	Estonia	2007	11.3
Annual	From 25 to 64 years	No languages	Percentage	Females	Greece	2007	43.6


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

Share link

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