4,124
edits
Changes
Jump to navigation
Jump to search
Line 25:
Line 25: + + + − 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].+ Line 40:
Line 43: − + + + + + + + + + + + + +
no edit summary
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 ===
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.
* 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.