Changes

Jump to navigation Jump to search
982 bytes added ,  09:23, 14 December 2020
no edit summary
Line 25: Line 25:  
Not sure how I can list the products with more than 1 ingredient.
 
Not sure how I can list the products with more than 1 ingredient.
    +
Another way to fin interlopers is by loooking for strange nutritional values, but that can also be due to wrongly entered data.
 +
 +
== Data quality ==
 
=== Fat percentage ===
 
=== Fat percentage ===
Another way to find interlopers (or wrong data) is to look at the [https://world.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=categories&tag_contains_0=contains&tag_0=olive%20oils&sort_by=unique_scans_n&page_size=20&axis_x=fat&graph_title=Olive%20oils%20(fat%20percentage)&graph=1 fat percentage].
+
A next step to correct wrong nutritional data, starting by looking at the [https://world.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=categories&tag_contains_0=contains&tag_0=olive%20oils&sort_by=unique_scans_n&page_size=20&axis_x=fat&graph_title=Olive%20oils%20(fat%20percentage)&graph=1 fat percentage].
 
[[File:D00F953F-3266-414D-B11C-D61B39DEB2DA.jpg|thumb]]
 
[[File:D00F953F-3266-414D-B11C-D61B39DEB2DA.jpg|thumb]]
 
There are 6 products with more than 100% fat, so lets correct those first. It easier to list those with a [https://world.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=categories&tag_contains_0=contains&tag_0=olive%20oils&nutriment_0=fat&nutriment_compare_0=gt&nutriment_value_0=100&sort_by=unique_scans_n&page_size=20&axis_x=fat query] and correct them.
 
There are 6 products with more than 100% fat, so lets correct those first. It easier to list those with a [https://world.openfoodfacts.org/cgi/search.pl?action=process&tagtype_0=categories&tag_contains_0=contains&tag_0=olive%20oils&nutriment_0=fat&nutriment_compare_0=gt&nutriment_value_0=100&sort_by=unique_scans_n&page_size=20&axis_x=fat query] and correct them.
Line 40: Line 43:  
* mixup between per serving and per 100g data
 
* mixup between per serving and per 100g data
 
* all nutritional values set to 0
 
* all nutritional values set to 0
* oil sprays for olive oil contain other ingredients to make it sprayable. As the serving is only 0.25g, the nutritional values per serving are all zero (thanks to rounding).
+
*
 +
 
 +
== Conclusions ==
 +
 
 +
=== New categories ===
 +
By looking more closely at all the products we can identify other categories. Only if there are a lot of products in each category or if the nutritional values deviate to much, it is worthwhile to create these new products
 +
* pure olive oils: the current olive oils category should be renamed to pure olive oils to indicate that these products contain only one ingredient. This helps also to distinguish from the other olive oils.
 +
* olive oil sprays for olive oil contain other ingredients to make it sprayable. As the serving is only 0.25g, the nutritional values per serving are all zero (thanks to rounding).
 +
* enhanced olive oils: these olive oils have added vitamins for children(?)
 +
* flavoured olive oils: these olive oils have added flavours (garlic, etc.)
 +
 
 +
=== Canonical fat percentages ===
 +
Many products use, what seems as, standard canonical values for nutritional values. Looking at the other products these seem not to reflect the real product.
3,393

edits

Navigation menu