Consumption Of Fruits By Sex, Age And Educational Attainment Level (%)

Eurostat code: hlth_ehis_de7 · (2008 - 2008)

@eurostat.hlth_ehis_de7

Table List

2 tables(43.25 KB)

Consumption Of Fruits By Sex, Age And Educational Attainment Level (%) - Raw

Consumption Of Fruits By Sex, Age And Educational Attainment Level (%) - Unpivoted

Consumption Of Fruits By Sex, Age And Educational Attainment Level (%) - Unpivoted

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

21.92 KB
8736 rows
8 columns

freq Freq	sex Sex	age Age	frequenc Frequenc	isced97 Isced97	geo Geo	time_period Time Period	value Value
Annual	Females	Total	From 1 to 3 times a week	Pre-primary, primary and lower secondary education (levels 0-2)	Belgium	2008	6.9
Annual	Females	Total	From 1 to 3 times a week	Pre-primary, primary and lower secondary education (levels 0-2)	Bulgaria	2008	24.1
Annual	Females	Total	From 1 to 3 times a week	Pre-primary, primary and lower secondary education (levels 0-2)	Cyprus	2008	11.9
Annual	Females	Total	From 1 to 3 times a week	Pre-primary, primary and lower secondary education (levels 0-2)	Czechia	2008	15.6
Annual	Females	Total	From 1 to 3 times a week	Pre-primary, primary and lower secondary education (levels 0-2)	Estonia	2008	16.8
Annual	Females	Total	From 1 to 3 times a week	Pre-primary, primary and lower secondary education (levels 0-2)	Greece	2008	12
Annual	Females	Total	From 1 to 3 times a week	Pre-primary, primary and lower secondary education (levels 0-2)	Spain	2008	9.8
Annual	Females	Total	From 1 to 3 times a week	Pre-primary, primary and lower secondary education (levels 0-2)	France	2008	6.2
Annual	Females	Total	From 1 to 3 times a week	Pre-primary, primary and lower secondary education (levels 0-2)	Hungary	2008	12.2
Annual	Females	Total	From 1 to 3 times a week	Pre-primary, primary and lower secondary education (levels 0-2)	Latvia	2008	24.6


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

Share link

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