Daily Consumption Of Fruit & Vegetables In Europe
Eating healthy in Europe: daily consumption by sex, age and educational level
@kaggle.gpreda_daily_consumption_of_fruit_vegetables_in_europe
Eating healthy in Europe: daily consumption by sex, age and educational level
@kaggle.gpreda_daily_consumption_of_fruit_vegetables_in_europe
This dataset is compiled from European data about Determinants of Health / Daily consumption of fruit and vegetables by sex, age and educational attainment level.
The data contains information on Determinants of Health / Daily consumption of fruit and vegetables by sex, age and educational attainment level.
The data is provided both in the original tsv format and in csv format (after melting the years data, to transform from columns to rows). The dataset has also attached the notebook to perform this transformation (https://www.kaggle.com/gpreda/eating-healthy-in-europe-daily-fruit-vegetables).
Geographies values are acronyms (2 characters) for EU countries and group of countries from Europe.
Source of metadata: https://ec.europa.eu/eurostat/ramon/cybernews/abbreviations.htm
The main data source is: https://ec.europa.eu/eurostat/data/database
For the data dictionaries, the source is: https://ec.europa.eu/eurostat/estat-navtree-portlet-prod/BulkDownloadListing?sort=1&dir=dic%2Fen as well: https://ec.europa.eu/eurostat/ramon/cybernews/abbreviations.htm
CREATE TABLE daily_consumption_fruit_vegetables_eu (
"unit" VARCHAR,
"n_portion" VARCHAR,
"sex" VARCHAR,
"age" VARCHAR,
"country" VARCHAR,
"time" BIGINT,
"value" DOUBLE
);Anyone who has the link will be able to view this.