Difference between revisions of "Data quality issues which can't be fixed"
(Refactoring) |
(en:energy-value-in-kcal-does-not-match-value-in-kj : documentation and solution) |
||
| Line 105: | Line 105: | ||
== en:energy-value-in-kcal-does-not-match-value-in-kj == | == en:energy-value-in-kcal-does-not-match-value-in-kj == | ||
| − | === When | + | === When energy values are low (1-10 Kcal) === |
| − | + | When energy values are low, there are often matching issues between the energy in Kcal and KJ. This often because producers are rounding the values. | |
| − | '''Solution or workaround | + | Eg. |
| + | |||
| + | * https://world.openfoodfacts.org/product/3502110008459: In this example, 1 Kcal (rounded) => 6 KJ. Because 6 / 4.2 = '''1.428''', the producer is probably '''rounding 1.42 to 1'''. | ||
| + | |||
| + | '''Solution or workaround''': use the values per serving if the serving is higher than 100g/100ml. | ||
'''Action''': | '''Action''': | ||
| − | '''Github issue''': | + | '''Github issue''': |
[[Category:Data quality]] | [[Category:Data quality]] | ||
Revision as of 11:14, 7 December 2022
en:nutrition-value-over-105-fruits-vegetables-nuts-estimate-from-ingredients
When the package contains more than one product
When the package contains more than one product, each product can have its own list of ingredients. Then fruits and vegetables estimated value from ingredient goes over 105.
Eg.:
- https://world.openfoodfacts.org/product/3229820141947
- https://world.openfoodfacts.org/product/3608580806141/
- https://world.openfoodfacts.org/product/3021762412464/
- https://world.openfoodfacts.org/product/3560070969852
- https://world.openfoodfacts.org/product/3021762416769
Solution or workaround: none.
Action: the products can be tagged with ingredient_list:multiple.
Github issue: [to be created?]
en:nutrition-value-total-over-105
When the product density is greater than the water
When the product density is greater than the water and the weight displayed for 100ml, the total of the ingredients can be greater than 105.
Eg. https://world.openfoodfacts.org/product/20271343/sirop-d-agave-bio-sonne
Solution or workaround: [to be discussed]
Action: the products can be tagged with nutrition_facts:per_ml
Github issue: [to be created?]
en:nutrition-value-over-105-en-dry-residue-at-180-c
When? The product is water?
Eg. https://world.openfoodfacts.org/product/4056489194446
Solution or workaround: should we check the box "Nutrition facts are not specified on the product."?
en:energy-value-in-kj-does-not-match-value-computed-from-other-nutrients & en:energy-value-in-kcal-does-not-match-value-computed-from-other-nutrients
When? Sugar or equivalents?
Eg.:
- https://world.openfoodfacts.org/product/3329757003735
- https://world.openfoodfacts.org/product/3165437400001
- https://world.openfoodfacts.org/product/3329757003957/
Solution or workaround: there is no solution. The producer did not mention that the products contains ingredients that should not be counted to compute the energy. For example, if a product is Stevia and contains 99g/100g of carbs, there should not be counted because stevia is not providing any energy.
Action: the product could be tagged with use data_quality:lack_of_data_to_compute_energy ????
Github issue: https://github.com/openfoodfacts/openfoodfacts-server/issues/7789
When? Soup or equivalents?
Eg.:
- https://world.openfoodfacts.org/product/4104420137264
- https://world.openfoodfacts.org/product/8480000073136
Solution or workaround:
Action:
Github issue:
When? Vinegar or equivalents?
Eg. https://world.openfoodfacts.org/product/3182384011012
Solution or workaround:
Action:
Github issue:
When? Tea or equivalents?
Eg. https://world.openfoodfacts.org/product/4056489024354
Solution or workaround:
Action:
Github issue:
When? Can not see the nutrition table in the pictures
Eg. https://world.openfoodfacts.org/product/8480000325242/aroma-de-vainilla-hacendado
Solution or workaround: no workaround. Don't copy data from other sources. Our data should be based on our photos.
Action:
- erase all nutrition facts' values.
- remove nutrition facts' picture if it is not correct.
Github issue: -
When?
Eg. https://world.openfoodfacts.org/product/4056489123514/
Solution or workaround:
Action:
Github issue:
en:energy-value-in-kcal-does-not-match-value-in-kj
When energy values are low (1-10 Kcal)
When energy values are low, there are often matching issues between the energy in Kcal and KJ. This often because producers are rounding the values.
Eg.
- https://world.openfoodfacts.org/product/3502110008459: In this example, 1 Kcal (rounded) => 6 KJ. Because 6 / 4.2 = 1.428, the producer is probably rounding 1.42 to 1.
Solution or workaround: use the values per serving if the serving is higher than 100g/100ml.
Action:
Github issue: