Script to scrap the CREA Food Composition Tables present on https://www.alimentinutrizione.it/

crea_scrapper.py

import pandas as pd
import urllib.request
import re
import json
import copy


def translate_template(translation_path, template_path, output_path):
    """Translate a file using a dictionary and save the result on file

    Translate the content of template the using the JSON formatted translation file
    and save the output on output file

    Args:
        translation_path: path to the translation file
        template_path: path to the template file
        output_path: path to the output file
    """

    translation_file = open(translation_path)
    template_file = open(template_path)
    output_file = open(output_path, "w")
    
    try:
        translation = json.load(translation_file)
        template = template_file.read()

        for k, v in translation.items():
            template = template.replace(f'"{str(k.encode("unicode_escape").decode())}"', f'"{v}"')

        template = template.replace(r"Attivit\u00e0 antiossidante (mmol)", "antioxidant_activity")
        output_file.write(template)
    finally:
        translation_file.close()
        template_file.close()
        output_file.close()


def create_default_row_form_template(translation_path, template_path):
    """Create from a template the empty row used to fill the output df

    Read the template keys and create a dict with key the name of the column
    and value the default value for that column

    Args:
        translation_path: path to the translation file
        template_path: path to the template file

    Returns:
        The a dict that represent the dafault row of the df
    """

    translation_file = open(translation_path)
    template_file = open(template_path)
    
    row = {}
    try:
        translation = json.load(translation_file)
        template = json.load(template_file)

        for k, v in template.items():
            if (type(v) != list):
                row[k] = v
            elif (k != translation["Codice Langual"]):
                for i in v:
                    row[i[translation["Descrizione Nutriente"]]] = i[translation["Valore per 100 g"]]
    finally:
        translation_file.close()
        template_file.close()
    
    return row


def get_all_nutrient_names(url):
    """Return a list of all nutrient names

    Send a get request to the url and parse find all nutrient names

    Args:
        url: a string containing the base url of the site
        
    Returns:
        A list with all nutrient names
    """
    
    html = urllib.request.urlopen(f"{url}/tabelle-nutrizionali/ricerca-per-nutriente").read().decode("utf8")
    return re.findall(r'<option value="\d*?">(.*?)</option>', html, re.DOTALL)


URL = r"https://www.alimentinutrizione.it"
TRANSLATION_PATH = r".\translation.json"
TEMPLATE_PATH = r".\template_crea_en.json"

JSON_DATASET_PATH = r".\crea_food_composition_tables.json"
CSV_DATASET_PATH = r".\crea_food_composition_tables.csv"
XLSX_DATASET_PATH = r".\crea_food_composition_tables.xlsx"
RECIPES_DATASET_PATH = r".\crea_recipes.json"

# clear json file before appending
open(JSON_DATASET_PATH, "w").close()
output_json = open(JSON_DATASET_PATH, "a")

open(RECIPES_DATASET_PATH, "w").close()
recipes_json = open(RECIPES_DATASET_PATH, "a")

# oper translation and template files
translation_file = open(TRANSLATION_PATH)
translation = json.load(translation_file)

template_file = open(TEMPLATE_PATH)
template = json.load(template_file)

default_row = create_default_row_form_template(TRANSLATION_PATH, TEMPLATE_PATH)
output_df = pd.DataFrame(columns=default_row.keys())

# download all ids
content = urllib.request.urlopen(f"{URL}/tabelle-nutrizionali/ricerca-per-ordine-alfabetico").read().decode("utf8")
id = sorted(set(re.findall(r'<a href="/tabelle-nutrizionali/(.{6})">', content)))

counter = 0
for i in id:
    try:
        content = urllib.request.urlopen(f"{URL}/tabelle-nutrizionali/{i}")
    except urllib.error.HTTPError as e:
        print(f"{e}: {i}")
    else:
        counter += 1
        print(f"{content.getcode()}: {i} [{counter} / {len(id)}]")

        html = content.read().decode("utf8")

        # get all html tables in the page
        tables = re.findall(r'<table.*?</table>', html, re.DOTALL)

        # parse recipes tables if presents
        if len(tables) == 5:
            ingredients, preparation = tables[1:3]
            ingredients = re.findall(r'<tr class="corporicetta"><td>(.*?)</td><td>(.*?)</td></tr>', ingredients, re.DOTALL)
            preparation = re.findall(r'<tr class="(?:descricetta|corporicetta)"><t[dh]>(.*?)</t[dh]>', preparation, re.DOTALL)

            portions = ingredients.pop(0)[0] if ingredients[0][0].startswith("PER") else ""

            recipe = {"food_code": i, "portions": portions, "preparation": preparation[0]}
            recipe["ingredients"] = [{"name": i[0].strip(), "quantity": i[1].strip()} for i in ingredients]
            recipe["info"] = [{"description": preparation[i].strip(), "value": preparation[i+1].strip()} for i in range(1, len(preparation), 2)]

            recipes_json.write(json.dumps(recipe, ensure_ascii=True, separators=(',', ':'), indent=None) + "\n")

            tables = tables[:1] + tables[3:]

        # cast the summary table to dataframe and fill all NaN with ""
        summary = pd.read_html(tables[0])[0]
        summary.fillna("", inplace=True)

        # split all references string with \t
        regex_references = r'(?<!\w&nbsp;)<i class="fa fa-info" tabindex="0" role="button" data-toggle="popover" data-trigger="focus" data-placement="top" title="" data-content="(.*?)"></i>&nbsp;'
        tables[1] = re.sub(regex_references, r'\1\t', tables[1])

        # cast the data table to dataframe, remove useless columns and fill all NaN with ""
        nutrient = pd.read_html(tables[1])[0]
        nutrient.drop(nutrient.columns[[1, 3, 4, 5]], axis=1, inplace=True)
        nutrient.fillna("", inplace=True)

        # find all the langual codes and descriptions
        regex_langual = r'<i class="fa fa-info postag" tabindex="0" role="button" data-toggle="popover" data-trigger="focus" data-placement="top" title="" data-content="(.*?)"> \| (.*?)</i>'
        langual = re.findall(regex_langual, html)

        # find the photo url
        regex_photo = r'<div class="pull-left item-image article-image article-image-full">\s*<img\s*src="(.*?)"\s*alt=""\s*class="img-responsive"\s*itemprop="image"/>\s*</div>'
        photo = re.findall(regex_photo, html, re.DOTALL)[0]
        
        # deepcopy the new JSON and CSV line
        new_json = copy.deepcopy(template)
        new_row = copy.deepcopy(default_row)
        
        # set the name and image url
        new_json[translation["Nome"]] = new_row[translation["Nome"]] = summary.columns[0]
        new_json[translation["Immagine"]] = new_row[translation["Immagine"]] = f"{URL}{photo}"

        # set the summary data
        for _, r in summary.iterrows():
            if r[0] in ["Numero Campioni", "Parte Edibile", "Porzione"]:
                r[1] = int(re.sub("[^0-9]", "", r[1]))
                r[1] = r[1] / 100 if r[0] == "Parte Edibile" else r[1]
            new_json[translation[r[0]]] = new_row[translation[r[0]]] = r[1]

        # set the langual codes data
        new_json[translation["Codice Langual"]].clear()
        for i in langual:
            new_json[translation["Codice Langual"]].append({"id" : i[1], "description": i[0].strip()})
        
        # set the nutrient data
        current = translation["MACRO NUTRIENTI"]
        for _, r in nutrient.iterrows():
            if r[0] == r[1]:
                current = translation[r[0]]
            elif r[0] != "Descrizione Nutriente":
                item = {translation["Descrizione Nutriente"]: translation[r[0]],
                        translation["Valore per 100 g"]: 0 if translation[r[0]] != translation["Aminoacido limitante"] else "", 
                        translation["Origine Dato"]: "", 
                        translation["Metodiche"]: "", 
                        translation["Referenze"]: []}

                if item in new_json[current]:
                    index = new_json[current].index(item)

                    new_json[current][index] = {translation["Descrizione Nutriente"]: translation[r[0]],
                                        translation["Valore per 100 g"]: r[1],# if r[1].isalpha() else float(r[1]),
                                        translation["Origine Dato"]: r[2], 
                                        translation["Metodiche"]: r[3], 
                                        translation["Referenze"]: [] if r[4] == "" else r[4].split("\t")}
                    new_row[translation[r[0]]] = r[1]

        output_json.write(json.dumps(new_json, ensure_ascii=True, separators=(',', ':'), indent=None) + "\n")
        output_df.loc[len(output_df)] = new_row

output_df.to_csv(CSV_DATASET_PATH, index=False)
output_df.to_excel(XLSX_DATASET_PATH, index=False)

translation_file.close()
template_file.close()
output_json.close()
recipes_json.close()

crea_template_en.json

{
    "name": "",
    "category": "",
    "food_code": "",
    "scientific_name": "",
    "english_name": "",
    "info": "",
    "samples_number": 0,
    "edible_part": 0,
    "portion": "",
    "image" : "",
    "langual_code": [
        {"id" : "", "description": ""}
    ],
    "macro_nutrients": [
        {"description": "water", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "energy_kcal", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "energy_kj", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "proteins", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "lipids", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "cholesterol", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "available_carbohydrates", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "starch", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "soluble_sugars", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "alcohol", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "total_fiber", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "soluble_fiber", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "insoluble_fiber", "value": 0, "origin": "", "method": "", "references": []}
    ],
    "sugars": [
        {"description": "sucrose", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "glucose", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "fructose", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "lactose", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "galactose", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "maltose", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "maltotriosium", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "raffinose", "value": 0, "origin": "", "method": "", "references": []}
    ],
    "minerals": [
        {"description": "fluorine", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "sodium", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "magnesium", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "phosphorus", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "chlorine", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "potassium", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "calcium", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "chromium", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "manganese", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "iron", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "nickel", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "copper", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "zinc", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "selenium", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "iodine", "value": 0, "origin": "", "method": "", "references": []}
    ],
    "vitamins": [
        {"description": "total_carotenoids", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "alpha_carotene", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "beta_carotene", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "cryptoxanthin", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "lycopene", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "lutein", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "retinol", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "zeaxanthin", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "vitamin_a_retinol_equivalent", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "thiamine", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "riboflavin", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "niacin", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "pantothenic_acid", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "vitamin_b6", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "biotin", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "folate", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "vitamin_b12", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "vitamin_c", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "vitamin_d", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "vitamin_e", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "alpha_tocopherol", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "beta_tocopherol", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "gamma_tocopherol", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "delta_tocopherol", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "vitamin_k", "value": 0, "origin": "", "method": "", "references": []}

    ],
    "fatty_acids": [
        {"description": "Saturated_fatty_acids", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "C4:0-C10:0", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "C4:0_butyric_acid", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "C6:0_capronic_acid", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "C7:0_enanthic_acid", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "C8:0_caprylic_acid", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "C10:0_caprinic_acid", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "C12:0_lauric_acid", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "C13:0_tridecanoic_acid", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "C14:0_myristic_acid", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "C15:0_pentadecanoic_acid", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "C16:0_palmitic_acid", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "C17:0_heptadecanoic_acid", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "C18:0_stearic_acid", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "C20:0_arachidic_acid", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "C22:0_behenic_acid", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "C24:0_lignoceric_acid", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "monounsaturated_fatty_acids", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "C10:1_caproleic_acid", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "C12:1_lauroleic_acid", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "C13:1_tridecenoic_acid", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "C14:1_myristoleic_acid", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "C15:1_pentadecenoic_acid", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "C16:1 palmitoleic_acid", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "C17:1_heptadecenoic_acid", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "C18:1_oleic_acid", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "C20:1_eicosenoic_acid", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "C22:1_erucic_acid", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "polyunsaturated_fatty_acids", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "C18:2_linoleic_acid", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "C18:3_linolenic_acid", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "C20:4_arachidonic_acid", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "C20:5_eicosapentaenoic_acid_EPA", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "C22:6_docosahexaenoic_acid_DHA", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "polyunsaturated_saturated", "value": 0, "origin": "", "method": "", "references": []}
    ],
    "amino_acids": [
        {"description": "alanine", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "cystine", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "aspartic_acid", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "glutamic_acid", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "phenylalanine", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "glycine", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "histidine", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "isoleucine", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "lysine", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "leucine", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "methionine", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "proline", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "arginine", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "serine", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "threonine", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "valine", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "tryptophan", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "tyrosine", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "chemical_index", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "limiting_amino_acid", "value": "", "origin": "", "method": "", "references": []}
    ],
    "other_compounds": [
        {"description": "caffeic_acid", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "citric_acid", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "phytic_acid", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "malic_acid", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "apigenin", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "antioxidant_activity", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "campferol", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "phytosterols", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "fructo-oligosaccharides", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "myricetin", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "polyphenols", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "quercetin", "value": 0, "origin": "", "method": "", "references": []},
        {"description": "violaxanthin", "value": 0, "origin": "", "method": "", "references": []}
    ]
}

crea_template_it.json

{
    "Nome": "",
    "Categoria": "",
    "Codice Alimento": "",
    "Nome Scientifico": "",
    "English Name": "",
    "Informazioni": "",
    "Numero Campioni": 0,
    "Parte Edibile": 0,
    "Porzione": "",
    "Immagine" : "",
    "Codice Langual": [
        {"id" : "", "description": ""}
    ],
    "MACRO NUTRIENTI": [
        {"Descrizione Nutriente": "Acqua (g)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Energia (kcal)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Energia (kJ)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Proteine (g)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Lipidi (g)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Colesterolo (mg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Carboidrati disponibili (g)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Amido (g)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Zuccheri solubili (g)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Alcool (g)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Fibra totale (g)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Fibra solubile (g)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Fibra insolubile (g)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []}
    ],
    "SINGOLI ZUCCHERI": [
        {"Descrizione Nutriente": "Saccarosio (g)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Glucosio (g)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Fruttosio (g)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Lattosio (g)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Galattosio (g)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Maltosio (g)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Maltotriosio (g)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Raffinosio (g)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []}
    ],
    "MINERALI": [
        {"Descrizione Nutriente": "Fluoro (mg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Sodio (mg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Magnesio (mg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Fosforo (mg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Cloro (mg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Potassio (mg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Calcio (mg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Cromo (mg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Manganese (mg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Ferro (mg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Nickel (mg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Rame (mg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Zinco (mg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Selenio (\u03bcg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Iodio (\u03bcg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []}
    ],
    "VITAMINE": [
        {"Descrizione Nutriente": "Carotenoidi totali (\u03bcg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Carotene alfa (\u03bcg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Carotene beta (\u03bcg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Criptoxantina (\u03bcg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Licopene (\u03bcg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Luteina (\u03bcg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Retinolo (\u03bcg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Zeaxantina (\u03bcg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Vitamina A retinolo equivalente (\u03bcg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Tiamina (mg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Riboflavina (mg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Niacina (mg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Acido pantotenico (mg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Vitamina B6 (mg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Biotina (mg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Folati (\u03bcg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Vitamina B12 (\u03bcg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Vitamina C (mg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Vitamina D (\u03bcg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Vitamina E (mg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Tocoferolo alfa (mg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Tocoferolo beta (mg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Tocoferolo gamma (mg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Tocoferolo delta (mg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Vitamina K (\u03bcg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []}

    ],
    "ACIDI GRASSI": [
        {"Descrizione Nutriente": "Acidi grassi Saturi (%)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "C4:0-C10:0 (%)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "C4:0 acido butirrico (%)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "C6:0 acido capronico (%)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "C7:0 acido enantico (%)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "C8:0 acido caprilico (%)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "C10:0 acido caprinico (%)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "C12:0 acido laurico (%)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "C13:0 acido tridecanoico (%)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "C14:0 acido miristico (%)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "C15:0 acido pentadecanoico (%)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "C16:0 acido palmitico (%)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "C17:0 acido eptadecanoico (%)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "C18:0 acido stearico (%)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "C20:0 acido arachidico (%)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "C22:0 acido beenico (%)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "C24:0 acido lignocerico (%)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Acidi grassi Monoinsaturi (%)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "C10:1 acido caproleico (%)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "C12:1 acido lauroleico (%)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "C13:1 acido tridecenoico (%)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "C14:1 acido miristoleico (%)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "C15:1 acido pentadecenoico (%)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "C16:1 acido palmitoleico (%)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "C17:1 acido eptadecenoico (%)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "C18:1 acido oleico (%)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "C20:1 acido eicosenoico (%)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "C22:1 acido erucico (%)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Acidi grassi Polinsaturi (%)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "C18:2 acido linoleico (%)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "C18:3 acido linolenico (%)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "C20:4 acido arachidonico (%)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "C20:5 acido eicosapentenoico EPA (%)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "C22:6 acido docosaesenoico DHA (%)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Polinsatuti/Saturi", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []}
    ],
    "AMINOACIDI (% di proteine)": [
        {"Descrizione Nutriente": "Alanina", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Cistina", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Acido aspartico", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Acido glutammico", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Fenilalanina", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Glicina", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Istidina", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Isoleucina", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Lisina", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Leucina", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Metionina", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Prolina", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Arginina", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Serina", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Treonina", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Valina", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Triptofano", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Tirosina", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Indice Chimico", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Aminoacido limitante", "Valore per 100 g": "", "Origine Dato": "", "Metodiche": "", "Referenze": []}
    ],
    "ALTRI COMPOSTI": [
        {"Descrizione Nutriente": "Acido caffeico (mg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Acido citrico (mg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Acido fitico (g)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Acido malico (mg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Apigenina (mg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Attivit\u00e0 antiossidante (mmol)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Campferolo (mg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Fitosteroli (mg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Fruttoligosaccaridi (g)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Miricetina (mg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Polifenoli (mg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Quercetina (mg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []},
        {"Descrizione Nutriente": "Violaxantina (mg)", "Valore per 100 g": 0, "Origine Dato": "", "Metodiche": "", "Referenze": []}
    ]
}

crea_translation.json

{
    "Nome": "name",
    "Categoria": "category",
    "Codice Alimento": "food_code",
    "Nome Scientifico": "scientific_name",
    "English Name": "english_name",
    "Informazioni": "info",
    "Numero Campioni": "samples_number",
    "Parte Edibile": "edible_part",
    "Porzione": "portion",
    "Immagine": "image",
    "Codice Langual": "langual_code",
    "id": "id",
    "description": "description",
    "Descrizione Nutriente": "description",
    "Valore per 100 g": "value",
    "Origine Dato": "origin",
    "Metodiche": "method",
    "Referenze": "references",

    "MACRO NUTRIENTI": "macro_nutrients",
    "Acqua (g)": "water",
    "Energia (kcal)": "energy_kcal",
    "Energia (kJ)": "energy_kj",
    "Proteine (g)": "proteins",
    "Lipidi (g)": "lipids",
    "Colesterolo (mg)": "cholesterol",
    "Carboidrati disponibili (g)": "available_carbohydrates",
    "Amido (g)": "starch",
    "Zuccheri solubili (g)": "soluble_sugars",
    "Alcool (g)": "alcohol",
    "Fibra totale (g)": "total_fiber",
    "Fibra solubile (g)": "soluble_fiber",
    "Fibra insolubile (g)": "insoluble_fiber",

    "SINGOLI ZUCCHERI": "sugars",
    "Saccarosio (g)": "sucrose",
    "Glucosio (g)": "glucose",
    "Fruttosio (g)": "fructose",
    "Lattosio (g)": "lactose",
    "Galattosio (g)": "galactose",
    "Maltosio (g)": "maltose",
    "Maltotriosio (g)": "maltotriosium",
    "Raffinosio (g)": "raffinose",

    "MINERALI": "minerals",
    "Fluoro (mg)": "fluorine",
    "Sodio (mg)": "sodium",
    "Magnesio (mg)": "magnesium",
    "Fosforo (mg)": "phosphorus",
    "Cloro (mg)": "chlorine",
    "Potassio (mg)": "potassium",
    "Calcio (mg)": "calcium",
    "Cromo (mg)": "chromium",
    "Manganese (mg)": "manganese",
    "Ferro (mg)": "iron",
    "Nickel (mg)": "nickel",
    "Rame (mg)": "copper",
    "Zinco (mg)": "zinc",
    "Selenio (\u03bcg)": "selenium",
    "Iodio (\u03bcg)": "iodine",

    "VITAMINE": "vitamins",
    "Carotenoidi totali (\u03bcg)": "total_carotenoids",
    "Carotene alfa (\u03bcg)": "alpha_carotene",
    "Carotene beta (\u03bcg)": "beta_carotene",
    "Criptoxantina (\u03bcg)": "cryptoxanthin",
    "Licopene (\u03bcg)": "lycopene",
    "Luteina (\u03bcg)": "lutein",
    "Retinolo (\u03bcg)": "retinol",
    "Zeaxantina (\u03bcg)": "zeaxanthin",
    "Vitamina A retinolo equivalente (\u03bcg)": "vitamin_a_retinol_equivalent",
    "Tiamina (mg)": "thiamine",
    "Riboflavina (mg)": "riboflavin",
    "Niacina (mg)": "niacin",
    "Acido pantotenico (mg)": "pantothenic_acid",
    "Vitamina B6 (mg)": "vitamin_b6",
    "Biotina (mg)": "biotin",
    "Folati (\u03bcg)": "folate",
    "Vitamina B12 (\u03bcg)": "vitamin_b12",
    "Vitamina C (mg)": "vitamin_c",
    "Vitamina D (\u03bcg)": "vitamin_d",
    "Vitamina E (mg)": "vitamin_e",
    "Tocoferolo alfa (mg)": "alpha_tocopherol",
    "Tocoferolo beta (mg)": "beta_tocopherol",
    "Tocoferolo gamma (mg)": "gamma_tocopherol",
    "Tocoferolo delta (mg)": "delta_tocopherol",
    "Vitamina K (\u03bcg)": "vitamin_k",

    "ACIDI GRASSI": "fatty_acids",
    "Acidi grassi Saturi (%)": "saturated_fatty_acids",
    "C4:0-C10:0 (%)": "C4:0-C10:0",
    "C4:0 acido butirrico (%)": "C4:0_butyric_acid",
    "C6:0 acido capronico (%)": "C6:0_capronic_acid",
    "C7:0 acido enantico (%)": "C7:0_enanthic_acid",
    "C8:0 acido caprilico (%)": "C8:0_caprylic_acid",
    "C10:0 acido caprinico (%)": "C10:0_caprinic_acid",
    "C12:0 acido laurico (%)": "C12:0_lauric_acid",
    "C13:0 acido tridecanoico (%)": "C13:0_tridecanoic_acid",
    "C14:0 acido miristico (%)": "C14:0_myristic_acid",
    "C15:0 acido pentadecanoico (%)": "C15:0_pentadecanoic_acid",
    "C16:0 acido palmitico (%)": "C16:0_palmitic_acid",
    "C17:0 acido eptadecanoico (%)": "C17:0_heptadecanoic_acid",
    "C18:0 acido stearico (%)": "C18:0_stearic_acid",
    "C20:0 acido arachidico (%)": "C20:0_arachidic_acid",
    "C22:0 acido beenico (%)": "C22:0_behenic_acid",
    "C24:0 acido lignocerico (%)": "C24:0_lignoceric_acid",
    "Acidi grassi Monoinsaturi (%)": "monounsaturated_fatty_acids",
    "C10:1 acido caproleico (%)": "C10:1_caproleic_acid",
    "C12:1 acido lauroleico (%)": "C12:1_lauroleic_acid",
    "C13:1 acido tridecenoico (%)": "C13:1_tridecenoic_acid",
    "C14:1 acido miristoleico (%)": "C14:1_myristoleic_acid",
    "C15:1 acido pentadecenoico (%)": "C15:1_pentadecenoic_acid",
    "C16:1 acido palmitoleico (%)": "C16:1_palmitoleic_acid",
    "C17:1 acido eptadecenoico (%)": "C17:1_heptadecenoic_acid",
    "C18:1 acido oleico (%)": "C18:1_oleic_acid",
    "C20:1 acido eicosenoico (%)": "C20:1_eicosenoic_acid",
    "C22:1 acido erucico (%)": "C22:1_erucic_acid",
    "Acidi grassi Polinsaturi (%)": "polyunsaturated_fatty_acids",
    "C18:2 acido linoleico (%)": "C18:2_linoleic_acid",
    "C18:3 acido linolenico (%)": "C18:3_linolenic_acid",
    "C20:4 acido arachidonico (%)": "C20:4_arachidonic_acid",
    "C20:5 acido eicosapentenoico EPA (%)": "C20:5_eicosapentaenoic_acid_EPA",
    "C22:6 acido docosaesenoico DHA (%)": "C22:6_docosahexaenoic_acid_DHA",
    "Polinsatuti/Saturi": "polyunsaturated_saturated",

    "AMINOACIDI (% di proteine)": "amino_acids",
    "Alanina": "alanine",
    "Cistina": "cystine",
    "Acido aspartico": "aspartic_acid",
    "Acido glutammico": "glutamic_acid",
    "Fenilalanina": "phenylalanine",
    "Glicina": "glycine",
    "Istidina": "histidine",
    "Isoleucina": "isoleucine",
    "Lisina": "lysine",
    "Leucina": "leucine",
    "Metionina": "methionine",
    "Prolina": "proline",
    "Arginina": "arginine",
    "Serina": "serine",
    "Treonina": "threonine",
    "Valina": "valine",
    "Triptofano": "tryptophan",
    "Tirosina": "tyrosine",
    "Indice Chimico": "chemical_index",
    "Aminoacido limitante": "limiting_amino_acid",

    "ALTRI COMPOSTI": "other_compounds",
    "Acido caffeico (mg)": "caffeic_acid",
    "Acido citrico (mg)": "citric_acid",
    "Acido fitico (g)": "phytic_acid",
    "Acido malico (mg)": "malic_acid",
    "Apigenina (mg)": "apigenin",
    "Attivit\u00e0 antiossidante (mmol)": "antioxidant_activity",
    "Campferolo (mg)": "campferol",
    "Fitosteroli (mg)": "phytosterols",
    "Fruttoligosaccaridi (g)": "fructo-oligosaccharides",
    "Miricetina (mg)": "myricetin",
    "Polifenoli (mg)": "polyphenols",
    "Quercetina (mg)": "quercetin",
    "Violaxantina (mg)": "violaxanthin"
}