Changes

Jump to navigation Jump to search
Line 102: Line 102:  
[[File:AppleJuicesPotassium230228.png|frameless|center|Potassium histogram for apple juices (28-feb-2023)]]
 
[[File:AppleJuicesPotassium230228.png|frameless|center|Potassium histogram for apple juices (28-feb-2023)]]
 
Potassium has a median of 105mg/100ml, 51-125mg/100ml for 80%. Wonder where the low values come from.
 
Potassium has a median of 105mg/100ml, 51-125mg/100ml for 80%. Wonder where the low values come from.
 +
 +
=== Observations ===
 +
* The nutritional data from the USDA import (?) is a mess. I had to correct many. Ideally the import should be redone without translation to international units, but with a very good filled serving field (more structure)
    
== Category Definition ==
 
== Category Definition ==
Line 123: Line 126:  
* vitamin C: < 60mg/100ml (need to check the effect of enriching)
 
* vitamin C: < 60mg/100ml (need to check the effect of enriching)
 
* potassium: < 150mg/100ml
 
* potassium: < 150mg/100ml
 +
 +
== Ingredients ==
 +
A product is to a large extent defined by the ingredients that have been used to create. These ingredients define to a large extent the category.
 +
 +
=== Missing ingredients ===
 +
The listed ingredients do not always correspond to the product:
 +
 +
* the listing of ''water'' implies concentrated apple juice and in turn ''apple juice from concentrate;''
 +
* It is impossible to detect the occurrence of ''pure apple juice'' AND ''apple juice from concentrate'' at the same time;
 +
* cider seems to imply the ingredient alcohol. In the use it is also a type of apple;
 +
 +
=== Inventory ===
 +
Most common ingredients tags are:
 +
 +
* pure apple juice
 +
* apple juice from concentrate
 +
* water, need to rehydrate the apple concentrate
 +
* ascorbic acid for vitamin C
 +
* potassium sorbate as a source of potassium and preservative
 +
* malic acid as a preservative
 +
* citric acid as a preservative
 +
* calcium lactate
 +
* flavouring
 +
* carbon dioxide
 +
 +
=== Recipes ===
 +
Often one or more ingredients are used to create a product. This is a recipe. In order to analyse these recipes, the products with ingredients were selected (1627 products) ([https://mirabelle.openfoodfacts.org/products?sql=select+rowid%2C+code%2C+url%2C+%0D%0Aingredients_text%2C+ingredients_tags%2C+ingredients_analysis_tags%0D%0Afrom+%5Ball%5D%0D%0Awhere+categories_tags+like+%22%25apple-juices%25%22+and+ingredients_tags+%21%3D+%22%22%0D%0A Mirabelle download]). A set analysis (all juices with ingredients) using [https://upset.multinet.app/?workspace=OFF&table=AppleJuices UpSet], gives the following main recipes:
 +
* pure apple juices (only) (37%);
 +
* apple juices from concentrate (only) (14%)
 +
* pure apple juices  + vitamin C (5%)
 +
* apple juices from concentrate + vitamin C (5%)
 +
* apple juices with flavouring (3%)
 +
* apple juices with preservatives (2%)
 +
 +
=== Conclusion ===
 +
401 products did not contain normalised ingredients, either the data is incorrect or the values are missing in the ingredients taxonomy. A lot of cleanup is still required.
 +
 +
The wrong main language introduces quite some errors as the ingredients can not be parsed;
 +
 +
== Characteristics ==
 +
Apple juice products often have labels or other claims on the packaging.
 +
=== Labels ===
 +
Several labels can currently been found ([https://world.openfoodfacts.org/category/apple-juices/labels/ the list]). Some are useful, but other unnecessary. A quick look at some labels:
 +
* ''organic'' (and variants) has 638 products;
 +
* ''vegan'' (and thus vegetarian) has 109 products. The filtering process might not be vegan, as [https://en.wikipedia.org/wiki/Isinglass isenglass] can be used;
 +
* ''no added sugar'' (326 products). The EU legislation does not allow any added sugar, so it is not really necessary. But this label might be useful for other countries.
 +
* ''no preservatives'' (245 products) - preservatives are allowed by EU legislation (think antioxidants like malic acid, citric acid or ascorbic acid), so it might fe found in the ingredients list. This label could be added if these ingredients are not on the package.
 +
* ''no colorings'' (151 products) - are there products that do have colorings?
 +
* ''EU Agriculture'' (and variants) (103 products) - should also be in the origin field.
 +
* ''pure juice'' (70 products) - this is not a label
 +
* ''no additives'' (51 products) - This seems the same as pure juice. This can be added based on the ingredient list?
 +
* ''Demeter'' (34 products) - this is not a label, but a brand?
 +
* ''low or no sugar'' (27 products) - these seem be wrongly labelled and should read ''no added sugar''.
 +
* ''no gluten'' (25 products) - seems unnecessary.
 +
* ''no artificial flavours'' (12 products) - might be useful, there might be products that have flavouring
 +
* ''no GMOs'' (11 products) - are the apples that are GMO? Or is this just marketing?
 +
* ''kosher'' (10 products) - assume that a  production process can be non-kosher.
 +
* ''fair trade'' (7 products) - guess that farmers are better paid.
 +
* ''pasteurized product'' (7 products) - useful label (why so few?).
 +
* ''no alcohol'' (6 products) - so it is not a cider, sounds like a default label
 +
* ''100% natural'' (5 products) - does this mean anything?
 +
* ''rich in vitamin C'' (5 products) - when can a juice be called rich? What is the value of this claim?
 +
 +
=== Missing labels ===
 +
There are a few labels that have not been used, but might be useful
 +
* ''artisanal fabrication'' - this is seen on many juices.
 +
* ''filtering'' - some products are not filtered and are thus cloudy. This is not stated on the ingredients, but might be found in the product name (trouble).
 +
* ''pasteurisation'' - add ''pasteurized'' or ''unpasteurized''
 +
* ''extraction'' - ''cold pressed''
 +
 +
=== Observations ===
 +
* when should something be added as a label, an adjective of an ingredient, or even a dedicated category?
 +
* there are implied labels, like ''no lactose'', ''no gluten''. How can this be expressed? It can be part of the category definition and noted in the taxonomy.
    
== Quality Monitoring ==
 
== Quality Monitoring ==
Line 128: Line 204:     
This envelop can be used to monitor new additions to this category. And anything that falls outside the envelope can be flagged for inspection.
 
This envelop can be used to monitor new additions to this category. And anything that falls outside the envelope can be flagged for inspection.
 +
 +
== OFFwiki ==
 +
Using this analysis (and other information) it might be possible to create a kind of (structured) wikipage for this category. This might comprise:
 +
* definition - what is an apple juice (process, ingredients, origin)?
 +
* characteristics - what defines an apple juice (ingredients, nutritional values, labels)
 +
* related categories - what categories are related?
 +
* determination - helping the user to classify and characterise a likely apple juice product.
 +
 +
A first attempt: [[Category/Apple juices]]
 +
[[Category:Global_Taxonomies]]
3,393

edits

Navigation menu