The idea of the data project is to extract and process some nutrient data of various food and drinks. I am interested in the composition with respect to macro- and micronutrients. In the end, a sum of nutrients should be represented by several plots showing the distribution of nutrients for the consumed food every day.
On the same hand, a csv file should be created to store the processed data and consumption information from every day.
The aim of the project is to work with the data provided, process the data and create a result file that can be used later to show the nutrient composition of your daily meals.
The Swiss Food Composition Database provided by the state of Swizzerland is used for the project. It is a database consisting of over 1000 different food and drinks and the nutrient composition of these.
| X1 | X2 | X3 | X4 | X5 | X6 | X7 | X8 | X9 | X10 |
|---|---|---|---|---|---|---|---|---|---|
| Schweizer Nährwertdatenbank – Generische Lebensmittel V6.5 (27.06.2023) | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| Korrigierte Version vom 17.08.2023 (Korrektur: Nährstoff “Zink”, Lebensmittel 13420 “Bier, alkoholfrei”) | NA | NA | NA | NA | NA | NA | NA | NA | NA |
| ID | ID V 4.0 | ID SwissFIR | Name | Synonyme | Kategorie | Dichte | Bezugseinheit | Energie, Kilojoule (kJ) | Herleitung des Wertes |
| 10533 | NA | NA | Agar Agar | NA | Verschiedenes/Gelier- und Bindemittel | NA | pro 100g essbarer Anteil | 641 | Automatisierte Berechnung |
| 10536 | NA | NA | Agavensirup | Agavendicksaft | Süssigkeiten/Zucker und Süssstoffe | NA | pro 100g essbarer Anteil | 1240 | Automatisierte Berechnung |
Entries of the data table are shown for the first ten out of 129 columns.
The complete data set is provided by and available at The Swiss Food Composition Database.
The data should be represented as various pie charts and histograms showing the total uptake of micro- and macronutrients with respect to numerous consumed food and drinks. Besides that, the progress in meeting ones daily demand of nutrient should be displayed.
I want to create a dynamic pie plot that shows the composition of consumed food and drinks with respect to macro- and micronutrients. Ideally, both are represented individually within one pie chart in a manner that at the edge of the circle, the respective progress with respect to the demand is shown.