File size: 1,966 Bytes
1cd137c | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 | from __future__ import annotations
import pandas as pd
REQUIRED_NUTRI_SCORE_FIELDS = [
"calories_per_100g",
"sugars_g_per_100g",
"saturated_fat_g_per_100g",
"sodium_mg_per_100g",
"fibre_g_per_100g",
"protein_g_per_100g",
]
EXCLUDED_TAXONOMIES = {
"BABY_CARE",
}
EXCLUDED_DOMAINS = {
"non_food",
}
def _is_missing(value) -> bool:
return pd.isna(value)
def check_score_eligibility(row: pd.Series) -> tuple[bool, str | None]:
"""Determine whether a product can enter the Nutri-Score calculation."""
domain = row.get("domain")
taxonomy = row.get("taxonomy")
nutrition_status = row.get("nutrition_quality_status")
if domain in EXCLUDED_DOMAINS:
return False, "NON_FOOD"
if pd.isna(domain) or domain == "unknown":
return False, "UNKNOWN_DOMAIN"
if taxonomy in EXCLUDED_TAXONOMIES:
return False, "NUTRI_SCORE_EXCLUDED_CATEGORY"
if nutrition_status == "NO_SOURCE_DATA":
return False, "NO_SOURCE_DATA"
missing_required = [
field
for field in REQUIRED_NUTRI_SCORE_FIELDS
if _is_missing(row.get(field))
]
if missing_required:
return False, "MISSING_REQUIRED_FIELDS"
suspicious_fields = row.get("suspicious_fields")
if isinstance(suspicious_fields, (list, tuple, set)):
relevant_suspicious = set(suspicious_fields) & {
"calories",
"sugars_g",
"saturated_fat_g",
"sodium_mg",
"fibre_g",
"protein_g",
}
if relevant_suspicious:
return False, "SUSPICIOUS_REQUIRED_INPUT"
return True, None
def add_eligibility_columns(df: pd.DataFrame) -> pd.DataFrame:
result = df.copy()
eligibility = result.apply(check_score_eligibility, axis=1)
result["score_eligibility"] = eligibility.map(lambda x: x[0])
result["score_exclusion_reason"] = eligibility.map(lambda x: x[1])
return result
|