courante_25.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "44791e3e-4a2f-4fb7-a5b4-3edc1ea84cf1",
   "metadata": {},
   "outputs": [],
   "source": [
    "import bw2analyzer as ba\n",
    "import bw2calc as bc\n",
    "import bw2data as bd\n",
    "import bw2io as bi"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "038efd8e-f66e-4c2e-8fdd-149f6184f3a5",
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "d9c79920-2474-4a68-b7e5-de7b67890fe4",
   "metadata": {},
   "outputs": [],
   "source": [
    "import re"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "16d525ff-5270-4324-8240-c226ae8d6ab6",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Effacer un projet\n",
    "# bd.projects.delete_project('DOC_casestudies', delete_dir=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "34859e54-64e4-4496-b9d1-d923f712e2b1",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Supprimer la base de données\n",
    "# del bd.databases['ecoinvent-3.10-cutoff']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "c7adaeec-cb14-4761-aff9-a3a8d7bbf582",
   "metadata": {},
   "outputs": [],
   "source": [
    "bd.projects.set_current(name='DOC_casestudies')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "10a2ea67-f0ac-4f61-9d19-d18d3f305167",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[Project: default, Project: DOC_casestudies]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list(bd.projects)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "3c5c5bbe-aa2d-4df6-9790-3d38d10ddf16",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Importer ecoinvent\n",
    "#bi.import_ecoinvent_release(\n",
    "#    version='3.10',\n",
    "#    system_model='cutoff',\n",
    "#    username='a',\n",
    "#    password='A'\n",
    "#)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "d6c47f13-99fe-4f5f-8c3f-fed9db6f5b4e",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Créer une base de données :\n",
    "#elec_bl = bd.Database('elec_bl').register()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "8a3556c4-0af6-4e52-b418-d31af5b92217",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['ecoinvent-3.10-biosphere', 'ecoinvent-3.10-cutoff', 'elec_bl']"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list(bd.databases)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "0ec00bb0-a3d4-4d0f-9b8e-3a3099a1c724",
   "metadata": {},
   "outputs": [],
   "source": [
    "eidb = bd.Database(\"ecoinvent-3.10-cutoff\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "626f3692-9470-4449-95ec-e4f3f7dbc9a3",
   "metadata": {},
   "outputs": [],
   "source": [
    "elec_bl = bd.Database(\"elec_bl\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "id": "1c785c8f-9be9-4e49-b97d-ef8cfb098415",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Lister toutes les activités dans ma bdd\n",
    "for activity in elec_bl.search('*'):\n",
    "    print(f\"{activity['name']}, {activity.key[1]}\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "id": "c192f6fa-c2a6-4854-a24c-47a04410d3fb",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Supprimer toutes les activités de la base de données\n",
    "for activity in elec_bl:\n",
    "    activity.delete()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "9d45657e-84a6-45a1-8b98-85bc94a7b0f8",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Pour filtrer parmi les activités eidb\n",
    "from collections import Counter"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "id": "4797207e-6fe5-424a-b46d-b10b63fc1dc7",
   "metadata": {
    "jupyter": {
     "source_hidden": true
    },
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "act_build_machine: diesel, burned in building machine (GLO)\n",
      "dist_network: distribution network construction, electricity, low voltage (CA-QC)\n",
      "elec_gen_set_10MW: diesel, burned in diesel-electric generating set, 10MW (GLO)\n",
      "elec_pv_3kWp: electricity production, photovoltaic, 3kWp facade installation, multi-Si, panel, mounted (RoW)\n",
      "excav_digger: excavation, hydraulic digger (RoW)\n",
      "excav_skidsteer: excavation, skid-steer loader (RoW)\n",
      "heat_oil_boiler: heat production, light fuel oil, at boiler 100kW, non-modulating (RoW)\n",
      "heat_pellet_boiler: heat production, wood pellet, at furnace 300kW (RoW)\n",
      "maint_lorry: maintenance, lorry 16 metric ton (RoW)\n",
      "maint_pplant: electricity production, oil (CA-NU)\n",
      "maint_road: road maintenance (RoW)\n",
      "oil_boiler: oil boiler production, 100kW (RoW)\n",
      "oil_boiler_chimney: chimney production (RoW)\n",
      "oil_storage: oil storage production, 3000l (RoW)\n",
      "pellet_boiler: furnace production, pellets, with silo, 300kW (RoW)\n",
      "power_plant: oil power plant construction, 500MW (RoW)\n",
      "pv_cables: photovoltaics, electric installation for 3kWp module, at building (RoW)\n",
      "pv_facade_3kWp: photovoltaic facade installation, 3kWp, multi-Si, panel, mounted, at building (RoW)\n",
      "pv_inverter: inverter production, 2.5kW (RoW)\n",
      "pv_mounting: photovoltaic mounting system production, for facade installation (RoW)\n",
      "pv_panel: photovoltaic panel production, multi-Si wafer (RoW)\n",
      "road: road construction (RoW)\n",
      "trans_lorry_waste: transport, freight, lorry >32 metric ton, EURO3 (RoW)\n",
      "waste_PE: market for waste polyethylene (RoW)\n",
      "waste_plastic: market for waste plastic, mixture (RoW)\n",
      "waste_PS: market for waste polystyrene (RoW)\n",
      "waste_PVC: market for waste polyvinylchloride (RoW)\n",
      "waste_unknown: market for municipal solid waste (RoW)\n",
      "water_tank: hot water tank production, 600l (RoW)\n",
      "\n",
      "Tous les processus ont été trouvés avec succès.\n"
     ]
    }
   ],
   "source": [
    "# Récupérer les activités depuis eidb selon mon excel et les stocker dans un dictionnaire\n",
    "\n",
    "# Charger le fichier Excel\n",
    "df = pd.read_excel('process_names.xlsx', header=None)\n",
    "\n",
    "# Dictionnaire pour stocker les activités trouvées\n",
    "activities = {}\n",
    "\n",
    "# Liste pour stocker les processus non trouvés\n",
    "not_found = []\n",
    "\n",
    "# Liste des mots à enlever\n",
    "words_to_remove = {'processing', 'high voltage', 'low voltage', 'central or small-scale', 'other than natural gas', 'photovoltaic plant'}\n",
    "\n",
    "# Fonction pour extraire et diviser les chaînes de caractères\n",
    "def extract_strings(s):\n",
    "    match = re.match(r'([^{}]+)\\{([^{}]+)\\}([^{}]+)?', s)\n",
    "    if match:\n",
    "        name_part = match.group(1).strip().lower()\n",
    "        location_part = match.group(2).strip()\n",
    "        other_part = match.group(3).strip().lower() if match.group(3) else \"\"\n",
    "        \n",
    "        # Diviser la première partie à chaque virgule et enlever les espaces autour\n",
    "        name_parts = [name.strip() for name in name_part.split(',')]\n",
    "        # Enlever les caractères '| ' et diviser la troisième partie à chaque virgule\n",
    "        other_parts = [part.strip().replace('| ', '') for part in other_part.split(',')]\n",
    "        \n",
    "        return name_parts, location_part, other_parts\n",
    "    return None, None, None\n",
    "\n",
    "# Fonction pour vérifier si une sous-chaîne contient un des mots à enlever\n",
    "def contains_any_word(substring, words):\n",
    "    substring = substring.lower()\n",
    "    return any(word in substring for word in words)\n",
    "\n",
    "# Fonction pour nettoyer les sous-chaînes\n",
    "def filter_substrings(substrings, words_to_remove):\n",
    "    return [sub for sub in substrings if not contains_any_word(sub, words_to_remove)]\n",
    "\n",
    "# Fonction pour calculer la similarité en fonction du nombre de mots communs\n",
    "def calculate_similarity(excel_parts, activity_name):\n",
    "    activity_words = activity_name.lower().split()\n",
    "    common_words = set(excel_parts).intersection(activity_words)\n",
    "    return len(common_words), abs(len(activity_words) - len(excel_parts))\n",
    "\n",
    "# Fonction pour trouver l'activité qui partage le plus de mots\n",
    "def find_best_match(matching_activities, excel_parts):\n",
    "    similarities = [\n",
    "        (act, calculate_similarity(excel_parts, act['name']))\n",
    "        for act in matching_activities\n",
    "    ]\n",
    "    \n",
    "    # Trier en fonction du nombre de mots partagés et du nombre de mots les plus proches\n",
    "    similarities.sort(key=lambda x: (x[1][0], -x[1][1]), reverse=True)\n",
    "    \n",
    "    # Retourner l'activité la plus similaire\n",
    "    return similarities[0][0] if similarities else None\n",
    "\n",
    "# Parcourir chaque ligne du fichier Excel\n",
    "for index, row in df.iterrows():\n",
    "    nom_perso = row[0]  # Le nom que tu souhaites donner à l'activité\n",
    "    nom_eco = row[1]    # Le nom de l'activité dans ecoinvent\n",
    "    \n",
    "    # Extraire les chaînes de caractères\n",
    "    name_parts, location_part, other_parts = extract_strings(nom_eco)\n",
    "    \n",
    "    if name_parts and location_part and other_parts:\n",
    "        # Nettoyer les parties du nom\n",
    "        cleaned_name_parts = filter_substrings(name_parts, words_to_remove)\n",
    "        cleaned_other_parts = filter_substrings(other_parts, words_to_remove)\n",
    "        \n",
    "        # Enlever les doublons entre les parties du nom\n",
    "        cleaned_name_parts = list(set(cleaned_name_parts) - set(cleaned_other_parts))\n",
    "        \n",
    "        # Recherche des activités correspondant à toutes les sous-chaînes du premier et troisième groupe et à la localisation\n",
    "        matching_activities = [\n",
    "            act for act in eidb\n",
    "            if all(name in act['name'].lower() for name in cleaned_name_parts) and\n",
    "               location_part == act['location'] and\n",
    "            (not cleaned_other_parts or all(part in act['name'].lower() for part in cleaned_other_parts))\n",
    "        ]\n",
    "        \n",
    "        if matching_activities:\n",
    "            # Trouver l'activité qui partage le plus de mots\n",
    "            best_match = find_best_match(matching_activities, cleaned_name_parts)\n",
    "            \n",
    "            if best_match:\n",
    "                activities[nom_perso] = best_match\n",
    "            else:\n",
    "                activities[nom_perso] = matching_activities[0]  # Utiliser la première si aucune meilleure correspondance trouvée\n",
    "        else:\n",
    "            # Si aucune activité ne correspond, ajouter à la liste not_found\n",
    "            not_found.append(nom_eco)\n",
    "    else:\n",
    "        # Si la chaîne de caractères n'est pas conforme, ajouter à la liste not_found\n",
    "        not_found.append(nom_eco)\n",
    "\n",
    "# Afficher les activités trouvées\n",
    "for nom_perso, activity in activities.items():\n",
    "    print(f\"{nom_perso}: {activity['name']} ({activity['location']})\")\n",
    "\n",
    "# Signaler les processus non trouvés\n",
    "if not_found:\n",
    "    print(\"\\nLes processus suivants n'ont pas été trouvés dans ecoinvent:\")\n",
    "    for process in not_found:\n",
    "        print(f\"- {process}\")\n",
    "else:\n",
    "    print(\"\\nTous les processus ont été trouvés avec succès.\")\n",
    "    len(activities)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "15298814-6b0c-4758-a522-2c709a6275db",
   "metadata": {},
   "outputs": [],
   "source": [
    "import uuid\n",
    "\n",
    "# Générateur d'ID unique\n",
    "def generate_unique_id(prefix=\"\"):\n",
    "    return f\"{prefix}{uuid.uuid4().hex[:8]}\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "id": "adc13083-e1d4-47fa-a0d3-8b3d1395e1e8",
   "metadata": {
    "collapsed": true,
    "jupyter": {
     "outputs_hidden": true
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "diesel, burned in building machine ok\n",
      "distribution network construction, electricity, low voltage ok\n",
      "diesel, burned in diesel-electric generating set, 10MW ok\n",
      "electricity production, photovoltaic, 3kWp facade installation, multi-Si, panel, mounted ok\n",
      "excavation, hydraulic digger ok\n",
      "excavation, skid-steer loader ok\n",
      "heat production, light fuel oil, at boiler 100kW, non-modulating ok\n",
      "heat production, wood pellet, at furnace 300kW ok\n",
      "maintenance, lorry 16 metric ton ok\n",
      "electricity production, oil ok\n",
      "road maintenance ok\n",
      "oil boiler production, 100kW ok\n",
      "chimney production ok\n",
      "oil storage production, 3000l ok\n",
      "furnace production, pellets, with silo, 300kW ok\n",
      "oil power plant construction, 500MW ok\n",
      "photovoltaics, electric installation for 3kWp module, at building ok\n",
      "photovoltaic facade installation, 3kWp, multi-Si, panel, mounted, at building ok\n",
      "inverter production, 2.5kW ok\n",
      "photovoltaic mounting system production, for facade installation ok\n",
      "photovoltaic panel production, multi-Si wafer ok\n",
      "road construction ok\n",
      "transport, freight, lorry >32 metric ton, EURO3 ok\n",
      "market for waste polyethylene ok\n",
      "market for waste plastic, mixture ok\n",
      "market for waste polystyrene ok\n",
      "market for waste polyvinylchloride ok\n",
      "market for municipal solid waste ok\n",
      "hot water tank production, 600l ok\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "87"
      ]
     },
     "execution_count": 64,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Diviser les activités en onsite, offsite et waste, puis attribuer les exchanges correspondants\n",
    "\n",
    "for activity_name in activities:\n",
    "    #print(activity_name)\n",
    "    activity = activities.get(activity_name)\n",
    "    \n",
    "    # Offsite activity\n",
    "    offsite_activity_data = {\n",
    "        'name': 'offsite_' + activity['name'],\n",
    "        'unit': activity['unit'],\n",
    "        'exchanges': []\n",
    "    }\n",
    "    \n",
    "    # Onsite activity\n",
    "    onsite_activity_data = {\n",
    "        'name': 'onsite_' + activity['name'],\n",
    "        'unit': activity['unit'],\n",
    "        'exchanges': []\n",
    "    }\n",
    "    \n",
    "    # Waste activity\n",
    "    waste_activity_data = {\n",
    "        'name': 'waste_' + activity['name'],\n",
    "        'unit': activity['unit'],\n",
    "        'exchanges': []\n",
    "    }\n",
    "    \n",
    "    # Créer et sauvegarder les activités\n",
    "    offsite_activity = elec_bl.new_activity(code=generate_unique_id('off_'), **offsite_activity_data)\n",
    "    onsite_activity = elec_bl.new_activity(code=generate_unique_id('on_'), **onsite_activity_data)\n",
    "    waste_activity = elec_bl.new_activity(code=generate_unique_id('waste_'), **waste_activity_data)\n",
    "    \n",
    "    offsite_activity.save()\n",
    "    onsite_activity.save()\n",
    "    waste_activity.save()\n",
    "\n",
    "    \n",
    "    # Ajouter les échanges à l'activité appropriée\n",
    "    for exc in activity.technosphere():\n",
    "        # Déchet vers waste\n",
    "        if exc.amount < 0:\n",
    "            waste_activity.new_exchange(\n",
    "                input=exc.input,\n",
    "                amount=exc.amount,\n",
    "                type=exc['type'],\n",
    "                unit=exc['unit']\n",
    "            ).save()\n",
    "        # Conso d'eau vers onsite\n",
    "        elif 'water' in exc['name'] and exc.amount > 0:\n",
    "            onsite_activity.new_exchange(\n",
    "                input=exc.input,\n",
    "                amount=exc.amount,\n",
    "                type=exc['type'],\n",
    "                unit=exc['unit']\n",
    "            ).save()\n",
    "        # Conso d'énergie vers onsite & offsite\n",
    "        elif exc['unit'] in ['kilowatt hour', 'megajoule']:\n",
    "            onsite_activity.new_exchange(\n",
    "                input=exc.input,\n",
    "                amount=exc.amount,\n",
    "                type=exc['type'],\n",
    "                unit=exc['unit']\n",
    "            ).save()\n",
    "            offsite_activity.new_exchange(\n",
    "                input=exc.input,\n",
    "                amount=exc.amount,\n",
    "                type=exc['type'],\n",
    "                unit=exc['unit']\n",
    "            ).save()\n",
    "        # Process multiregionaux vers onsite & offsite\n",
    "        elif ('excavation' in exc['name'] or 'diesel, burned in building machine' in exc['name'] or 'lorry' in exc['name'] or 'road' in exc['name']) and exc.amount > 0:\n",
    "            onsite_activity.new_exchange(\n",
    "                input=exc.input,\n",
    "                amount=exc.amount,\n",
    "                type=exc['type'],\n",
    "                unit=exc['unit']\n",
    "            ).save()\n",
    "            offsite_activity.new_exchange(\n",
    "                input=exc.input,\n",
    "                amount=exc.amount,\n",
    "                type=exc['type'],\n",
    "                unit=exc['unit']\n",
    "            ).save()\n",
    "        # Autres techno vers offsite\n",
    "        else:\n",
    "            offsite_activity.new_exchange(\n",
    "                input=exc.input,\n",
    "                amount=exc.amount,\n",
    "                type=exc['type'],\n",
    "                unit=exc['unit']\n",
    "            ).save()\n",
    "\n",
    "    \n",
    "    # Ajouter les échanges biosphériques à l'activité onsite\n",
    "    for exc in activity.biosphere():\n",
    "        onsite_activity.new_exchange(\n",
    "            input=exc.input,\n",
    "            amount=exc.amount,\n",
    "            type=exc['type'],\n",
    "            unit=exc['unit']\n",
    "        ).save()\n",
    "    print(activity['name'] + ' ok')\n",
    "\n",
    "len(elec_bl)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "id": "09f5944f-9540-42b1-aeeb-fc8924c6bc82",
   "metadata": {
    "collapsed": true,
    "jupyter": {
     "outputs_hidden": true,
     "source_hidden": true
    },
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Activity 'offsite_photovoltaic panel production, multi-Si wafer' - Summing exchanges 'market for corrugated board box' to location 'RoW'. New amount: 1.0956\n",
      "Activity 'offsite_photovoltaic panel production, multi-Si wafer' - Summing exchanges 'market for heat, district or industrial, natural gas' to location 'RoW'. New amount: 4.86639\n",
      "Activity 'offsite_photovoltaic panel production, multi-Si wafer' - Summing exchanges 'market for methanol' to location 'RoW'. New amount: 0.0021556\n",
      "Activity 'waste_heat production, wood pellet, at furnace 300kW' - Summing exchanges 'market for wood ash mixture, pure' to location 'RoW'. New amount: -0.00031733333333333396\n",
      "Activity 'offsite_maintenance, lorry 16 metric ton' - Summing exchanges 'market for heat, district or industrial, other than natural gas' to location 'RoW'. New amount: 53864.99999999999\n",
      "Activity 'waste_inverter production, 2.5kW' - Summing exchanges 'market for waste polyethylene' to location 'RoW'. New amount: -0.05999999999999999\n",
      "Activity 'waste_inverter production, 2.5kW' - Summing exchanges 'market for waste polystyrene' to location 'RoW'. New amount: -0.31000000000000005\n",
      "Activity 'onsite_electricity production, photovoltaic, 3kWp facade installation, multi-Si, panel, mounted' - Summing exchanges 'market for tap water' to location 'RoW'. New amount: 0.007282297319776519\n",
      "Activity 'offsite_furnace production, pellets, with silo, 300kW' - Summing exchanges 'market for concrete, normal strength' to location 'RoW'. New amount: 16.900000000000002\n",
      "Activity 'offsite_furnace production, pellets, with silo, 300kW' - Summing exchanges 'market for heat, central or small-scale, other than natural gas' to location 'RoW'. New amount: 2700.0\n",
      "Activity 'waste_diesel, burned in building machine' - Summing exchanges 'market for waste mineral oil' to location 'RoW'. New amount: -0.0005139999999999999\n",
      "Activity 'waste_chimney production' - Summing exchanges 'market for waste concrete' to location 'RoW'. New amount: -95.0\n",
      "Activity 'waste_chimney production' - Summing exchanges 'market for waste mineral wool, for final disposal' to location 'RoW'. New amount: -0.5\n",
      "Activity 'offsite_transport, freight, lorry >32 metric ton, EURO3' - Summing exchanges 'market for diesel, low-sulfur' to location 'RoW'. New amount: 0.0195949765528\n",
      "Activity 'offsite_diesel, burned in building machine' - Summing exchanges 'market for lubricating oil' to location 'RoW'. New amount: 0.0005140000000000001\n",
      "Activity 'offsite_excavation, skid-steer loader' - Summing exchanges 'market for diesel' to location 'RoW'. New amount: 0.13\n",
      "Activity 'waste_photovoltaics, electric installation for 3kWp module, at building' - Summing exchanges 'market for scrap copper' to location 'RoW'. New amount: -0.02\n",
      "Activity 'waste_photovoltaics, electric installation for 3kWp module, at building' - Summing exchanges 'market for scrap steel' to location 'RoW'. New amount: -0.9\n",
      "Activity 'waste_photovoltaics, electric installation for 3kWp module, at building' - Summing exchanges 'market for waste polyethylene/polypropylene product' to location 'RoW'. New amount: -0.20200000000000004\n",
      "Activity 'waste_photovoltaics, electric installation for 3kWp module, at building' - Summing exchanges 'market for waste polyvinylchloride' to location 'RoW'. New amount: -2.111810378597408\n",
      "Activity 'offsite_oil storage production, 3000l' - Summing exchanges 'market for concrete, normal strength' to location 'RoW'. New amount: 0.22500000000000003\n",
      "Activity 'offsite_hot water tank production, 600l' - Summing exchanges 'market for heat, district or industrial, natural gas' to location 'RoW'. New amount: 137.7\n",
      "Activity 'offsite_hot water tank production, 600l' - Summing exchanges 'market for heat, district or industrial, other than natural gas' to location 'RoW'. New amount: 92.65999999999998\n",
      "Activity 'offsite_inverter production, 2.5kW' - Summing exchanges 'market for corrugated board box' to location 'RoW'. New amount: 2.5\n",
      "Activity 'waste_hot water tank production, 600l' - Summing exchanges 'market for waste mineral wool' to location 'RoW'. New amount: -20.0\n",
      "Activity 'waste_hot water tank production, 600l' - Summing exchanges 'market for waste plastic, mixture' to location 'RoW'. New amount: -3.8286702810714535\n",
      "Activity 'waste_hot water tank production, 600l' - Summing exchanges 'market for waste polyvinylchloride product' to location 'RoW'. New amount: -2.0\n",
      "Activity 'waste_hot water tank production, 600l' - Summing exchanges 'market for wastewater, average' to location 'RoW'. New amount: -0.6169999999999999\n",
      "Activity 'waste_furnace production, pellets, with silo, 300kW' - Summing exchanges 'market for scrap aluminium' to location 'RoW'. New amount: -9.5\n",
      "Activity 'waste_furnace production, pellets, with silo, 300kW' - Summing exchanges 'market for scrap copper' to location 'RoW'. New amount: -4.5\n",
      "Activity 'waste_furnace production, pellets, with silo, 300kW' - Summing exchanges 'market for scrap steel' to location 'RoW'. New amount: -2920.0\n",
      "Activity 'waste_furnace production, pellets, with silo, 300kW' - Summing exchanges 'market for waste concrete' to location 'RoW'. New amount: -39667.0\n",
      "Activity 'waste_furnace production, pellets, with silo, 300kW' - Summing exchanges 'market for waste mineral oil' to location 'RoW'. New amount: -3.0\n",
      "Activity 'waste_furnace production, pellets, with silo, 300kW' - Summing exchanges 'market for waste mineral wool, for final disposal' to location 'RoW'. New amount: -266.0\n",
      "Activity 'waste_furnace production, pellets, with silo, 300kW' - Summing exchanges 'market for waste polyethylene' to location 'RoW'. New amount: -5.4886676778335755\n",
      "Activity 'waste_furnace production, pellets, with silo, 300kW' - Summing exchanges 'market for waste polystyrene isolation, flame-retardant' to location 'RoW'. New amount: -52.00000000000001\n",
      "Activity 'onsite_photovoltaic panel production, multi-Si wafer' - Summing exchanges 'market for heat, district or industrial, natural gas' to location 'RoW'. New amount: 4.86639\n",
      "Activity 'onsite_photovoltaic panel production, multi-Si wafer' - Summing exchanges 'market for tap water' to location 'RoW'. New amount: 21.286\n",
      "Activity 'waste_oil boiler production, 100kW' - Summing exchanges 'market for hazardous waste, for incineration' to location 'RoW'. New amount: -6.0\n",
      "Activity 'waste_oil boiler production, 100kW' - Summing exchanges 'market for waste mineral wool, for final disposal' to location 'RoW'. New amount: -19.0\n",
      "Activity 'waste_oil boiler production, 100kW' - Summing exchanges 'market for waste plastic, mixture' to location 'RoW'. New amount: -1.3886368895077814\n",
      "Activity 'waste_oil boiler production, 100kW' - Summing exchanges 'market for wastewater from pig iron production' to location 'RoW'. New amount: -0.615\n",
      "Activity 'waste_oil storage production, 3000l' - Summing exchanges 'market for waste concrete' to location 'RoW'. New amount: -495.0\n",
      "Activity 'waste_oil storage production, 3000l' - Summing exchanges 'market for waste plastic, mixture' to location 'RoW'. New amount: -0.5455359208780569\n",
      "Activity 'offsite_road maintenance' - Summing exchanges 'market for gravel, crushed' to location 'RoW'. New amount: 2.11\n",
      "Activity 'onsite_market for municipal solid waste' - Summing exchanges 'market for transport, freight, lorry, unspecified' to location 'RoW'. New amount: 0.077\n",
      "Activity 'offsite_photovoltaic mounting system production, for facade installation' - Summing exchanges 'market for corrugated board box' to location 'RoW'. New amount: 0.040262\n",
      "Activity 'offsite_market for municipal solid waste' - Summing exchanges 'market for transport, freight, lorry, unspecified' to location 'RoW'. New amount: 0.077\n",
      "Activity 'waste_road construction' - Summing exchanges 'market for scrap steel' to location 'RoW'. New amount: -0.35167\n",
      "Activity 'onsite_oil boiler production, 100kW' - Summing exchanges 'market for heat, district or industrial, natural gas' to location 'RoW'. New amount: 1728.0\n",
      "Activity 'onsite_oil boiler production, 100kW' - Summing exchanges 'market for heat, district or industrial, other than natural gas' to location 'RoW'. New amount: 959.5\n",
      "Activity 'onsite_oil boiler production, 100kW' - Summing exchanges 'market for tap water' to location 'RoW'. New amount: 740.9999999999999\n",
      "Activity 'onsite_maintenance, lorry 16 metric ton' - Summing exchanges 'market for heat, district or industrial, other than natural gas' to location 'RoW'. New amount: 53864.99999999999\n",
      "Activity 'onsite_oil power plant construction, 500MW' - Summing exchanges 'market for heat, district or industrial, other than natural gas' to location 'RoW'. New amount: 256500000.0\n",
      "Activity 'waste_photovoltaic panel production, multi-Si wafer' - Summing exchanges 'market for municipal solid waste' to location 'RoW'. New amount: -0.030000000000000002\n",
      "Activity 'waste_photovoltaic panel production, multi-Si wafer' - Summing exchanges 'market for waste plastic, mixture' to location 'RoW'. New amount: -1.6861000000000002\n",
      "Activity 'waste_photovoltaic panel production, multi-Si wafer' - Summing exchanges 'market for wastewater, average' to location 'RoW'. New amount: -0.021286\n",
      "Activity 'waste_diesel, burned in diesel-electric generating set, 10MW' - Summing exchanges 'market for waste mineral oil' to location 'RoW'. New amount: -6.7e-05\n",
      "Activity 'onsite_furnace production, pellets, with silo, 300kW' - Summing exchanges 'market for heat, central or small-scale, other than natural gas' to location 'RoW'. New amount: 2700.0\n",
      "Activity 'offsite_heat production, light fuel oil, at boiler 100kW, non-modulating' - Summing exchanges 'market for light fuel oil' to location 'RoW'. New amount: 0.0249148936170213\n",
      "Activity 'onsite_hot water tank production, 600l' - Summing exchanges 'market for heat, district or industrial, natural gas' to location 'RoW'. New amount: 137.7\n",
      "Activity 'onsite_hot water tank production, 600l' - Summing exchanges 'market for heat, district or industrial, other than natural gas' to location 'RoW'. New amount: 92.65999999999998\n",
      "Activity 'onsite_hot water tank production, 600l' - Summing exchanges 'market for tap water' to location 'RoW'. New amount: 617.0\n",
      "Activity 'offsite_oil power plant construction, 500MW' - Summing exchanges 'market for concrete, normal strength' to location 'RoW'. New amount: 50800.0\n",
      "Activity 'offsite_oil power plant construction, 500MW' - Summing exchanges 'market for heat, district or industrial, other than natural gas' to location 'RoW'. New amount: 256500000.0\n",
      "Activity 'offsite_oil boiler production, 100kW' - Summing exchanges 'market for corrugated board box' to location 'RoW'. New amount: 10.0\n",
      "Activity 'offsite_oil boiler production, 100kW' - Summing exchanges 'market for heat, district or industrial, natural gas' to location 'RoW'. New amount: 1728.0\n",
      "Activity 'offsite_oil boiler production, 100kW' - Summing exchanges 'market for heat, district or industrial, other than natural gas' to location 'RoW'. New amount: 959.5\n",
      "Activity 'offsite_diesel, burned in diesel-electric generating set, 10MW' - Summing exchanges 'market for lubricating oil' to location 'RoW'. New amount: 6.700000000000002e-05\n",
      "Activity 'offsite_excavation, hydraulic digger' - Summing exchanges 'market for diesel' to location 'RoW'. New amount: 0.131\n",
      "Activity 'offsite_road construction' - Summing exchanges 'market for concrete, normal strength' to location 'RoW'. New amount: 0.00359817351598174\n",
      "Activity 'offsite_road construction' - Summing exchanges 'market for gravel, crushed' to location 'RoW'. New amount: 106.0\n",
      "Activity 'waste_electricity production, photovoltaic, 3kWp facade installation, multi-Si, panel, mounted' - Summing exchanges 'market for wastewater, average' to location 'RoW'. New amount: -7.282297319776519e-06\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "87"
      ]
     },
     "execution_count": 65,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Additionner les échanges avec le même nom dans le RoW ou le GLO\n",
    "\n",
    "# Parcourir chaque activité dans la base de données\n",
    "for activity in elec_bl:\n",
    "    # Dictionnaire pour stocker les échanges par nom\n",
    "    exchanges_by_name = {}\n",
    "\n",
    "    # Itérer à travers les échanges de l'activité\n",
    "    for exc in activity.technosphere():\n",
    "        name = exc.input.get('name')  # Utiliser .get() pour éviter KeyError\n",
    "        \n",
    "        if name is None:\n",
    "            continue  # Passer à l'échange suivant si le nom est absent\n",
    "        \n",
    "        # Ajouter l'échange à la liste correspondante à ce nom\n",
    "        if name not in exchanges_by_name:\n",
    "            exchanges_by_name[name] = []\n",
    "        exchanges_by_name[name].append(exc)\n",
    "\n",
    "    # Parcourir chaque groupe d'échanges par nom\n",
    "    for name, exchanges in exchanges_by_name.items():\n",
    "        if len(exchanges) > 1:  # Si plusieurs échanges avec le même nom\n",
    "            row_exchange = None\n",
    "            total_amount = 0\n",
    "\n",
    "            for exc in exchanges:\n",
    "                total_amount += exc.get('amount', 0)  # Utiliser .get() pour éviter KeyError\n",
    "\n",
    "                if exc.input.get('location') == 'RoW' or exc.input.get('location') == 'GLO':\n",
    "                    row_exchange = exc  # Garder l'échange avec location 'RoW'\n",
    "\n",
    "            if row_exchange:\n",
    "                row_exchange['amount'] = total_amount  # Mettre à jour le montant\n",
    "                row_exchange.save()\n",
    "                print(f\"Activity '{activity['name']}' - Summing exchanges '{name}' to location '{row_exchange.input.get('location')}'. New amount: {total_amount}\")\n",
    "\n",
    "            # Supprimer les autres échanges avec ce nom\n",
    "            for exc in exchanges:\n",
    "                if exc != row_exchange:\n",
    "                    exc.delete()\n",
    "\n",
    "    activity.save()\n",
    "len(elec_bl)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "id": "387582b0-a36f-4d92-9739-7d9d29b1a8c0",
   "metadata": {
    "collapsed": true,
    "jupyter": {
     "outputs_hidden": true
    },
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Replaced 'market for waste concrete' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste concrete' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste concrete' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste concrete' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste concrete' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral wool, for final disposal' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral wool, for final disposal' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral wool, for final disposal' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral wool, for final disposal' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral wool, for final disposal' with 'waste_market for municipal solid waste'\n",
      "Saved changes for activity 'waste_chimney production'\n",
      "Replaced 'market for inert waste, for final disposal' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for inert waste, for final disposal' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for inert waste, for final disposal' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for inert waste, for final disposal' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for inert waste, for final disposal' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap steel' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap steel' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap steel' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap steel' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap steel' with 'waste_market for municipal solid waste'\n",
      "Saved changes for activity 'waste_road construction'\n",
      "Replaced 'market for used printed wiring boards' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for used printed wiring boards' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for used printed wiring boards' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for used printed wiring boards' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for used printed wiring boards' with 'waste_market for municipal solid waste'\n",
      "Replaced 'waste paperboard, unsorted, Recycled Content cut-off' with 'waste_market for municipal solid waste'\n",
      "Replaced 'waste paperboard, unsorted, Recycled Content cut-off' with 'waste_market for municipal solid waste'\n",
      "Replaced 'waste paperboard, unsorted, Recycled Content cut-off' with 'waste_market for municipal solid waste'\n",
      "Replaced 'waste paperboard, unsorted, Recycled Content cut-off' with 'waste_market for municipal solid waste'\n",
      "Replaced 'waste paperboard, unsorted, Recycled Content cut-off' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste polyethylene' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste polyethylene' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste polyethylene' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste polyethylene' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste polyethylene' with 'waste_market for waste polyethylene'\n",
      "Replaced 'market for waste polystyrene' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste polystyrene' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste polystyrene' with 'waste_market for waste polystyrene'\n",
      "Replaced 'market for waste polystyrene' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste polystyrene' with 'waste_market for municipal solid waste'\n",
      "Saved changes for activity 'waste_inverter production, 2.5kW'\n",
      "Replaced 'market for brake wear emissions, lorry' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for brake wear emissions, lorry' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for brake wear emissions, lorry' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for brake wear emissions, lorry' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for brake wear emissions, lorry' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for road wear emissions, lorry' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for road wear emissions, lorry' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for road wear emissions, lorry' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for road wear emissions, lorry' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for road wear emissions, lorry' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for tyre wear emissions, lorry' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for tyre wear emissions, lorry' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for tyre wear emissions, lorry' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for tyre wear emissions, lorry' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for tyre wear emissions, lorry' with 'waste_market for municipal solid waste'\n",
      "Saved changes for activity 'waste_transport, freight, lorry >32 metric ton, EURO3'\n",
      "Saved changes for activity 'waste_photovoltaic facade installation, 3kWp, multi-Si, panel, mounted, at building'\n",
      "Replaced 'market for waste mineral oil' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral oil' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral oil' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral oil' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral oil' with 'waste_market for municipal solid waste'\n",
      "Saved changes for activity 'waste_excavation, skid-steer loader'\n",
      "Replaced 'market for scrap copper' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap copper' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap copper' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap copper' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap copper' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap steel' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap steel' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap steel' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap steel' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap steel' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste electric wiring' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste electric wiring' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste electric wiring' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste electric wiring' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste electric wiring' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste polyethylene/polypropylene product' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste polyethylene/polypropylene product' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste polyethylene/polypropylene product' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste polyethylene/polypropylene product' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste polyethylene/polypropylene product' with 'waste_market for waste polyethylene'\n",
      "Replaced 'market for waste polyvinylchloride' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste polyvinylchloride' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste polyvinylchloride' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste polyvinylchloride' with 'waste_market for waste polyvinylchloride'\n",
      "Replaced 'market for waste polyvinylchloride' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market group for waste polyvinylchloride' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market group for waste polyvinylchloride' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market group for waste polyvinylchloride' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market group for waste polyvinylchloride' with 'waste_market for waste polyvinylchloride'\n",
      "Replaced 'market group for waste polyvinylchloride' with 'waste_market for municipal solid waste'\n",
      "Saved changes for activity 'waste_photovoltaics, electric installation for 3kWp module, at building'\n",
      "Replaced 'market for wood ash mixture, pure' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for wood ash mixture, pure' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for wood ash mixture, pure' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for wood ash mixture, pure' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for wood ash mixture, pure' with 'waste_market for municipal solid waste'\n",
      "Saved changes for activity 'waste_heat production, wood pellet, at furnace 300kW'\n",
      "Replaced 'market for scrap aluminium' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap aluminium' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap aluminium' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap aluminium' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap aluminium' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap steel' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap steel' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap steel' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap steel' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap steel' with 'waste_market for municipal solid waste'\n",
      "Replaced 'waste paperboard, unsorted, Recycled Content cut-off' with 'waste_market for municipal solid waste'\n",
      "Replaced 'waste paperboard, unsorted, Recycled Content cut-off' with 'waste_market for municipal solid waste'\n",
      "Replaced 'waste paperboard, unsorted, Recycled Content cut-off' with 'waste_market for municipal solid waste'\n",
      "Replaced 'waste paperboard, unsorted, Recycled Content cut-off' with 'waste_market for municipal solid waste'\n",
      "Replaced 'waste paperboard, unsorted, Recycled Content cut-off' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste polyethylene/polypropylene product' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste polyethylene/polypropylene product' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste polyethylene/polypropylene product' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste polyethylene/polypropylene product' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste polyethylene/polypropylene product' with 'waste_market for waste polyethylene'\n",
      "Replaced 'market for waste polystyrene isolation, flame-retardant' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste polystyrene isolation, flame-retardant' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste polystyrene isolation, flame-retardant' with 'waste_market for waste polystyrene'\n",
      "Replaced 'market for waste polystyrene isolation, flame-retardant' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste polystyrene isolation, flame-retardant' with 'waste_market for municipal solid waste'\n",
      "Saved changes for activity 'waste_photovoltaic mounting system production, for facade installation'\n",
      "Replaced 'market for electronics scrap from control units' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for electronics scrap from control units' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for electronics scrap from control units' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for electronics scrap from control units' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for electronics scrap from control units' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for inert waste, for final disposal' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for inert waste, for final disposal' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for inert waste, for final disposal' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for inert waste, for final disposal' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for inert waste, for final disposal' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap aluminium' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap aluminium' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap aluminium' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap aluminium' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap aluminium' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap copper' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap copper' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap copper' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap copper' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap copper' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap steel' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap steel' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap steel' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap steel' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap steel' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste concrete' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste concrete' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste concrete' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste concrete' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste concrete' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral oil' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral oil' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral oil' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral oil' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral oil' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral wool, for final disposal' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral wool, for final disposal' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral wool, for final disposal' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral wool, for final disposal' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral wool, for final disposal' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market group for waste polyethylene' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market group for waste polyethylene' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market group for waste polyethylene' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market group for waste polyethylene' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market group for waste polyethylene' with 'waste_market for waste polyethylene'\n",
      "Replaced 'market for waste polyethylene' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste polyethylene' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste polyethylene' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste polyethylene' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste polyethylene' with 'waste_market for waste polyethylene'\n",
      "Replaced 'market for waste polystyrene isolation, flame-retardant' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste polystyrene isolation, flame-retardant' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste polystyrene isolation, flame-retardant' with 'waste_market for waste polystyrene'\n",
      "Replaced 'market for waste polystyrene isolation, flame-retardant' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste polystyrene isolation, flame-retardant' with 'waste_market for municipal solid waste'\n",
      "Saved changes for activity 'waste_furnace production, pellets, with silo, 300kW'\n",
      "Replaced 'market for waste mineral oil' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral oil' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral oil' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral oil' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral oil' with 'waste_market for municipal solid waste'\n",
      "Saved changes for activity 'waste_excavation, hydraulic digger'\n",
      "Replaced 'market for waste mineral oil' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral oil' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral oil' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral oil' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral oil' with 'waste_market for municipal solid waste'\n",
      "Saved changes for activity 'waste_diesel, burned in diesel-electric generating set, 10MW'\n",
      "Replaced 'market for waste mineral oil' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral oil' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral oil' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral oil' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral oil' with 'waste_market for municipal solid waste'\n",
      "Saved changes for activity 'waste_diesel, burned in building machine'\n",
      "Replaced 'market for waste mineral wool' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral wool' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral wool' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral wool' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral wool' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market group for waste plastic, mixture' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market group for waste plastic, mixture' with 'waste_market for waste plastic, mixture'\n",
      "Replaced 'market group for waste plastic, mixture' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market group for waste plastic, mixture' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market group for waste plastic, mixture' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste plastic, mixture' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste plastic, mixture' with 'waste_market for waste plastic, mixture'\n",
      "Replaced 'market for waste plastic, mixture' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste plastic, mixture' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste plastic, mixture' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste polyvinylchloride product' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste polyvinylchloride product' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste polyvinylchloride product' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste polyvinylchloride product' with 'waste_market for waste polyvinylchloride'\n",
      "Replaced 'market for waste polyvinylchloride product' with 'waste_market for municipal solid waste'\n",
      "Did not replace wastewater\n",
      "Did not replace wastewater\n",
      "Did not replace wastewater\n",
      "Did not replace wastewater\n",
      "Did not replace wastewater\n",
      "Saved changes for activity 'waste_hot water tank production, 600l'\n",
      "Did not replace wastewater\n",
      "Did not replace wastewater\n",
      "Did not replace wastewater\n",
      "Did not replace wastewater\n",
      "Did not replace wastewater\n",
      "Saved changes for activity 'waste_electricity production, photovoltaic, 3kWp facade installation, multi-Si, panel, mounted'\n",
      "Replaced 'market for bilge oil' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for bilge oil' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for bilge oil' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for bilge oil' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for bilge oil' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for fly ash and scrubber sludge' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for fly ash and scrubber sludge' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for fly ash and scrubber sludge' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for fly ash and scrubber sludge' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for fly ash and scrubber sludge' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for lignite ash' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for lignite ash' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for lignite ash' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for lignite ash' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for lignite ash' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for municipal solid waste' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for municipal solid waste' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for municipal solid waste' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for municipal solid waste' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for municipal solid waste' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for residue from cooling tower' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for residue from cooling tower' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for residue from cooling tower' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for residue from cooling tower' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for residue from cooling tower' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral oil' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral oil' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral oil' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral oil' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral oil' with 'waste_market for municipal solid waste'\n",
      "Saved changes for activity 'waste_electricity production, oil'\n",
      "Replaced 'market for municipal solid waste' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for municipal solid waste' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for municipal solid waste' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for municipal solid waste' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for municipal solid waste' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral oil' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral oil' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral oil' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral oil' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral oil' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste plastic, mixture' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste plastic, mixture' with 'waste_market for waste plastic, mixture'\n",
      "Replaced 'market for waste plastic, mixture' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste plastic, mixture' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste plastic, mixture' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste polyvinylfluoride' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste polyvinylfluoride' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste polyvinylfluoride' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste polyvinylfluoride' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste polyvinylfluoride' with 'waste_market for municipal solid waste'\n",
      "Did not replace wastewater\n",
      "Did not replace wastewater\n",
      "Did not replace wastewater\n",
      "Did not replace wastewater\n",
      "Did not replace wastewater\n",
      "Saved changes for activity 'waste_photovoltaic panel production, multi-Si wafer'\n",
      "Saved changes for activity 'waste_heat production, light fuel oil, at boiler 100kW, non-modulating'\n",
      "Replaced 'market for inert waste, for final disposal' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for inert waste, for final disposal' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for inert waste, for final disposal' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for inert waste, for final disposal' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for inert waste, for final disposal' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap aluminium' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap aluminium' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap aluminium' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap aluminium' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap aluminium' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap copper' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap copper' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap copper' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap copper' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap copper' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap steel' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap steel' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap steel' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap steel' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for scrap steel' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral oil' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral oil' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral oil' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral oil' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral oil' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste wood pole, chrome preserved' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste wood pole, chrome preserved' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste wood pole, chrome preserved' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste wood pole, chrome preserved' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste wood pole, chrome preserved' with 'waste_market for municipal solid waste'\n",
      "Saved changes for activity 'waste_distribution network construction, electricity, low voltage'\n",
      "Replaced 'market for hazardous waste, for incineration' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for hazardous waste, for incineration' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for hazardous waste, for incineration' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for hazardous waste, for incineration' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for hazardous waste, for incineration' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral wool, for final disposal' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral wool, for final disposal' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral wool, for final disposal' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral wool, for final disposal' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral wool, for final disposal' with 'waste_market for municipal solid waste'\n",
      "Replaced 'waste paperboard, unsorted, Recycled Content cut-off' with 'waste_market for municipal solid waste'\n",
      "Replaced 'waste paperboard, unsorted, Recycled Content cut-off' with 'waste_market for municipal solid waste'\n",
      "Replaced 'waste paperboard, unsorted, Recycled Content cut-off' with 'waste_market for municipal solid waste'\n",
      "Replaced 'waste paperboard, unsorted, Recycled Content cut-off' with 'waste_market for municipal solid waste'\n",
      "Replaced 'waste paperboard, unsorted, Recycled Content cut-off' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market group for waste plastic, mixture' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market group for waste plastic, mixture' with 'waste_market for waste plastic, mixture'\n",
      "Replaced 'market group for waste plastic, mixture' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market group for waste plastic, mixture' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market group for waste plastic, mixture' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste plastic, mixture' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste plastic, mixture' with 'waste_market for waste plastic, mixture'\n",
      "Replaced 'market for waste plastic, mixture' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste plastic, mixture' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste plastic, mixture' with 'waste_market for municipal solid waste'\n",
      "Did not replace wastewater\n",
      "Did not replace wastewater\n",
      "Did not replace wastewater\n",
      "Did not replace wastewater\n",
      "Did not replace wastewater\n",
      "Saved changes for activity 'waste_oil boiler production, 100kW'\n",
      "Replaced 'market for waste cement in concrete and mortar' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste cement in concrete and mortar' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste cement in concrete and mortar' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste cement in concrete and mortar' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste cement in concrete and mortar' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral oil' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral oil' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral oil' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral oil' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral oil' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral wool' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral wool' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral wool' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral wool' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste mineral wool' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste polyethylene/polypropylene product' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste polyethylene/polypropylene product' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste polyethylene/polypropylene product' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste polyethylene/polypropylene product' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste polyethylene/polypropylene product' with 'waste_market for waste polyethylene'\n",
      "Saved changes for activity 'waste_oil power plant construction, 500MW'\n",
      "Saved changes for activity 'waste_maintenance, lorry 16 metric ton'\n",
      "Replaced 'market for waste concrete' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste concrete' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste concrete' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste concrete' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste concrete' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market group for waste plastic, mixture' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market group for waste plastic, mixture' with 'waste_market for waste plastic, mixture'\n",
      "Replaced 'market group for waste plastic, mixture' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market group for waste plastic, mixture' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market group for waste plastic, mixture' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste plastic, mixture' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste plastic, mixture' with 'waste_market for waste plastic, mixture'\n",
      "Replaced 'market for waste plastic, mixture' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste plastic, mixture' with 'waste_market for municipal solid waste'\n",
      "Replaced 'market for waste plastic, mixture' with 'waste_market for municipal solid waste'\n",
      "Saved changes for activity 'waste_oil storage production, 3000l'\n",
      "Saved changes for activity 'waste_road maintenance'\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "87"
      ]
     },
     "execution_count": 66,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Remplacer les exchanges des waste par ceux présents dans ma bdd\n",
    "\n",
    "# Table de correspondance des mots clés et des processus cibles\n",
    "keyword_to_process = {\n",
    "    'municipal solid waste': 'waste_market for municipal solid waste',\n",
    "    'plastic, mixture': 'waste_market for waste plastic, mixture',\n",
    "    'polystyrene': 'waste_market for waste polystyrene',\n",
    "    'polyvinylchloride': 'waste_market for waste polyvinylchloride',\n",
    "    'polyethylene': 'waste_market for waste polyethylene'\n",
    "}\n",
    "\n",
    "# Step 1: Find all activities with 'waste_' in their name\n",
    "waste_activities = [act for act in elec_bl if 'waste_' in act['name']]\n",
    "\n",
    "# Step 2: Define fallback process ('waste_market for municipal solid waste')\n",
    "fallback_process_name = 'waste_market for municipal solid waste'\n",
    "fallback_process = [act for act in elec_bl if fallback_process_name in act['name']][0]\n",
    "\n",
    "# Step 3: Create a list of activities from the correspondence table to exclude from processing\n",
    "excluded_activities = set(keyword_to_process.values())  # Extracts the process names from the correspondence table\n",
    "\n",
    "# Step 4: Process each activity's exchanges, excluding those in the correspondence table\n",
    "for activity in waste_activities:\n",
    "    # Skip the activity if it's in the excluded activities list\n",
    "    if activity['name'] in excluded_activities:\n",
    "#        print(f\"Skipping activity '{activity['name']}' as it is in the correspondence table.\")\n",
    "        continue\n",
    "    for exc in activity.exchanges():\n",
    "        # Check if the exchange's input name contains any of the keywords\n",
    "        for keyword, new_process in keyword_to_process.items():\n",
    "            if keyword in exc.input['name']:\n",
    "                # Replace the exchange's input with the new process\n",
    "                new_input_activity = [act for act in elec_bl if new_process in act['name']][0]  # Find the new process\n",
    "                \n",
    "                exc['input'] = new_input_activity.key  # Met à jour la référence de l'échange\n",
    "                exc.save()  # Enregistre l'échange mis à jour\n",
    "                print(f\"Replaced '{exc.input['name']}' with '{new_process}'\")\n",
    "            elif 'wastewater' in exc.input['name']:\n",
    "                print('Did not replace wastewater')\n",
    "                continue\n",
    "            else:\n",
    "                # If no keyword was matched, replace the exchange with the fallback process\n",
    "                exc['input']=fallback_process.key\n",
    "                exc.save()  # Enregistre l'échange mis à jour\n",
    "                print(f\"Replaced '{exc.input['name']}' with '{fallback_process_name}'\")\n",
    "    \n",
    "        # Save changes after each exchange\n",
    "#        activity.save()\n",
    "#        print(f\"Saved changes for exchange in activity '{activity['name']}'\")\n",
    "\n",
    "    # Optionally, save the activity again after processing all exchanges\n",
    "    activity.save()\n",
    "    print(f\"Saved changes for activity '{activity['name']}'\")\n",
    "\n",
    "# Optional: Save changes for the entire database if needed\n",
    "# db.save()\n",
    "len(elec_bl)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "id": "d325a76a-09a1-4be8-8531-a83be3770e30",
   "metadata": {
    "collapsed": true,
    "jupyter": {
     "outputs_hidden": true
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Activity 'waste_market for waste polystyrene' - Summing exchanges 'market for transport, freight, lorry, unspecified' to open dump 500mm. New amount: -0.687397408106803\n",
      "Activity 'waste_market for waste polystyrene' - Summing exchanges 'market for transport, freight, lorry, unspecified' to open dump 500mm. New amount: -0.7373918776201953\n",
      "Activity 'waste_market for waste polystyrene' - Summing exchanges 'market for transport, freight, lorry, unspecified' to open dump 500mm. New amount: -0.799728800380221\n",
      "Activity 'waste_market for waste polystyrene' - Summing exchanges 'market for transport, freight, lorry, unspecified' to open dump 500mm. New amount: -0.8248214985563975\n",
      "Activity 'waste_market for waste polystyrene' - Summing exchanges 'market for transport, freight, lorry, unspecified' to open dump 500mm. New amount: -0.904048346020172\n",
      "Activity 'waste_market for waste polystyrene' - Summing exchanges 'market for transport, freight, lorry, unspecified' to open dump 500mm. New amount: -0.9282013609068693\n",
      "Activity 'waste_market for waste polystyrene' - Summing exchanges 'market for transport, freight, lorry, unspecified' to open dump 500mm. New amount: -0.9999999999999998\n",
      "Activity 'waste_market for municipal solid waste' - Summing exchanges 'market for transport, freight, lorry, unspecified' to open dump 500mm. New amount: -0.5115812578332901\n",
      "Activity 'waste_market for municipal solid waste' - Summing exchanges 'market for transport, freight, lorry, unspecified' to open dump 500mm. New amount: -0.5435456562630814\n",
      "Activity 'waste_market for municipal solid waste' - Summing exchanges 'market for transport, freight, lorry, unspecified' to open dump 500mm. New amount: -0.5711285077861521\n",
      "Activity 'waste_market for municipal solid waste' - Summing exchanges 'market for transport, freight, lorry, unspecified' to open dump 500mm. New amount: -0.6220981739997715\n",
      "Activity 'waste_market for municipal solid waste' - Summing exchanges 'market for transport, freight, lorry, unspecified' to open dump 500mm. New amount: -0.6944846257247413\n",
      "Activity 'waste_market for municipal solid waste' - Summing exchanges 'market for transport, freight, lorry, unspecified' to open dump 500mm. New amount: -0.7302688388848526\n",
      "Activity 'waste_market for municipal solid waste' - Summing exchanges 'market for transport, freight, lorry, unspecified' to open dump 500mm. New amount: -0.7936233918733692\n",
      "Activity 'waste_market for municipal solid waste' - Summing exchanges 'market for transport, freight, lorry, unspecified' to open dump 500mm. New amount: -0.8132578896000777\n",
      "Activity 'waste_market for municipal solid waste' - Summing exchanges 'market for transport, freight, lorry, unspecified' to open dump 500mm. New amount: -0.9570157320205027\n",
      "Activity 'waste_market for municipal solid waste' - Summing exchanges 'market for transport, freight, lorry, unspecified' to open dump 500mm. New amount: -1.0000000000000004\n",
      "Activity 'waste_market for waste polyethylene' - Summing exchanges 'market for transport, freight, lorry, unspecified' to open dump 500mm. New amount: -0.2041966230816012\n",
      "Activity 'waste_market for waste polyethylene' - Summing exchanges 'market for transport, freight, lorry, unspecified' to open dump 500mm. New amount: -0.2834234705453758\n",
      "Activity 'waste_market for waste polyethylene' - Summing exchanges 'market for transport, freight, lorry, unspecified' to open dump 500mm. New amount: -0.34576039330540154\n",
      "Activity 'waste_market for waste polyethylene' - Summing exchanges 'market for transport, freight, lorry, unspecified' to open dump 500mm. New amount: -0.44320388017985984\n",
      "Activity 'waste_market for waste polyethylene' - Summing exchanges 'market for transport, freight, lorry, unspecified' to open dump 500mm. New amount: -0.5508475100928458\n",
      "Activity 'waste_market for waste polyethylene' - Summing exchanges 'market for transport, freight, lorry, unspecified' to open dump 500mm. New amount: -0.6089583737218698\n",
      "Activity 'waste_market for waste polyethylene' - Summing exchanges 'market for transport, freight, lorry, unspecified' to open dump 500mm. New amount: -0.6807570128150002\n",
      "Activity 'waste_market for waste polyethylene' - Summing exchanges 'market for transport, freight, lorry, unspecified' to open dump 500mm. New amount: -0.7058497109911768\n",
      "Activity 'waste_market for waste polyethylene' - Summing exchanges 'market for transport, freight, lorry, unspecified' to open dump 500mm. New amount: -0.7409231631470148\n",
      "Activity 'waste_market for waste polyethylene' - Summing exchanges 'market for transport, freight, lorry, unspecified' to open dump 500mm. New amount: -0.9758469851133028\n",
      "Activity 'waste_market for waste polyethylene' - Summing exchanges 'market for transport, freight, lorry, unspecified' to open dump 500mm. New amount: -1.0\n",
      "Activity 'waste_market for waste plastic, mixture' - Summing exchanges 'market for transport, freight, lorry, unspecified' to open dump 500mm. New amount: -0.36991340819209884\n",
      "Activity 'waste_market for waste plastic, mixture' - Summing exchanges 'market for transport, freight, lorry, unspecified' to open dump 500mm. New amount: -0.40498686034793685\n",
      "Activity 'waste_market for waste plastic, mixture' - Summing exchanges 'market for transport, freight, lorry, unspecified' to open dump 500mm. New amount: -0.5126304902609229\n",
      "Activity 'waste_market for waste plastic, mixture' - Summing exchanges 'market for transport, freight, lorry, unspecified' to open dump 500mm. New amount: -0.5707413538899468\n",
      "Activity 'waste_market for waste plastic, mixture' - Summing exchanges 'market for transport, freight, lorry, unspecified' to open dump 500mm. New amount: -0.5958340520661234\n",
      "Activity 'waste_market for waste plastic, mixture' - Summing exchanges 'market for transport, freight, lorry, unspecified' to open dump 500mm. New amount: -0.6676326911592538\n",
      "Activity 'waste_market for waste plastic, mixture' - Summing exchanges 'market for transport, freight, lorry, unspecified' to open dump 500mm. New amount: -0.9025565131255419\n",
      "Activity 'waste_market for waste plastic, mixture' - Summing exchanges 'market for transport, freight, lorry, unspecified' to open dump 500mm. New amount: -1.0000000000000002\n",
      "Activity 'waste_market for waste polyvinylchloride' - Summing exchanges 'market for transport, freight, lorry, unspecified' to open dump 500mm. New amount: -0.6733494934099946\n",
      "Activity 'waste_market for waste polyvinylchloride' - Summing exchanges 'market for transport, freight, lorry, unspecified' to open dump 500mm. New amount: -0.7809931233229807\n",
      "Activity 'waste_market for waste polyvinylchloride' - Summing exchanges 'market for transport, freight, lorry, unspecified' to open dump 500mm. New amount: -0.8433300460830063\n",
      "Activity 'waste_market for waste polyvinylchloride' - Summing exchanges 'market for transport, freight, lorry, unspecified' to open dump 500mm. New amount: -0.8674830609697036\n",
      "Activity 'waste_market for waste polyvinylchloride' - Summing exchanges 'market for transport, freight, lorry, unspecified' to open dump 500mm. New amount: -0.9025565131255416\n",
      "Activity 'waste_market for waste polyvinylchloride' - Summing exchanges 'market for transport, freight, lorry, unspecified' to open dump 500mm. New amount: -0.9999999999999998\n"
     ]
    }
   ],
   "source": [
    "# Garder seulement les open dump, wet infiltration class\n",
    "\n",
    "for activity in waste_activities:\n",
    "    # Skip the activity if it's in the excluded activities list\n",
    "    if activity['name'] in excluded_activities:\n",
    "        od500mm_exchange = None\n",
    "        total_amount = 0\n",
    "        for exc in activity.exchanges():\n",
    "            total_amount += exc.get('amount', 0)  # Utiliser .get() pour éviter KeyError\n",
    "            if 'open dump' in exc.input['name'] and '500mm' in exc.input['name']:\n",
    "                    od500mm_exchange = exc  # Garder l'échange avec location 'RoW'\n",
    "            if od500mm_exchange:\n",
    "                od500mm_exchange['amount'] = total_amount  # Mettre à jour le montant\n",
    "                od500mm_exchange.save()\n",
    "                print(f\"Activity '{activity['name']}' - Summing exchanges '{name}' to open dump 500mm. New amount: {total_amount}\")\n",
    "            if exc != od500mm_exchange:\n",
    "                    exc.delete()\n",
    "    activity.save()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "id": "de5a4b84-b865-4960-882c-8b25f75bb7d1",
   "metadata": {
    "collapsed": true,
    "jupyter": {
     "outputs_hidden": true,
     "source_hidden": true
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Activity: onsite_market for waste polyvinylchloride\n",
      "  - Replaced 'market for transport, freight, lorry, unspecified' with 'onsite_transport, freight, lorry >32 metric ton, EURO3'\n",
      "Activity: onsite_market for waste polystyrene\n",
      "  - Replaced 'market for transport, freight, lorry, unspecified' with 'onsite_transport, freight, lorry >32 metric ton, EURO3'\n",
      "Activity: onsite_market for waste polyethylene\n",
      "  - Replaced 'market for transport, freight, lorry, unspecified' with 'onsite_transport, freight, lorry >32 metric ton, EURO3'\n",
      "Activity: offsite_market for municipal solid waste\n",
      "  - Replaced 'market for transport, freight, lorry, unspecified' with 'offsite_transport, freight, lorry >32 metric ton, EURO3'\n",
      "Activity: offsite_market for waste polyethylene\n",
      "  - Replaced 'market for transport, freight, lorry, unspecified' with 'offsite_transport, freight, lorry >32 metric ton, EURO3'\n",
      "Activity: offsite_market for waste polyvinylchloride\n",
      "  - Replaced 'market for transport, freight, lorry, unspecified' with 'offsite_transport, freight, lorry >32 metric ton, EURO3'\n",
      "Activity: onsite_market for municipal solid waste\n",
      "  - Replaced 'market for transport, freight, lorry, unspecified' with 'onsite_transport, freight, lorry >32 metric ton, EURO3'\n",
      "Activity: offsite_market for waste polystyrene\n",
      "  - Replaced 'market for transport, freight, lorry, unspecified' with 'offsite_transport, freight, lorry >32 metric ton, EURO3'\n",
      "Activity: onsite_market for wood ash mixture, pure\n",
      "  - Replaced 'market for transport, freight, lorry, unspecified' with 'onsite_transport, freight, lorry >32 metric ton, EURO3'\n",
      "Activity: offsite_market for wood ash mixture, pure\n",
      "  - Replaced 'market for transport, freight, lorry, unspecified' with 'offsite_transport, freight, lorry >32 metric ton, EURO3'\n",
      "Activity: onsite_market for waste plastic, mixture\n",
      "  - Replaced 'market for transport, freight, lorry, unspecified' with 'onsite_transport, freight, lorry >32 metric ton, EURO3'\n",
      "Activity: offsite_market for waste plastic, mixture\n",
      "  - Replaced 'market for transport, freight, lorry, unspecified' with 'offsite_transport, freight, lorry >32 metric ton, EURO3'\n"
     ]
    }
   ],
   "source": [
    "# Remplacer les exchanges de transport, lorry par ceux présents dans ma bdd pour onsite\n",
    "\n",
    "# Table de correspondance des mots clés et des processus à éviter\n",
    "\n",
    "keyword_to_process = {\n",
    "    'diesel': 'market for diesel',\n",
    "    'lub oil': 'market for lubricating oil',\n",
    "    'wood pellet': 'market for wood pellet, measured as dry mass',\n",
    "}\n",
    "# Create a list of activities from the correspondence table to exclude from processing\n",
    "excluded_activities = set(keyword_to_process.values())  # Extracts the process names from the correspondence table\n",
    "\n",
    "transport_name = 'market for transport, freight, lorry, unspecified'\n",
    "\n",
    "# Step 1: Find all activities\n",
    "for activity in elec_bl:\n",
    "    # Extraire la particule de l'activité actuelle\n",
    "    activity_prefix = activity['name'].split('_')[0] + '_'\n",
    "    activity_generic_name = activity['name'].split('_')[1]\n",
    "    if activity_generic_name in excluded_activities:\n",
    "#   print(f\"Skipping activity '{activity['name']}' as it is in the correspondence table.\")\n",
    "        continue\n",
    "    # Créer une liste pour stocker les remplacements de cette activité\n",
    "    replacement_report[activity['name']] = []\n",
    "\n",
    "    replacement_activity = [\n",
    "        activity for activity in elec_bl\n",
    "        if 'transport' in activity['name']    \n",
    "        and 'lorry' in activity['name']    \n",
    "        and activity_prefix in activity['name']    \n",
    "    ][0]\n",
    "\n",
    "    # Itérer à travers les échanges de l'activité actuelle\n",
    "    for exc in activity.exchanges():\n",
    "        old_exc_name = exc.input['name']\n",
    "        new_exc_name = replacement_activity['name']\n",
    "        # Extraire le nom de base de l'échange cible (sans particule)\n",
    "        if 'market for transport, freight, lorry, unspecified' in exc.input['name']:\n",
    "            exc['input'] = replacement_activity.key  # Met à jour la référence de l'échange\n",
    "            exc.save()  # Enregistre l'échange mis à jour\n",
    "            \n",
    "            # Ajouter le remplacement au rapport\n",
    "            replacement_report[activity['name']].append({\n",
    "                'old_exchange': old_exc_name,\n",
    "                'new_activity': new_exc_name\n",
    "            })\n",
    "        activity.save()\n",
    "    \n",
    "# Afficher le rapport de remplacement\n",
    "for activity_name, replacements in replacement_report.items():\n",
    "    if replacements:  # Afficher uniquement si des remplacements ont été effectués\n",
    "        print(f\"Activity: {activity_name}\")\n",
    "        for replacement in replacements:\n",
    "            print(f\"  - Replaced '{replacement['old_exchange']}' with '{replacement['new_activity']}'\")\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "id": "44df243e-f407-4ebb-b57b-9c6033eafe14",
   "metadata": {
    "collapsed": true,
    "jupyter": {
     "outputs_hidden": true,
     "source_hidden": true
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Un nouvel échange vers 'treatment of waste polystyrene, open dump, wet infiltration class (500mm)' a été ajouté au processus 'onsite_market for waste polystyrene' avec un amount de -0.9999999999999998.\n",
      "Un nouvel échange vers 'treatment of municipal solid waste, open dump, wet infiltration class (500mm)' a été ajouté au processus 'onsite_market for municipal solid waste' avec un amount de -1.0000000000000004.\n",
      "Un nouvel échange vers 'treatment of waste plastic, mixture, open dump, wet infiltration class (500mm)' a été ajouté au processus 'onsite_market for waste plastic, mixture' avec un amount de -1.0000000000000002.\n",
      "Un nouvel échange vers 'treatment of waste polyvinylchloride, open dump, wet infiltration class (500mm)' a été ajouté au processus 'onsite_market for waste polyvinylchloride' avec un amount de -0.9999999999999998.\n",
      "Un nouvel échange vers 'treatment of waste polyethylene, open dump, wet infiltration class (500mm)' a été ajouté au processus 'onsite_market for waste polyethylene' avec un amount de -1.0.\n"
     ]
    }
   ],
   "source": [
    "# Copier les exchanges des waste_ dans les onsite_ de mes process de waste spécifiques\n",
    "\n",
    "keyword_to_process_2 = {\n",
    "    'municipal solid waste': 'market for municipal solid waste',\n",
    "    'plastic, mixture': 'market for waste plastic, mixture',\n",
    "    'polystyrene': 'market for waste polystyrene',\n",
    "    'polyvinylchloride': 'market for waste polyvinylchloride',\n",
    "    'polyethylene': 'market for waste polyethylene'\n",
    "}\n",
    "\n",
    "# Step 3: Create a list of activities from the correspondence table to exclude from processing\n",
    "target_activities = set(keyword_to_process_2.values())  # Extracts the process names from the correspondence table\n",
    "# Créer des dictionnaires pour les activités waste_ et onsite_\n",
    "waste_activities = {}\n",
    "onsite_activities = {}\n",
    "\n",
    "# Parcourir les activités pour les classifier en waste_ et onsite_\n",
    "for activity in elec_bl:\n",
    "    if activity['name'].startswith('waste_'):\n",
    "        base_name = activity['name'][6:]  # Nom sans le préfixe waste_\n",
    "        waste_activities[base_name] = activity\n",
    "    elif activity['name'].startswith('onsite_'):\n",
    "        base_name = activity['name'][7:]  # Nom sans le préfixe onsite_\n",
    "        onsite_activities[base_name] = activity\n",
    "        \n",
    "for base_name, waste_activity in waste_activities.items():\n",
    "    # Skip the activity if it's NOT in the excluded activities list\n",
    "    if base_name in target_activities:\n",
    "        # Transférer les exchanges des activités waste_ vers les activités correspondantes onsite_   \n",
    "        if base_name in onsite_activities:\n",
    "            onsite_activity = onsite_activities[base_name]\n",
    "        \n",
    "            # Ajouter les exchanges de waste_ à onsite_\n",
    "            for exchange in waste_activity.exchanges():\n",
    "                new_exc = onsite_activity.new_exchange(\n",
    "                    amount=exchange['amount'],\n",
    "                    input=exchange['input'],\n",
    "                    type=exchange['type'],\n",
    "                    unit=exchange['unit']\n",
    "                )\n",
    "                new_exc.save()    \n",
    "                print(f\"Un nouvel échange vers '{exchange.input['name']}' a été ajouté au processus '{onsite_activity['name']}' avec un amount de {exchange['amount']}.\")\n",
    "\n",
    "        # Sauvegarder les changements dans l'activité onsite_\n",
    "#        onsite_activity.save()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "id": "3c7c2010-e394-46bb-b921-d0018997699a",
   "metadata": {
    "collapsed": true,
    "jupyter": {
     "outputs_hidden": true,
     "source_hidden": true
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_diesel, burned in building machine' avec un amount de -0.0005139999999999999.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_diesel, burned in building machine' avec un amount de -0.0005139999999999999.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_oil boiler production, 100kW' avec un amount de -6.0.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_oil boiler production, 100kW' avec un amount de -6.0.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_oil boiler production, 100kW' avec un amount de -19.0.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_oil boiler production, 100kW' avec un amount de -19.0.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_oil boiler production, 100kW' avec un amount de -10.0.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_oil boiler production, 100kW' avec un amount de -10.0.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_oil boiler production, 100kW' avec un amount de -0.011363110492219584.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_oil boiler production, 100kW' avec un amount de -0.011363110492219584.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_oil boiler production, 100kW' avec un amount de -1.3886368895077814.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_oil boiler production, 100kW' avec un amount de -1.3886368895077814.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_hot water tank production, 600l' avec un amount de -20.0.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_hot water tank production, 600l' avec un amount de -20.0.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_hot water tank production, 600l' avec un amount de -0.03132971892854828.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_hot water tank production, 600l' avec un amount de -0.03132971892854828.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_hot water tank production, 600l' avec un amount de -3.8286702810714535.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_hot water tank production, 600l' avec un amount de -3.8286702810714535.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_hot water tank production, 600l' avec un amount de -2.0.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_hot water tank production, 600l' avec un amount de -2.0.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_furnace production, pellets, with silo, 300kW' avec un amount de -4.0.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_furnace production, pellets, with silo, 300kW' avec un amount de -4.0.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_furnace production, pellets, with silo, 300kW' avec un amount de -686.0.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_furnace production, pellets, with silo, 300kW' avec un amount de -686.0.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_furnace production, pellets, with silo, 300kW' avec un amount de -9.5.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_furnace production, pellets, with silo, 300kW' avec un amount de -9.5.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_furnace production, pellets, with silo, 300kW' avec un amount de -4.5.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_furnace production, pellets, with silo, 300kW' avec un amount de -4.5.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_furnace production, pellets, with silo, 300kW' avec un amount de -2920.0.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_furnace production, pellets, with silo, 300kW' avec un amount de -2920.0.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_furnace production, pellets, with silo, 300kW' avec un amount de -39667.0.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_furnace production, pellets, with silo, 300kW' avec un amount de -39667.0.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_furnace production, pellets, with silo, 300kW' avec un amount de -3.0.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_furnace production, pellets, with silo, 300kW' avec un amount de -3.0.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_furnace production, pellets, with silo, 300kW' avec un amount de -266.0.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_furnace production, pellets, with silo, 300kW' avec un amount de -266.0.\n",
      "Un nouvel échange vers 'onsite_market for waste polyethylene' a été ajouté au processus 'onsite_furnace production, pellets, with silo, 300kW' avec un amount de -0.01133232216642502.\n",
      "Un nouvel échange vers 'offsite_market for waste polyethylene' a été ajouté au processus 'onsite_furnace production, pellets, with silo, 300kW' avec un amount de -0.01133232216642502.\n",
      "Un nouvel échange vers 'onsite_market for waste polyethylene' a été ajouté au processus 'onsite_furnace production, pellets, with silo, 300kW' avec un amount de -5.4886676778335755.\n",
      "Un nouvel échange vers 'offsite_market for waste polyethylene' a été ajouté au processus 'onsite_furnace production, pellets, with silo, 300kW' avec un amount de -5.4886676778335755.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_furnace production, pellets, with silo, 300kW' avec un amount de -52.00000000000001.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_furnace production, pellets, with silo, 300kW' avec un amount de -52.00000000000001.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_excavation, skid-steer loader' avec un amount de -0.003.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_excavation, skid-steer loader' avec un amount de -0.003.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_excavation, hydraulic digger' avec un amount de -0.0025.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_excavation, hydraulic digger' avec un amount de -0.0025.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_diesel, burned in diesel-electric generating set, 10MW' avec un amount de -6.7e-05.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_diesel, burned in diesel-electric generating set, 10MW' avec un amount de -6.7e-05.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_distribution network construction, electricity, low voltage' avec un amount de -38608.0752528907.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_distribution network construction, electricity, low voltage' avec un amount de -38608.0752528907.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_distribution network construction, electricity, low voltage' avec un amount de -1244.37819899756.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_distribution network construction, electricity, low voltage' avec un amount de -1244.37819899756.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_distribution network construction, electricity, low voltage' avec un amount de -286.496376048276.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_distribution network construction, electricity, low voltage' avec un amount de -286.496376048276.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_distribution network construction, electricity, low voltage' avec un amount de -1153.4980758317.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_distribution network construction, electricity, low voltage' avec un amount de -1153.4980758317.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_distribution network construction, electricity, low voltage' avec un amount de -1167.17450085975.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_distribution network construction, electricity, low voltage' avec un amount de -1167.17450085975.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_distribution network construction, electricity, low voltage' avec un amount de -8527.3668830531.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_distribution network construction, electricity, low voltage' avec un amount de -8527.3668830531.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_transport, freight, lorry >32 metric ton, EURO3' avec un amount de -1.52615789473684e-05.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_transport, freight, lorry >32 metric ton, EURO3' avec un amount de -1.52615789473684e-05.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_transport, freight, lorry >32 metric ton, EURO3' avec un amount de -1.3140350877193e-05.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_transport, freight, lorry >32 metric ton, EURO3' avec un amount de -1.3140350877193e-05.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_transport, freight, lorry >32 metric ton, EURO3' avec un amount de -0.000151207894736842.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_transport, freight, lorry >32 metric ton, EURO3' avec un amount de -0.000151207894736842.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_chimney production' avec un amount de -95.0.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_chimney production' avec un amount de -95.0.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_chimney production' avec un amount de -0.5.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_chimney production' avec un amount de -0.5.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_electricity production, oil' avec un amount de -2.53622741516298e-05.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_electricity production, oil' avec un amount de -2.53622741516298e-05.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_electricity production, oil' avec un amount de -3.13826647401871e-05.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_electricity production, oil' avec un amount de -3.13826647401871e-05.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_electricity production, oil' avec un amount de -0.000673476292640615.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_electricity production, oil' avec un amount de -0.000673476292640615.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_electricity production, oil' avec un amount de -0.000178579718058257.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_electricity production, oil' avec un amount de -0.000178579718058257.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_electricity production, oil' avec un amount de -0.000161318814201025.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_electricity production, oil' avec un amount de -0.000161318814201025.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_electricity production, oil' avec un amount de -0.000650001808939596.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_electricity production, oil' avec un amount de -0.000650001808939596.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_oil storage production, 3000l' avec un amount de -495.0.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_oil storage production, 3000l' avec un amount de -495.0.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_oil storage production, 3000l' avec un amount de -0.004464079121943409.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_oil storage production, 3000l' avec un amount de -0.004464079121943409.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_oil storage production, 3000l' avec un amount de -0.5455359208780569.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_oil storage production, 3000l' avec un amount de -0.5455359208780569.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_inverter production, 2.5kW' avec un amount de -1.7028.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_inverter production, 2.5kW' avec un amount de -1.7028.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_inverter production, 2.5kW' avec un amount de -2.5.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_inverter production, 2.5kW' avec un amount de -2.5.\n",
      "Un nouvel échange vers 'onsite_market for waste polyethylene' a été ajouté au processus 'onsite_inverter production, 2.5kW' avec un amount de -0.05999999999999999.\n",
      "Un nouvel échange vers 'offsite_market for waste polyethylene' a été ajouté au processus 'onsite_inverter production, 2.5kW' avec un amount de -0.05999999999999999.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_inverter production, 2.5kW' avec un amount de -0.31000000000000005.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_inverter production, 2.5kW' avec un amount de -0.31000000000000005.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_oil power plant construction, 500MW' avec un amount de -112000000.0.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_oil power plant construction, 500MW' avec un amount de -112000000.0.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_oil power plant construction, 500MW' avec un amount de -60000.0.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_oil power plant construction, 500MW' avec un amount de -60000.0.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_oil power plant construction, 500MW' avec un amount de -300000.0.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_oil power plant construction, 500MW' avec un amount de -300000.0.\n",
      "Un nouvel échange vers 'onsite_market for waste polyethylene' a été ajouté au processus 'onsite_oil power plant construction, 500MW' avec un amount de -300000.0.\n",
      "Un nouvel échange vers 'offsite_market for waste polyethylene' a été ajouté au processus 'onsite_oil power plant construction, 500MW' avec un amount de -300000.0.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_photovoltaics, electric installation for 3kWp module, at building' avec un amount de -0.02.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_photovoltaics, electric installation for 3kWp module, at building' avec un amount de -0.02.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_photovoltaics, electric installation for 3kWp module, at building' avec un amount de -0.9.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_photovoltaics, electric installation for 3kWp module, at building' avec un amount de -0.9.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_photovoltaics, electric installation for 3kWp module, at building' avec un amount de -29.34.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_photovoltaics, electric installation for 3kWp module, at building' avec un amount de -29.34.\n",
      "Un nouvel échange vers 'onsite_market for waste polyethylene' a été ajouté au processus 'onsite_photovoltaics, electric installation for 3kWp module, at building' avec un amount de -0.20200000000000004.\n",
      "Un nouvel échange vers 'offsite_market for waste polyethylene' a été ajouté au processus 'onsite_photovoltaics, electric installation for 3kWp module, at building' avec un amount de -0.20200000000000004.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_photovoltaics, electric installation for 3kWp module, at building' avec un amount de -2.111810378597408.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_photovoltaics, electric installation for 3kWp module, at building' avec un amount de -2.111810378597408.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_photovoltaics, electric installation for 3kWp module, at building' avec un amount de -0.018189621402591793.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_photovoltaics, electric installation for 3kWp module, at building' avec un amount de -0.018189621402591793.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_heat production, wood pellet, at furnace 300kW' avec un amount de -0.00031733333333333396.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_heat production, wood pellet, at furnace 300kW' avec un amount de -0.00031733333333333396.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_photovoltaic mounting system production, for facade installation' avec un amount de -2.6353.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_photovoltaic mounting system production, for facade installation' avec un amount de -2.6353.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_photovoltaic mounting system production, for facade installation' avec un amount de -1.7971.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_photovoltaic mounting system production, for facade installation' avec un amount de -1.7971.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_photovoltaic mounting system production, for facade installation' avec un amount de -0.040262.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_photovoltaic mounting system production, for facade installation' avec un amount de -0.040262.\n",
      "Un nouvel échange vers 'onsite_market for waste polyethylene' a été ajouté au processus 'onsite_photovoltaic mounting system production, for facade installation' avec un amount de -0.00073203.\n",
      "Un nouvel échange vers 'offsite_market for waste polyethylene' a été ajouté au processus 'onsite_photovoltaic mounting system production, for facade installation' avec un amount de -0.00073203.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_photovoltaic mounting system production, for facade installation' avec un amount de -0.0036601.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_photovoltaic mounting system production, for facade installation' avec un amount de -0.0036601.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_photovoltaic panel production, multi-Si wafer' avec un amount de -0.030000000000000002.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_photovoltaic panel production, multi-Si wafer' avec un amount de -0.030000000000000002.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_photovoltaic panel production, multi-Si wafer' avec un amount de -0.0016069.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_photovoltaic panel production, multi-Si wafer' avec un amount de -0.0016069.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_photovoltaic panel production, multi-Si wafer' avec un amount de -1.6861000000000002.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_photovoltaic panel production, multi-Si wafer' avec un amount de -1.6861000000000002.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_photovoltaic panel production, multi-Si wafer' avec un amount de -0.1104.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_photovoltaic panel production, multi-Si wafer' avec un amount de -0.1104.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_road construction' avec un amount de -117.803652968037.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_road construction' avec un amount de -117.803652968037.\n",
      "Un nouvel échange vers 'onsite_market for municipal solid waste' a été ajouté au processus 'onsite_road construction' avec un amount de -0.35167.\n",
      "Un nouvel échange vers 'offsite_market for municipal solid waste' a été ajouté au processus 'onsite_road construction' avec un amount de -0.35167.\n"
     ]
    }
   ],
   "source": [
    "# Mettre les activités de waste dans les activités onsite et offsite correspondantes\n",
    "\n",
    "keyword_to_process = {\n",
    "    'municipal solid waste': 'waste_market for municipal solid waste',\n",
    "    'plastic, mixture': 'waste_market for waste plastic, mixture',\n",
    "    'polystyrene': 'waste_market for waste polystyrene',\n",
    "    'polyvinylchloride': 'waste_market for waste polyvinylchloride',\n",
    "    'polyethylene': 'waste_market for waste polyethylene'\n",
    "}\n",
    "\n",
    "excluded_activities = set(keyword_to_process.values())  # Extracts the process names from the correspondence table\n",
    "\n",
    "# Step 1: Find all activities with 'waste_' in their name\n",
    "waste_activities = [act for act in elec_bl if 'waste_' in act['name']]\n",
    "\n",
    "for waste_activity in waste_activities:\n",
    "    # Skip the activity if it's in the excluded activities list\n",
    "    if waste_activity['name'] not in excluded_activities:\n",
    "        # Extraire le base_name sans le préfixe waste_\n",
    "        base_name = waste_activity['name'].replace('waste_', '')\n",
    "\n",
    "        # Chercher les activités onsite_ et offsite_ correspondant au même base_name\n",
    "        onsite_activity = [act for act in elec_bl if act['name'] == f'onsite_{base_name}'][0]\n",
    "        offsite_activity = [act for act in elec_bl if act['name'] == f'offsite_{base_name}'][0]\n",
    "\n",
    "        # Parcourir les exchanges de waste_activity\n",
    "        for exchange in waste_activity.exchanges():\n",
    "            base_exc_name = exchange.input['name'].replace('waste_', '')\n",
    "            if 'waste_' in exchange.input['name']:  # Vérifie si l'exchange pointe vers une activité waste_\n",
    "                # Copier l'exchange dans onsite_ et remplacer waste_ par onsite_\n",
    "                if onsite_activity:\n",
    "                    new_input_onsite = [act for act in elec_bl if act['name'] ==f'onsite_{base_exc_name}'][0]\n",
    "                    new_exc_onsite = onsite_activity.new_exchange(\n",
    "                        amount=exchange['amount'],\n",
    "                        input=new_input_onsite,\n",
    "                        type=exchange['type'],\n",
    "                        unit=exchange['unit']\n",
    "                    )\n",
    "                    new_exc_onsite.save()    \n",
    "                print(f\"Un nouvel échange vers '{new_exc_onsite.input['name']}' a été ajouté au processus '{onsite_activity['name']}' avec un amount de {new_exc_onsite['amount']}.\")                \n",
    "                # Copier l'exchange dans offsite_ et remplacer waste_ par offsite_\n",
    "                if offsite_activity:\n",
    "                    new_input_offsite = [act for act in elec_bl if act['name'] ==f'offsite_{base_exc_name}'][0]\n",
    "                    new_exc_offsite = offsite_activity.new_exchange(\n",
    "                        amount=exchange['amount'],\n",
    "                        input=new_input_offsite,\n",
    "                        type=exchange['type'],\n",
    "                        unit=exchange['unit']\n",
    "                    )\n",
    "                    new_exc_offsite.save()    \n",
    "                print(f\"Un nouvel échange vers '{new_exc_offsite.input['name']}' a été ajouté au processus '{onsite_activity['name']}' avec un amount de {new_exc_offsite['amount']}.\")\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "9d5ea104-563d-420d-9db6-cdcd2ad85b45",
   "metadata": {
    "collapsed": true,
    "jupyter": {
     "outputs_hidden": true
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Un nouvel échange vers 'market for transport, freight, sea, tanker for petroleum' a été ajouté au processus 'offsite_market for diesel' avec un amount de 3.\n",
      "Un nouvel échange vers 'market for transport, freight, sea, tanker for petroleum' a été ajouté au processus 'offsite_market for lubricating oil' avec un amount de 3.\n",
      "Un nouvel échange vers 'market for transport, freight, sea, container ship with reefer, cooling' a été ajouté au processus 'offsite_market for wood pellet, measured as dry mass' avec un amount de 3.\n"
     ]
    }
   ],
   "source": [
    "# Ajouter les distances parcourues aux consommables (diesel, oil, wood).\n",
    "\n",
    "# Fonction pour ajouter un nouvel échange à un processus donné\n",
    "def add_new_exchange(activity, exchange, quantity, exchange_type='technosphere'):\n",
    "    new_exc = activity.new_exchange(\n",
    "        input=exchange,  # L'activité vers laquelle l'échange est dirigé\n",
    "        amount=quantity,  # La quantité allouée\n",
    "        type=exchange_type  # Type d'échange (e.g., 'technosphere' ou 'biosphere')\n",
    "    )\n",
    "    new_exc.save()  # Sauvegarde le nouvel échange\n",
    "    print(f\"Un nouvel échange vers '{exchange['name']}' a été ajouté au processus '{activity['name']}' avec un amount de {quantity}.\")\n",
    "\n",
    "# Activités cibles\n",
    "diesel = [\n",
    "    activity for activity in elec_bl\n",
    "    if 'market for diesel' in activity['name']    \n",
    "    and 'offsite' in activity['name']    \n",
    "][0]\n",
    "lub_oil = [\n",
    "    activity for activity in elec_bl\n",
    "    if 'market for lubricating oil' in activity['name']    \n",
    "    and 'offsite' in activity['name']    \n",
    "][0]\n",
    "wood_pellet = [\n",
    "    activity for activity in elec_bl\n",
    "    if 'market for wood pellet' in activity['name']    \n",
    "    and 'offsite' in activity['name']    \n",
    "][0]\n",
    "\n",
    "# Echanges à ajouter\n",
    "petroleum_ship = [\n",
    "    activity for activity in eidb\n",
    "    if 'market for transport, freight, sea, tanker for petroleum' in activity['name']\n",
    "][0]\n",
    "container_ship = [\n",
    "    activity for activity in eidb\n",
    "    if 'market for transport, freight, sea, container ship' in activity['name']\n",
    "][0]\n",
    "\n",
    "# Ajouter un nouvel échange dans les deux processus\n",
    "add_new_exchange(diesel, petroleum_ship, quantity=3)\n",
    "add_new_exchange(lub_oil, petroleum_ship, quantity=3)\n",
    "add_new_exchange(wood_pellet, container_ship, quantity=3)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "id": "b27ed535-441d-48ab-815f-99cc734c8066",
   "metadata": {
    "jupyter": {
     "source_hidden": true
    }
   },
   "outputs": [],
   "source": [
    "# Créer les activités des systèmes modélisés\n",
    "scenarios = ['electricity, baseline', 'electricity, alternative', 'heat, baseline', 'heat, alternative']\n",
    "phases = ['production', 'distribution', 'use', 'end of life']\n",
    "locations = ['onsite', 'offsite']\n",
    "\n",
    "# Parcourir chaque combinaison de scénario et phase pour créer des activités\n",
    "for scenario in scenarios:\n",
    "    for location in locations:\n",
    "        # Créer une nouvelle activité dans la base de données\n",
    "        activity_name = f\"{location}_{scenario}\"\n",
    "        new_activity = elec_bl.new_activity(\n",
    "            code=generate_unique_id(),  # Générer un code unique\n",
    "            name=activity_name,\n",
    "            unit=\"item\",  # Unité en termes d'items\n",
    "            type=\"process\",  # Type d'activité\n",
    "        )\n",
    "        \n",
    "        # Sauvegarder l'activité\n",
    "        new_activity.save()\n",
    "        for phase in phases:\n",
    "            # Nom de l'activité combinant le scénario et la phase\n",
    "            activity_name = f\"{location}_{scenario}, {phase} phase\"\n",
    "    \n",
    "            # Créer une nouvelle activité dans la base de données\n",
    "            new_activity = elec_bl.new_activity(\n",
    "                code=generate_unique_id(),  # Générer un code unique\n",
    "                name=activity_name,\n",
    "                unit=\"item\",  # Unité en termes d'items\n",
    "                type=\"process\",  # Type d'activité\n",
    "            )\n",
    "    \n",
    "            # Sauvegarder l'activité\n",
    "            new_activity.save()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "774bd705-1033-4839-bdef-c6844a6fb838",
   "metadata": {
    "jupyter": {
     "source_hidden": true
    }
   },
   "outputs": [],
   "source": [
    "### Récupérer les noms des activités dans un excel en supprimant les préfixes et en évitant les doublons\n",
    "prefixes = ['offsite_', 'onsite_', 'waste_']\n",
    "activity_names = [activity['name'] for activity in elec_bl]\n",
    "\n",
    "# Supprimer les préfixes\n",
    "cleaned_activity_names = []\n",
    "for name in activity_names:\n",
    "    for prefix in prefixes:\n",
    "        if name.startswith(prefix):\n",
    "            name = name[len(prefix):]\n",
    "    cleaned_activity_names.append(name)\n",
    "\n",
    "# Enlever les doublons\n",
    "unique_activity_names = list(set(cleaned_activity_names))\n",
    "\n",
    "# Créer un DataFrame avec les noms sans doublons\n",
    "df = pd.DataFrame(unique_activity_names, columns=['Activity Name'])\n",
    "\n",
    "# Écrire le DataFrame dans un fichier Excel\n",
    "#df.to_excel(\"activities_names.xlsx\", index=False)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "id": "0e0a3e73-2aff-4604-962d-32ed86a352f8",
   "metadata": {
    "collapsed": true,
    "jupyter": {
     "outputs_hidden": true,
     "source_hidden": true
    },
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "offsite_electricity, baseline, production phase\n",
      "offsite_distribution network construction, electricity, low voltage 5.517241379310345e-09\n",
      "Un nouvel échange vers 'offsite_distribution network construction, electricity, low voltage' a été ajouté au processus 'offsite_electricity, baseline, production phase' avec un amount de 5.517241379310345e-09.\n",
      "offsite_oil power plant construction, 500MW 2.5300000000000002e-11\n",
      "Un nouvel échange vers 'offsite_oil power plant construction, 500MW' a été ajouté au processus 'offsite_electricity, baseline, production phase' avec un amount de 2.5300000000000002e-11.\n",
      "offsite_electricity, baseline, distribution phase\n",
      "offsite_distribution network construction, electricity, low voltage 5.517241379310345e-09\n",
      "Un nouvel échange vers 'offsite_distribution network construction, electricity, low voltage' a été ajouté au processus 'offsite_electricity, baseline, distribution phase' avec un amount de 5.517241379310345e-09.\n",
      "offsite_oil power plant construction, 500MW 2.5300000000000002e-11\n",
      "Un nouvel échange vers 'offsite_oil power plant construction, 500MW' a été ajouté au processus 'offsite_electricity, baseline, distribution phase' avec un amount de 2.5300000000000002e-11.\n",
      "offsite_electricity, baseline, use phase\n",
      "offsite_diesel, burned in diesel-electric generating set, 10MW 3.9240000000000004\n",
      "Un nouvel échange vers 'offsite_diesel, burned in diesel-electric generating set, 10MW' a été ajouté au processus 'offsite_electricity, baseline, use phase' avec un amount de 3.9240000000000004.\n",
      "offsite_electricity production, oil 1.09\n",
      "Un nouvel échange vers 'offsite_electricity production, oil' a été ajouté au processus 'offsite_electricity, baseline, use phase' avec un amount de 1.09.\n",
      "offsite_electricity, baseline, end of life phase\n",
      "offsite_distribution network construction, electricity, low voltage 5.517241379310345e-09\n",
      "Un nouvel échange vers 'offsite_distribution network construction, electricity, low voltage' a été ajouté au processus 'offsite_electricity, baseline, end of life phase' avec un amount de 5.517241379310345e-09.\n",
      "offsite_oil power plant construction, 500MW 2.5300000000000002e-11\n",
      "Un nouvel échange vers 'offsite_oil power plant construction, 500MW' a été ajouté au processus 'offsite_electricity, baseline, end of life phase' avec un amount de 2.5300000000000002e-11.\n",
      "offsite_electricity, alternative, production phase\n",
      "offsite_distribution network construction, electricity, low voltage 2.1075862068965515e-09\n",
      "Un nouvel échange vers 'offsite_distribution network construction, electricity, low voltage' a été ajouté au processus 'offsite_electricity, alternative, production phase' avec un amount de 2.1075862068965515e-09.\n",
      "offsite_oil power plant construction, 500MW 9.656196e-12\n",
      "Un nouvel échange vers 'offsite_oil power plant construction, 500MW' a été ajouté au processus 'offsite_electricity, alternative, production phase' avec un amount de 9.656196e-12.\n",
      "offsite_photovoltaic facade installation, 3kWp, multi-Si, panel, mounted, at building 8.352888e-06\n",
      "Un nouvel échange vers 'offsite_photovoltaic facade installation, 3kWp, multi-Si, panel, mounted, at building' a été ajouté au processus 'offsite_electricity, alternative, production phase' avec un amount de 8.352888e-06.\n",
      "offsite_electricity, alternative, distribution phase\n",
      "offsite_distribution network construction, electricity, low voltage 2.1075862068965515e-09\n",
      "Un nouvel échange vers 'offsite_distribution network construction, electricity, low voltage' a été ajouté au processus 'offsite_electricity, alternative, distribution phase' avec un amount de 2.1075862068965515e-09.\n",
      "offsite_oil power plant construction, 500MW 9.656196e-12\n",
      "Un nouvel échange vers 'offsite_oil power plant construction, 500MW' a été ajouté au processus 'offsite_electricity, alternative, distribution phase' avec un amount de 9.656196e-12.\n",
      "offsite_photovoltaic facade installation, 3kWp, multi-Si, panel, mounted, at building 8.352888e-06\n",
      "Un nouvel échange vers 'offsite_photovoltaic facade installation, 3kWp, multi-Si, panel, mounted, at building' a été ajouté au processus 'offsite_electricity, alternative, distribution phase' avec un amount de 8.352888e-06.\n",
      "offsite_electricity, alternative, use phase\n",
      "offsite_electricity production, photovoltaic, 3kWp facade installation, multi-Si, panel, mounted 0.618\n",
      "Un nouvel échange vers 'offsite_electricity production, photovoltaic, 3kWp facade installation, multi-Si, panel, mounted' a été ajouté au processus 'offsite_electricity, alternative, use phase' avec un amount de 0.618.\n",
      "offsite_electricity, baseline 0.382\n",
      "Un nouvel échange vers 'offsite_electricity, baseline' a été ajouté au processus 'offsite_electricity, alternative, use phase' avec un amount de 0.382.\n",
      "offsite_electricity, alternative, end of life phase\n",
      "offsite_inverter production, 2.5kW 8.352888e-06\n",
      "Un nouvel échange vers 'offsite_inverter production, 2.5kW' a été ajouté au processus 'offsite_electricity, alternative, end of life phase' avec un amount de 8.352888e-06.\n",
      "offsite_photovoltaic mounting system production, for facade installation 8.352888e-06\n",
      "Un nouvel échange vers 'offsite_photovoltaic mounting system production, for facade installation' a été ajouté au processus 'offsite_electricity, alternative, end of life phase' avec un amount de 8.352888e-06.\n",
      "offsite_photovoltaic panel production, multi-Si wafer 8.352888e-06\n",
      "Un nouvel échange vers 'offsite_photovoltaic panel production, multi-Si wafer' a été ajouté au processus 'offsite_electricity, alternative, end of life phase' avec un amount de 8.352888e-06.\n",
      "offsite_photovoltaics, electric installation for 3kWp module, at building 8.352888e-06\n",
      "Un nouvel échange vers 'offsite_photovoltaics, electric installation for 3kWp module, at building' a été ajouté au processus 'offsite_electricity, alternative, end of life phase' avec un amount de 8.352888e-06.\n",
      "offsite_electricity, baseline, end of life phase 0.382\n",
      "Un nouvel échange vers 'offsite_electricity, baseline, end of life phase' a été ajouté au processus 'offsite_electricity, alternative, end of life phase' avec un amount de 0.382.\n",
      "offsite_heat, baseline, production phase\n",
      "offsite_chimney production 4.1825000000000003e-07\n",
      "Un nouvel échange vers 'offsite_chimney production' a été ajouté au processus 'offsite_heat, baseline, production phase' avec un amount de 4.1825000000000003e-07.\n",
      "offsite_oil boiler production, 100kW 9.798999999999999e-08\n",
      "Un nouvel échange vers 'offsite_oil boiler production, 100kW' a été ajouté au processus 'offsite_heat, baseline, production phase' avec un amount de 9.798999999999999e-08.\n",
      "offsite_oil storage production, 3000l 1.8124166666666666e-07\n",
      "Un nouvel échange vers 'offsite_oil storage production, 3000l' a été ajouté au processus 'offsite_heat, baseline, production phase' avec un amount de 1.8124166666666666e-07.\n",
      "offsite_heat, baseline, distribution phase\n",
      "offsite_heat, baseline, use phase\n",
      "offsite_heat production, light fuel oil, at boiler 100kW, non-modulating 1.0\n",
      "Un nouvel échange vers 'offsite_heat production, light fuel oil, at boiler 100kW, non-modulating' a été ajouté au processus 'offsite_heat, baseline, use phase' avec un amount de 1.0.\n",
      "offsite_heat, baseline, end of life phase\n",
      "offsite_chimney production 4.1825000000000003e-07\n",
      "Un nouvel échange vers 'offsite_chimney production' a été ajouté au processus 'offsite_heat, baseline, end of life phase' avec un amount de 4.1825000000000003e-07.\n",
      "offsite_oil boiler production, 100kW 9.798999999999999e-08\n",
      "Un nouvel échange vers 'offsite_oil boiler production, 100kW' a été ajouté au processus 'offsite_heat, baseline, end of life phase' avec un amount de 9.798999999999999e-08.\n",
      "offsite_oil storage production, 3000l 1.8124166666666666e-07\n",
      "Un nouvel échange vers 'offsite_oil storage production, 3000l' a été ajouté au processus 'offsite_heat, baseline, end of life phase' avec un amount de 1.8124166666666666e-07.\n",
      "offsite_heat, alternative, production phase\n",
      "offsite_furnace production, pellets, with silo, 300kW 3.983333333333333e-08\n",
      "Un nouvel échange vers 'offsite_furnace production, pellets, with silo, 300kW' a été ajouté au processus 'offsite_heat, alternative, production phase' avec un amount de 3.983333333333333e-08.\n",
      "offsite_hot water tank production, 600l 8.604e-07\n",
      "Un nouvel échange vers 'offsite_hot water tank production, 600l' a été ajouté au processus 'offsite_heat, alternative, production phase' avec un amount de 8.604e-07.\n",
      "offsite_heat, alternative, distribution phase\n",
      "offsite_heat, alternative, use phase\n",
      "offsite_heat production, wood pellet, at furnace 300kW 1.0\n",
      "Un nouvel échange vers 'offsite_heat production, wood pellet, at furnace 300kW' a été ajouté au processus 'offsite_heat, alternative, use phase' avec un amount de 1.0.\n",
      "offsite_heat, alternative, end of life phase\n",
      "offsite_furnace production, pellets, with silo, 300kW 3.983333333333333e-08\n",
      "Un nouvel échange vers 'offsite_furnace production, pellets, with silo, 300kW' a été ajouté au processus 'offsite_heat, alternative, end of life phase' avec un amount de 3.983333333333333e-08.\n",
      "offsite_hot water tank production, 600l 8.604e-07\n",
      "Un nouvel échange vers 'offsite_hot water tank production, 600l' a été ajouté au processus 'offsite_heat, alternative, end of life phase' avec un amount de 8.604e-07.\n",
      "onsite_electricity, baseline, production phase\n",
      "onsite_distribution network construction, electricity, low voltage 5.517241379310345e-09\n",
      "Un nouvel échange vers 'onsite_distribution network construction, electricity, low voltage' a été ajouté au processus 'onsite_electricity, baseline, production phase' avec un amount de 5.517241379310345e-09.\n",
      "onsite_oil power plant construction, 500MW 2.5300000000000002e-11\n",
      "Un nouvel échange vers 'onsite_oil power plant construction, 500MW' a été ajouté au processus 'onsite_electricity, baseline, production phase' avec un amount de 2.5300000000000002e-11.\n",
      "onsite_electricity, baseline, distribution phase\n",
      "onsite_distribution network construction, electricity, low voltage 5.517241379310345e-09\n",
      "Un nouvel échange vers 'onsite_distribution network construction, electricity, low voltage' a été ajouté au processus 'onsite_electricity, baseline, distribution phase' avec un amount de 5.517241379310345e-09.\n",
      "onsite_oil power plant construction, 500MW 2.5300000000000002e-11\n",
      "Un nouvel échange vers 'onsite_oil power plant construction, 500MW' a été ajouté au processus 'onsite_electricity, baseline, distribution phase' avec un amount de 2.5300000000000002e-11.\n",
      "onsite_electricity, baseline, use phase\n",
      "onsite_diesel, burned in diesel-electric generating set, 10MW 3.9240000000000004\n",
      "Un nouvel échange vers 'onsite_diesel, burned in diesel-electric generating set, 10MW' a été ajouté au processus 'onsite_electricity, baseline, use phase' avec un amount de 3.9240000000000004.\n",
      "onsite_electricity production, oil 1.09\n",
      "Un nouvel échange vers 'onsite_electricity production, oil' a été ajouté au processus 'onsite_electricity, baseline, use phase' avec un amount de 1.09.\n",
      "onsite_electricity, baseline, end of life phase\n",
      "onsite_distribution network construction, electricity, low voltage 5.517241379310345e-09\n",
      "Un nouvel échange vers 'onsite_distribution network construction, electricity, low voltage' a été ajouté au processus 'onsite_electricity, baseline, end of life phase' avec un amount de 5.517241379310345e-09.\n",
      "onsite_oil power plant construction, 500MW 2.5300000000000002e-11\n",
      "Un nouvel échange vers 'onsite_oil power plant construction, 500MW' a été ajouté au processus 'onsite_electricity, baseline, end of life phase' avec un amount de 2.5300000000000002e-11.\n",
      "onsite_electricity, alternative, production phase\n",
      "onsite_distribution network construction, electricity, low voltage 2.1075862068965515e-09\n",
      "Un nouvel échange vers 'onsite_distribution network construction, electricity, low voltage' a été ajouté au processus 'onsite_electricity, alternative, production phase' avec un amount de 2.1075862068965515e-09.\n",
      "onsite_oil power plant construction, 500MW 9.656196e-12\n",
      "Un nouvel échange vers 'onsite_oil power plant construction, 500MW' a été ajouté au processus 'onsite_electricity, alternative, production phase' avec un amount de 9.656196e-12.\n",
      "onsite_photovoltaic facade installation, 3kWp, multi-Si, panel, mounted, at building 8.352888e-06\n",
      "Un nouvel échange vers 'onsite_photovoltaic facade installation, 3kWp, multi-Si, panel, mounted, at building' a été ajouté au processus 'onsite_electricity, alternative, production phase' avec un amount de 8.352888e-06.\n",
      "onsite_electricity, alternative, distribution phase\n",
      "onsite_distribution network construction, electricity, low voltage 2.1075862068965515e-09\n",
      "Un nouvel échange vers 'onsite_distribution network construction, electricity, low voltage' a été ajouté au processus 'onsite_electricity, alternative, distribution phase' avec un amount de 2.1075862068965515e-09.\n",
      "onsite_oil power plant construction, 500MW 9.656196e-12\n",
      "Un nouvel échange vers 'onsite_oil power plant construction, 500MW' a été ajouté au processus 'onsite_electricity, alternative, distribution phase' avec un amount de 9.656196e-12.\n",
      "onsite_photovoltaic facade installation, 3kWp, multi-Si, panel, mounted, at building 8.352888e-06\n",
      "Un nouvel échange vers 'onsite_photovoltaic facade installation, 3kWp, multi-Si, panel, mounted, at building' a été ajouté au processus 'onsite_electricity, alternative, distribution phase' avec un amount de 8.352888e-06.\n",
      "onsite_electricity, alternative, use phase\n",
      "onsite_electricity production, photovoltaic, 3kWp facade installation, multi-Si, panel, mounted 0.618\n",
      "Un nouvel échange vers 'onsite_electricity production, photovoltaic, 3kWp facade installation, multi-Si, panel, mounted' a été ajouté au processus 'onsite_electricity, alternative, use phase' avec un amount de 0.618.\n",
      "onsite_electricity, baseline 0.382\n",
      "Un nouvel échange vers 'onsite_electricity, baseline' a été ajouté au processus 'onsite_electricity, alternative, use phase' avec un amount de 0.382.\n",
      "onsite_electricity, alternative, end of life phase\n",
      "onsite_inverter production, 2.5kW 8.352888e-06\n",
      "Un nouvel échange vers 'onsite_inverter production, 2.5kW' a été ajouté au processus 'onsite_electricity, alternative, end of life phase' avec un amount de 8.352888e-06.\n",
      "onsite_photovoltaic mounting system production, for facade installation 8.352888e-06\n",
      "Un nouvel échange vers 'onsite_photovoltaic mounting system production, for facade installation' a été ajouté au processus 'onsite_electricity, alternative, end of life phase' avec un amount de 8.352888e-06.\n",
      "onsite_photovoltaic panel production, multi-Si wafer 8.352888e-06\n",
      "Un nouvel échange vers 'onsite_photovoltaic panel production, multi-Si wafer' a été ajouté au processus 'onsite_electricity, alternative, end of life phase' avec un amount de 8.352888e-06.\n",
      "onsite_photovoltaics, electric installation for 3kWp module, at building 8.352888e-06\n",
      "Un nouvel échange vers 'onsite_photovoltaics, electric installation for 3kWp module, at building' a été ajouté au processus 'onsite_electricity, alternative, end of life phase' avec un amount de 8.352888e-06.\n",
      "onsite_electricity, baseline, end of life phase 0.382\n",
      "Un nouvel échange vers 'onsite_electricity, baseline, end of life phase' a été ajouté au processus 'onsite_electricity, alternative, end of life phase' avec un amount de 0.382.\n",
      "onsite_heat, baseline, production phase\n",
      "onsite_chimney production 4.1825000000000003e-07\n",
      "Un nouvel échange vers 'onsite_chimney production' a été ajouté au processus 'onsite_heat, baseline, production phase' avec un amount de 4.1825000000000003e-07.\n",
      "onsite_oil boiler production, 100kW 9.798999999999999e-08\n",
      "Un nouvel échange vers 'onsite_oil boiler production, 100kW' a été ajouté au processus 'onsite_heat, baseline, production phase' avec un amount de 9.798999999999999e-08.\n",
      "onsite_oil storage production, 3000l 1.8124166666666666e-07\n",
      "Un nouvel échange vers 'onsite_oil storage production, 3000l' a été ajouté au processus 'onsite_heat, baseline, production phase' avec un amount de 1.8124166666666666e-07.\n",
      "onsite_heat, baseline, distribution phase\n",
      "onsite_heat, baseline, use phase\n",
      "onsite_heat production, light fuel oil, at boiler 100kW, non-modulating 1.0\n",
      "Un nouvel échange vers 'onsite_heat production, light fuel oil, at boiler 100kW, non-modulating' a été ajouté au processus 'onsite_heat, baseline, use phase' avec un amount de 1.0.\n",
      "onsite_heat, baseline, end of life phase\n",
      "onsite_chimney production 4.1825000000000003e-07\n",
      "Un nouvel échange vers 'onsite_chimney production' a été ajouté au processus 'onsite_heat, baseline, end of life phase' avec un amount de 4.1825000000000003e-07.\n",
      "onsite_oil boiler production, 100kW 9.798999999999999e-08\n",
      "Un nouvel échange vers 'onsite_oil boiler production, 100kW' a été ajouté au processus 'onsite_heat, baseline, end of life phase' avec un amount de 9.798999999999999e-08.\n",
      "onsite_oil storage production, 3000l 1.8124166666666666e-07\n",
      "Un nouvel échange vers 'onsite_oil storage production, 3000l' a été ajouté au processus 'onsite_heat, baseline, end of life phase' avec un amount de 1.8124166666666666e-07.\n",
      "onsite_heat, alternative, production phase\n",
      "onsite_furnace production, pellets, with silo, 300kW 3.983333333333333e-08\n",
      "Un nouvel échange vers 'onsite_furnace production, pellets, with silo, 300kW' a été ajouté au processus 'onsite_heat, alternative, production phase' avec un amount de 3.983333333333333e-08.\n",
      "onsite_hot water tank production, 600l 8.604e-07\n",
      "Un nouvel échange vers 'onsite_hot water tank production, 600l' a été ajouté au processus 'onsite_heat, alternative, production phase' avec un amount de 8.604e-07.\n",
      "onsite_heat, alternative, distribution phase\n",
      "onsite_heat, alternative, use phase\n",
      "onsite_heat production, wood pellet, at furnace 300kW 1.0\n",
      "Un nouvel échange vers 'onsite_heat production, wood pellet, at furnace 300kW' a été ajouté au processus 'onsite_heat, alternative, use phase' avec un amount de 1.0.\n",
      "onsite_heat, alternative, end of life phase\n",
      "onsite_furnace production, pellets, with silo, 300kW 3.983333333333333e-08\n",
      "Un nouvel échange vers 'onsite_furnace production, pellets, with silo, 300kW' a été ajouté au processus 'onsite_heat, alternative, end of life phase' avec un amount de 3.983333333333333e-08.\n",
      "onsite_hot water tank production, 600l 8.604e-07\n",
      "Un nouvel échange vers 'onsite_hot water tank production, 600l' a été ajouté au processus 'onsite_heat, alternative, end of life phase' avec un amount de 8.604e-07.\n"
     ]
    }
   ],
   "source": [
    "# Ajouter les exchanges de ma bdd aux activités des systèmes modélisés\n",
    "\n",
    "import pandas as pd\n",
    "\n",
    "# Lire le fichier Excel\n",
    "df = pd.read_excel(\"activities_names.xlsx\")\n",
    "\n",
    "# Liste des préfixes\n",
    "prefixes = ['offsite_', 'onsite_']\n",
    "\n",
    "# Fonction pour ajouter le bon préfixe\n",
    "def add_prefix(activity_name):\n",
    "    for prefix in prefixes:\n",
    "        if prefix + activity_name in activity_names_with_prefixes:\n",
    "            return prefix + activity_name\n",
    "    return activity_name\n",
    "\n",
    "# Obtenir tous les noms d'activités avec les préfixes\n",
    "activity_names_with_prefixes = [activity['name'] for activity in elec_bl]\n",
    "\n",
    "# Parcourir chaque colonne du DataFrame (excepté la première)\n",
    "for prefix in prefixes:\n",
    "    for parent in df.columns[1:]:\n",
    "        parent_name_with_prefix = (prefix+parent)\n",
    "        print(parent_name_with_prefix)\n",
    "    \n",
    "        # Parcourir chaque ligne pour récupérer les fils et leurs quantités\n",
    "        for index, row in df.iterrows():\n",
    "            fils_name = row['Activity Name']\n",
    "            quantity_fils = row[parent]\n",
    "        \n",
    "            # Si une quantité est inscrite, ajouter l'exchange\n",
    "            if not pd.isna(quantity_fils):\n",
    "                fils_name_with_prefix = (prefix+fils_name)\n",
    "                print(fils_name_with_prefix, quantity_fils)\n",
    "\n",
    "                # Trouver les activités associées dans la base de données\n",
    "                parent_activity = [act for act in elec_bl if act['name'] == parent_name_with_prefix][0]\n",
    "                fils_activity = [act for act in elec_bl if act['name'] == fils_name_with_prefix][0]\n",
    "            \n",
    "                # Ajouter l'exchange dans l'activité parent\n",
    "                if parent_activity and fils_activity:\n",
    "                    add_new_exchange(parent_activity, fils_activity, quantity=quantity_fils)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 104,
   "id": "96ddb8de-4fa3-4ea3-a351-2bea903deb59",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Activity: offsite_electricity, alternative, use phase\n",
      "  - offsite_electricity production, photovoltaic, 3kWp facade installation, multi-Si, panel, mounted_use\n",
      "  - offsite_electricity, baseline_use\n",
      " \n",
      "Activity: onsite_electricity, alternative, use phase\n",
      "  - onsite_electricity production, photovoltaic, 3kWp facade installation, multi-Si, panel, mounted_use\n",
      "    - market for tap water\n",
      "    - Water\n",
      "    - Energy, solar, converted\n",
      "  - onsite_electricity, baseline_use\n",
      " \n",
      "Activity: offsite_electricity, baseline, use phase\n",
      "  - offsite_diesel, burned in diesel-electric generating set, 10MW_use\n",
      "    - market group for diesel\n",
      "    - market for lubricating oil\n",
      "    - offsite_market for municipal solid waste\n",
      "  - offsite_electricity production, oil_use\n",
      "    - market for water, completely softened\n",
      "    - market for water, decarbonised\n",
      "    - offsite_market for municipal solid waste\n",
      "    - offsite_market for municipal solid waste\n",
      "    - offsite_market for municipal solid waste\n",
      "    - offsite_market for municipal solid waste\n",
      "    - offsite_market for municipal solid waste\n",
      "    - offsite_market for municipal solid waste\n",
      " \n",
      "Activity: onsite_electricity, baseline, use phase\n",
      "  - onsite_diesel, burned in diesel-electric generating set, 10MW_use\n",
      "    - Benzene\n",
      "    - Benzo(a)pyrene\n",
      "    - Cadmium II\n",
      "    - Carbon dioxide, fossil\n",
      "    - Carbon monoxide, fossil\n",
      "    - Chromium III\n",
      "    - Chromium VI\n",
      "    - Copper ion\n",
      "    - Dinitrogen monoxide\n",
      "    - Mercury II\n",
      "    - Methane, fossil\n",
      "    - NMVOC, non-methane volatile organic compounds\n",
      "    - Nickel II\n",
      "    - Nitrogen oxides\n",
      "    - Particulate Matter, < 2.5 um\n",
      "    - Selenium IV\n",
      "    - Sulfur dioxide\n",
      "    - Zinc II\n",
      "    - onsite_market for municipal solid waste\n",
      "  - onsite_electricity production, oil_use\n",
      "    - Acetaldehyde\n",
      "    - Acetic acid\n",
      "    - Acetone\n",
      "    - Ammonia\n",
      "    - Arsenic ion\n",
      "    - Benzene\n",
      "    - Benzo(a)pyrene\n",
      "    - Beryllium II\n",
      "    - Cadmium II\n",
      "    - Calcium II\n",
      "    - Carbon dioxide, fossil\n",
      "    - Carbon dioxide, fossil\n",
      "    - Carbon monoxide, fossil\n",
      "    - Chromium III\n",
      "    - Chromium VI\n",
      "    - Cobalt II\n",
      "    - Copper ion\n",
      "    - Dinitrogen monoxide\n",
      "    - Dioxins, measured as 2,3,7,8-tetrachlorodibenzo-p-dioxin\n",
      "    - Ethanol\n",
      "    - Formaldehyde\n",
      "    - Hydrocarbons, aliphatic, alkanes, unspecified\n",
      "    - Hydrocarbons, aliphatic, unsaturated\n",
      "    - Hydrocarbons, aromatic\n",
      "    - Hydrochloric acid\n",
      "    - Hydrogen fluoride\n",
      "    - Iron ion\n",
      "    - Lead II\n",
      "    - Manganese II\n",
      "    - Mercury II\n",
      "    - Methane, fossil\n",
      "    - Methanol\n",
      "    - Molybdenum VI\n",
      "    - Nickel II\n",
      "    - Nitrogen oxides\n",
      "    - PAH, polycyclic aromatic hydrocarbons\n",
      "    - Particulate Matter, < 2.5 um\n",
      "    - Particulate Matter, > 10 um\n",
      "    - Particulate Matter, > 2.5 um and < 10um\n",
      "    - Propane\n",
      "    - Selenium IV\n",
      "    - Sodium I\n",
      "    - Sulfur dioxide\n",
      "    - Vanadium V\n",
      "    - Water\n",
      "    - Zinc II\n",
      "    - AOX, Adsorbable Organic Halides\n",
      "    - Arsenic ion\n",
      "    - BOD5, Biological Oxygen Demand\n",
      "    - COD, Chemical Oxygen Demand\n",
      "    - Cadmium II\n",
      "    - Chloride\n",
      "    - Chromium III\n",
      "    - Cobalt II\n",
      "    - Copper ion\n",
      "    - DOC, Dissolved Organic Carbon\n",
      "    - Fluoride\n",
      "    - Hydrocarbons, unspecified\n",
      "    - Hypochlorite\n",
      "    - Hypochlorite\n",
      "    - Iron ion\n",
      "    - Lead II\n",
      "    - Manganese II\n",
      "    - Mercury II\n",
      "    - Nickel II\n",
      "    - Nitrogen\n",
      "    - Oils, unspecified\n",
      "    - Phosphorus\n",
      "    - Sulfate\n",
      "    - Sulfide\n",
      "    - Sulfite\n",
      "    - Suspended solids, unspecified\n",
      "    - TOC, Total Organic Carbon\n",
      "    - Thallium I\n",
      "    - Tin ion\n",
      "    - Vanadium V\n",
      "    - Water\n",
      "    - Zinc II\n",
      "    - Water, cooling, unspecified natural origin\n",
      "    - onsite_market for municipal solid waste\n",
      "    - onsite_market for municipal solid waste\n",
      "    - onsite_market for municipal solid waste\n",
      "    - onsite_market for municipal solid waste\n",
      "    - onsite_market for municipal solid waste\n",
      "    - onsite_market for municipal solid waste\n",
      " \n",
      "Activity: offsite_heat, alternative, use phase\n",
      "  - offsite_heat production, wood pellet, at furnace 300kW_use\n",
      "    - market for wood pellet, measured as dry mass\n",
      "    - offsite_market for municipal solid waste\n",
      " \n",
      "Activity: onsite_heat, alternative, use phase\n",
      "  - onsite_heat production, wood pellet, at furnace 300kW_use\n",
      "    - Acetaldehyde\n",
      "    - Ammonia\n",
      "    - Arsenic ion\n",
      "    - Benzene\n",
      "    - Benzo(a)pyrene\n",
      "    - Bromine\n",
      "    - Cadmium II\n",
      "    - Calcium II\n",
      "    - Carbon dioxide, non-fossil\n",
      "    - Carbon monoxide, non-fossil\n",
      "    - Chlorine\n",
      "    - Chromium III\n",
      "    - Chromium VI\n",
      "    - Copper ion\n",
      "    - Dinitrogen monoxide\n",
      "    - Dioxins, measured as 2,3,7,8-tetrachlorodibenzo-p-dioxin\n",
      "    - Ethyl benzene\n",
      "    - Fluorine\n",
      "    - Formaldehyde\n",
      "    - Hexachlorobenzene\n",
      "    - Hydrocarbons, aliphatic, alkanes, unspecified\n",
      "    - Hydrocarbons, aliphatic, unsaturated\n",
      "    - Lead II\n",
      "    - Magnesium\n",
      "    - Manganese II\n",
      "    - Mercury II\n",
      "    - Methane, non-fossil\n",
      "    - NMVOC, non-methane volatile organic compounds\n",
      "    - Nickel II\n",
      "    - Nitrogen oxides\n",
      "    - PAH, polycyclic aromatic hydrocarbons\n",
      "    - Particulate Matter, < 2.5 um\n",
      "    - Particulate Matter, > 2.5 um and < 10um\n",
      "    - Pentachlorophenol\n",
      "    - Phosphorus\n",
      "    - Potassium I\n",
      "    - Sodium I\n",
      "    - Sulfur dioxide\n",
      "    - Toluene\n",
      "    - Water\n",
      "    - Zinc II\n",
      "    - m-Xylene\n",
      "    - onsite_market for municipal solid waste\n",
      " \n",
      "Activity: offsite_heat, baseline, use phase\n",
      "  - offsite_heat production, light fuel oil, at boiler 100kW, non-modulating_use_use\n",
      "    - market for light fuel oil\n",
      " \n",
      "Activity: onsite_heat, baseline, use phase\n",
      "  - onsite_heat production, light fuel oil, at boiler 100kW, non-modulating_use\n",
      "    - Acetaldehyde\n",
      "    - Acetone\n",
      "    - Acetylene\n",
      "    - Acrolein\n",
      "    - Benzaldehyde\n",
      "    - Benzene\n",
      "    - Butane\n",
      "    - Carbon dioxide, fossil\n",
      "    - Carbon monoxide, fossil\n",
      "    - Copper ion\n",
      "    - Dinitrogen monoxide\n",
      "    - Dioxins, measured as 2,3,7,8-tetrachlorodibenzo-p-dioxin\n",
      "    - Ethane\n",
      "    - Ethylene\n",
      "    - Formaldehyde\n",
      "    - Hydrocarbons, aliphatic, alkanes, unspecified\n",
      "    - Hydrocarbons, aliphatic, unsaturated\n",
      "    - Hydrocarbons, aromatic\n",
      "    - Hydrochloric acid\n",
      "    - Hydrogen fluoride\n",
      "    - Mercury II\n",
      "    - Methane, fossil\n",
      "    - Nitrogen oxides\n",
      "    - PAH, polycyclic aromatic hydrocarbons\n",
      "    - Particulate Matter, < 2.5 um\n",
      "    - Pentane\n",
      "    - Propanal\n",
      "    - Propane\n",
      "    - Propylene\n",
      "    - Sulfur dioxide\n",
      "    - Toluene\n",
      "    - Zinc II\n",
      " \n"
     ]
    }
   ],
   "source": [
    "# Afficher les scénarios triés et les exchanges associés\n",
    "\n",
    "phase_activities = [act for act in elec_bl if 'use phase' in act['name']]\n",
    "phase_order = ['production phase', 'distribution phase', 'use phase', 'end of life phase']\n",
    "\n",
    "def get_scenario_phase_location(activity):\n",
    "\n",
    "    parts_undr = activity['name'].split('_')\n",
    "    location = parts_undr[0]\n",
    "    parts_coma = parts_undr[1].split(', ')\n",
    "    scenario = parts_coma[0] + parts_coma[1]\n",
    "    phase = parts_coma[2]\n",
    "    return scenario, location, phase\n",
    "\n",
    "# Trier la liste des activités\n",
    "sorted_activities = sorted(\n",
    "    phase_activities,\n",
    "    key=lambda act: (\n",
    "        get_scenario_phase_location(act)[0],  # Trier par scénario\n",
    "        get_scenario_phase_location(act)[1],  # Trier par localisation\n",
    "        phase_order.index(get_scenario_phase_location(act)[2])  # Trier par phase selon l'ordre défini\n",
    "    )\n",
    ")\n",
    "\n",
    "# Afficher les activités triées\n",
    "for activity in sorted_activities:\n",
    "    print(f\"Activity: {activity['name']}\")\n",
    "    for exc in activity.exchanges():\n",
    "        print(f\"  - {exc.input['name']}\")\n",
    "        sub_exc_act = [act for act in elec_bl if exc.input['name'] in act['name']][0]\n",
    "        for sub_exc in sub_exc_act.exchanges():\n",
    "            print(f\"    - {sub_exc.input['name']}\")\n",
    "    print(' ')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 102,
   "id": "f920e181-8355-4f15-b61b-ec98aabca804",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Dictionnaire contenant les critères spécifiques pour chaque phase\n",
    "phase_criteria = {\n",
    "    'prod': {\n",
    "        'include': [],  # Critères à inclure\n",
    "        'exclude': ['diesel, burned in building machine', 'excavation']  # Critères à exclure\n",
    "    },\n",
    "    'dist': {\n",
    "        'include': ['diesel, burned in building machine', 'excavation'],  # Aucun critère à inclure\n",
    "        'exclude': []  # Critère à exclure\n",
    "    },\n",
    "    'use': {\n",
    "        'include': [],  # Critère à inclure\n",
    "        'exclude': ['market for photovoltaic facade installation, 3kWp, multi-Si, panel, mounted, at building', \n",
    "                    'market for diesel-electric generating set, 10MW', 'market for ammonia, anhydrous, liquid',\n",
    "                    'market for heavy fuel oil','market for limestone, crushed, washed',\n",
    "                    'market for oil power plant, 500MW','market for chimney',\n",
    "                    'market for oil boiler, 100kW','market for oil storage, 3000l', \n",
    "                    'market for furnace, pellets, with silo, 300kW']  # Aucun critère à exclure\n",
    "    },\n",
    "    'eol': {\n",
    "        'include': ['municipal solid waste','waste plastic, mixture', 'waste polystyrene', 'waste polyvinylchloride', 'waste polyethylene'],  # Aucun critère à inclure\n",
    "        'exclude': []  # Aucun critère à exclure\n",
    "    }\n",
    "}\n",
    "\n",
    "scenario_activities = [act for act in elec_bl if 'phase' in act['name']]\n",
    "\n",
    "# Étape 1: Itérer sur les activités scénario-localisation-phase\n",
    "for activity in scenario_activities:\n",
    "    # Déterminer la phase pour chaque activité\n",
    "    if 'production phase' in activity['name']:\n",
    "        phase = 'prod'\n",
    "    elif 'distribution phase' in activity['name']:\n",
    "        phase = 'dist'\n",
    "    elif 'use phase' in activity['name']:\n",
    "        phase = 'use'\n",
    "    elif 'end of life phase' in activity['name']:\n",
    "        phase = 'eol'\n",
    "    else:\n",
    "        continue\n",
    "\n",
    "    # Étape 2: Itérer sur les exchanges de chaque activité\n",
    "    for exchange in activity.exchanges():\n",
    "        sub_activity = exchange.input\n",
    "        \n",
    "        # Créer un nouveau nom avec un suffixe dépendant de la phase\n",
    "        new_activity_name = sub_activity['name'] + f\"_{phase}\"\n",
    "        new_activity = elec_bl.new_activity(code=generate_unique_id('ph'), name=new_activity_name)\n",
    "        new_activity.save()\n",
    "\n",
    "        # Étape 3: Ajouter des exchanges aux nouvelles activités selon les critères spécifiques à la phase\n",
    "        for sub_exc in sub_activity.exchanges():\n",
    "            # Vérifier les critères positifs (include) et négatifs (exclude)\n",
    "            include_check = not phase_criteria[phase]['include'] or any(criterion in sub_exc.input['name'] for criterion in phase_criteria[phase]['include'])\n",
    "            exclude_check = not phase_criteria[phase]['exclude'] or not any(criterion in sub_exc.input['name'] for criterion in phase_criteria[phase]['exclude'])\n",
    "\n",
    "            if include_check and exclude_check:\n",
    "                new_exchange = new_activity.new_exchange(\n",
    "                    amount=sub_exc['amount'],\n",
    "                    input=sub_exc.input,\n",
    "                    type=sub_exc['type'],\n",
    "                    unit=sub_exc['unit']\n",
    "                )\n",
    "                new_exchange.save()\n",
    "\n",
    "        # Étape 4: Remplacer la sous-activité par la nouvelle activité dans l'exchange parent\n",
    "        exchange.input = new_activity\n",
    "        exchange.save()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "3c5d64ea-c7f0-4284-9a8c-af2e8069b65a",
   "metadata": {
    "collapsed": true,
    "jupyter": {
     "outputs_hidden": true
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Activity: waste_electricity production, oil\n",
      "  - Replaced 'market for municipal solid waste' with 'waste_market for municipal solid waste'\n",
      "Activity: offsite_excavation, hydraulic digger\n",
      "  - Replaced 'market for diesel' with 'offsite_market for diesel'\n",
      "  - Replaced 'market for lubricating oil' with 'offsite_market for lubricating oil'\n",
      "Activity: offsite_diesel, burned in diesel-electric generating set, 10MW\n",
      "  - Replaced 'market for lubricating oil' with 'offsite_market for lubricating oil'\n",
      "Activity: onsite_diesel, burned in building machine\n",
      "  - Replaced 'market for lubricating oil' with 'onsite_market for lubricating oil'\n",
      "Activity: waste_inverter production, 2.5kW\n",
      "  - Replaced 'market for waste polyethylene' with 'waste_market for waste polyethylene'\n",
      "  - Replaced 'market for waste polystyrene' with 'waste_market for waste polystyrene'\n",
      "Activity: onsite_diesel, burned in diesel-electric generating set, 10MW\n",
      "  - Replaced 'market for lubricating oil' with 'onsite_market for lubricating oil'\n",
      "Activity: offsite_oil power plant construction, 500MW\n",
      "  - Replaced 'market for lubricating oil' with 'offsite_market for lubricating oil'\n",
      "Activity: onsite_excavation, hydraulic digger\n",
      "  - Replaced 'market for diesel' with 'onsite_market for diesel'\n",
      "  - Replaced 'market for lubricating oil' with 'onsite_market for lubricating oil'\n",
      "Activity: offsite_diesel, burned in building machine\n",
      "  - Replaced 'market for lubricating oil' with 'offsite_market for lubricating oil'\n",
      "Activity: onsite_furnace production, pellets, with silo, 300kW\n",
      "  - Replaced 'market for lubricating oil' with 'onsite_market for lubricating oil'\n",
      "Activity: offsite_furnace production, pellets, with silo, 300kW\n",
      "  - Replaced 'market for lubricating oil' with 'offsite_market for lubricating oil'\n",
      "Activity: waste_oil storage production, 3000l\n",
      "  - Replaced 'market for waste plastic, mixture' with 'waste_market for waste plastic, mixture'\n",
      "Activity: offsite_excavation, skid-steer loader\n",
      "  - Replaced 'market for diesel' with 'offsite_market for diesel'\n",
      "  - Replaced 'market for lubricating oil' with 'offsite_market for lubricating oil'\n",
      "Activity: waste_photovoltaics, electric installation for 3kWp module, at building\n",
      "  - Replaced 'market for waste polyvinylchloride' with 'waste_market for waste polyvinylchloride'\n",
      "Activity: offsite_maintenance, lorry 16 metric ton\n",
      "  - Replaced 'market for lubricating oil' with 'offsite_market for lubricating oil'\n",
      "Activity: onsite_photovoltaic panel production, multi-Si wafer\n",
      "  - Replaced 'market for lubricating oil' with 'onsite_market for lubricating oil'\n",
      "Activity: waste_hot water tank production, 600l\n",
      "  - Replaced 'market for waste plastic, mixture' with 'waste_market for waste plastic, mixture'\n",
      "Activity: offsite_photovoltaic panel production, multi-Si wafer\n",
      "  - Replaced 'market for lubricating oil' with 'offsite_market for lubricating oil'\n",
      "Activity: waste_photovoltaic panel production, multi-Si wafer\n",
      "  - Replaced 'market for municipal solid waste' with 'waste_market for municipal solid waste'\n",
      "  - Replaced 'market for waste plastic, mixture' with 'waste_market for waste plastic, mixture'\n",
      "Activity: offsite_heat production, wood pellet, at furnace 300kW\n",
      "  - Replaced 'market for wood pellet, measured as dry mass' with 'offsite_market for wood pellet, measured as dry mass'\n",
      "Activity: waste_oil boiler production, 100kW\n",
      "  - Replaced 'market for waste plastic, mixture' with 'waste_market for waste plastic, mixture'\n",
      "Activity: onsite_excavation, skid-steer loader\n",
      "  - Replaced 'market for diesel' with 'onsite_market for diesel'\n",
      "  - Replaced 'market for lubricating oil' with 'onsite_market for lubricating oil'\n",
      "Activity: waste_heat production, wood pellet, at furnace 300kW\n",
      "  - Replaced 'market for wood ash mixture, pure' with 'waste_market for wood ash mixture, pure'\n",
      "Activity: onsite_oil power plant construction, 500MW\n",
      "  - Replaced 'market for lubricating oil' with 'onsite_market for lubricating oil'\n",
      "Activity: onsite_maintenance, lorry 16 metric ton\n",
      "  - Replaced 'market for lubricating oil' with 'onsite_market for lubricating oil'\n",
      "Activity: waste_furnace production, pellets, with silo, 300kW\n",
      "  - Replaced 'market for waste polyethylene' with 'waste_market for waste polyethylene'\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "120"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Remplacer les exchanges par ceux présents dans ma bdd\n",
    "\n",
    "# Dictionnaire pour stocker les rapports de remplacement\n",
    "replacement_report = {}\n",
    "\n",
    "# Itérer à travers toutes les activités de la base de données\n",
    "for activity in elec_bl:\n",
    "    # Extraire la particule de l'activité actuelle\n",
    "    activity_prefix = activity['name'].split('_')[0] + '_'\n",
    "    \n",
    "    # Créer une liste pour stocker les remplacements de cette activité\n",
    "    replacement_report[activity['name']] = []\n",
    "\n",
    "    # Itérer à travers les échanges de l'activité actuelle\n",
    "    for exc in activity.exchanges():\n",
    "        # Extraire le nom de base de l'échange cible (sans particule)\n",
    "        base_name = exc.input['name']\n",
    "\n",
    "        # Construire le nouveau nom de l'activité cible avec la particule de l'activité actuelle\n",
    "        new_activity_name = activity_prefix + base_name\n",
    "\n",
    "        # Chercher l'activité correspondante dans la base de données\n",
    "        try:\n",
    "            new_input = [act for act in elec_bl if act['name'] == new_activity_name][0]\n",
    "            old_input_name = exc.input['name']\n",
    "            exc['input'] = new_input.key  # Met à jour la référence de l'échange\n",
    "            exc.save()  # Enregistre l'échange mis à jour\n",
    "            \n",
    "            # Ajouter le remplacement au rapport\n",
    "            replacement_report[activity['name']].append({\n",
    "                'old_exchange': old_input_name,\n",
    "                'new_activity': new_activity_name\n",
    "            })\n",
    "        except :\n",
    "            pass\n",
    "    activity.save()\n",
    "    \n",
    "# Afficher le rapport de remplacement\n",
    "for activity_name, replacements in replacement_report.items():\n",
    "    if replacements:  # Afficher uniquement si des remplacements ont été effectués\n",
    "        print(f\"Activity: {activity_name}\")\n",
    "        for replacement in replacements:\n",
    "            print(f\"  - Replaced '{replacement['old_exchange']}' with '{replacement['new_activity']}'\")\n",
    "len(elec_bl)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "bb3028aa-0aa6-4925-82c3-405459dbe05b",
   "metadata": {
    "collapsed": true,
    "jupyter": {
     "outputs_hidden": true
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Activity: offsite_electricity, baseline, distribution phase\n",
      "  - offsite_distribution network construction, electricity, low voltage\n",
      "  - offsite_oil power plant construction, 500MW\n",
      "Activity: offsite_electricity, alternative, production phase\n",
      "  - offsite_distribution network construction, electricity, low voltage\n",
      "  - offsite_oil power plant construction, 500MW\n",
      "  - offsite_photovoltaic facade installation, 3kWp, multi-Si, panel, mounted, at building\n",
      "Activity: offsite_heat, alternative, end of life phase\n",
      "  - offsite_furnace production, pellets, with silo, 300kW\n",
      "  - offsite_hot water tank production, 600l\n",
      "Activity: offsite_electricity, baseline, use phase\n",
      "  - offsite_diesel, burned in diesel-electric generating set, 10MW\n",
      "  - offsite_electricity production, oil\n",
      "Activity: onsite_heat, alternative, use phase\n",
      "  - onsite_heat production, light fuel oil, at boiler 100kW, non-modulating\n",
      "Activity: onsite_heat, baseline, production phase\n",
      "  - onsite_chimney production\n",
      "  - onsite_oil boiler production, 100kW\n",
      "  - onsite_oil storage production, 3000l\n",
      "Activity: onsite_heat, baseline, use phase\n",
      "  - onsite_heat production, light fuel oil, at boiler 100kW, non-modulating\n",
      "Activity: onsite_electricity, baseline, use phase\n",
      "  - onsite_diesel, burned in diesel-electric generating set, 10MW\n",
      "  - onsite_electricity production, oil\n",
      "Activity: offsite_electricity, baseline, production phase\n",
      "  - offsite_distribution network construction, electricity, low voltage\n",
      "  - offsite_oil power plant construction, 500MW\n",
      "Activity: offsite_electricity, alternative, distribution phase\n",
      "  - offsite_distribution network construction, electricity, low voltage\n",
      "  - offsite_oil power plant construction, 500MW\n",
      "  - offsite_photovoltaic facade installation, 3kWp, multi-Si, panel, mounted, at building\n",
      "Activity: offsite_heat, alternative, production phase\n",
      "  - offsite_furnace production, pellets, with silo, 300kW\n",
      "  - offsite_hot water tank production, 600l\n",
      "Activity: onsite_electricity, alternative, end of life phase\n",
      "  - onsite_inverter production, 2.5kW\n",
      "  - onsite_photovoltaic mounting system production, for facade installation\n",
      "  - onsite_photovoltaic panel production, multi-Si wafer\n",
      "  - onsite_photovoltaics, electric installation for 3kWp module, at building\n",
      "  - onsite_electricity, baseline, end of life phase\n",
      "Activity: offsite_heat, baseline, distribution phase\n",
      "Activity: onsite_heat, alternative, production phase\n",
      "  - onsite_furnace production, pellets, with silo, 300kW\n",
      "  - onsite_hot water tank production, 600l\n",
      "Activity: offsite_heat, baseline, end of life phase\n",
      "  - offsite_chimney production\n",
      "  - offsite_oil boiler production, 100kW\n",
      "  - offsite_oil storage production, 3000l\n",
      "Activity: offsite_heat, alternative, distribution phase\n",
      "Activity: offsite_heat, baseline, use phase\n",
      "  - offsite_heat production, light fuel oil, at boiler 100kW, non-modulating\n",
      "Activity: onsite_electricity, baseline, end of life phase\n",
      "  - onsite_distribution network construction, electricity, low voltage\n",
      "  - onsite_oil power plant construction, 500MW\n",
      "Activity: offsite_heat, alternative, use phase\n",
      "  - offsite_heat production, light fuel oil, at boiler 100kW, non-modulating\n",
      "Activity: onsite_heat, baseline, end of life phase\n",
      "  - onsite_chimney production\n",
      "  - onsite_oil boiler production, 100kW\n",
      "  - onsite_oil storage production, 3000l\n",
      "Activity: onsite_electricity, baseline, production phase\n",
      "  - onsite_distribution network construction, electricity, low voltage\n",
      "  - onsite_oil power plant construction, 500MW\n",
      "Activity: onsite_electricity, alternative, use phase\n",
      "  - onsite_electricity production, photovoltaic, 3kWp facade installation, multi-Si, panel, mounted\n",
      "  - onsite_electricity, baseline\n",
      "Activity: onsite_heat, alternative, distribution phase\n",
      "Activity: offsite_electricity, baseline, end of life phase\n",
      "  - offsite_distribution network construction, electricity, low voltage\n",
      "  - offsite_oil power plant construction, 500MW\n",
      "Activity: offsite_heat, baseline, production phase\n",
      "  - offsite_chimney production\n",
      "  - offsite_oil boiler production, 100kW\n",
      "  - offsite_oil storage production, 3000l\n",
      "Activity: onsite_electricity, alternative, distribution phase\n",
      "  - onsite_distribution network construction, electricity, low voltage\n",
      "  - onsite_oil power plant construction, 500MW\n",
      "  - onsite_photovoltaic facade installation, 3kWp, multi-Si, panel, mounted, at building\n",
      "Activity: offsite_electricity, alternative, use phase\n",
      "  - offsite_electricity production, photovoltaic, 3kWp facade installation, multi-Si, panel, mounted\n",
      "  - offsite_electricity, baseline\n",
      "Activity: onsite_heat, alternative, end of life phase\n",
      "  - onsite_furnace production, pellets, with silo, 300kW\n",
      "  - onsite_hot water tank production, 600l\n",
      "Activity: offsite_electricity, alternative, end of life phase\n",
      "  - offsite_inverter production, 2.5kW\n",
      "  - offsite_photovoltaic mounting system production, for facade installation\n",
      "  - offsite_photovoltaic panel production, multi-Si wafer\n",
      "  - offsite_photovoltaics, electric installation for 3kWp module, at building\n",
      "  - offsite_electricity, baseline, end of life phase\n",
      "Activity: onsite_heat, baseline, distribution phase\n",
      "Activity: onsite_electricity, alternative, production phase\n",
      "  - onsite_distribution network construction, electricity, low voltage\n",
      "  - onsite_oil power plant construction, 500MW\n",
      "  - onsite_photovoltaic facade installation, 3kWp, multi-Si, panel, mounted, at building\n",
      "Activity: onsite_electricity, baseline, distribution phase\n",
      "  - onsite_distribution network construction, electricity, low voltage\n",
      "  - onsite_oil power plant construction, 500MW\n"
     ]
    }
   ],
   "source": [
    "# Trouver une liste d'activités et lister les échanges de chaque activité\n",
    "\n",
    "# Step 1: Find all activities with 'phase' in their name\n",
    "phase_activities = [act for act in elec_bl if 'phase' in act['name']]\n",
    "\n",
    "for activity in phase_activities:\n",
    "    print(f\"Activity: {activity['name']}\")\n",
    "    for exc in activity.exchanges():\n",
    "        print(f\"  - {exc.input['name']}\")           \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 106,
   "id": "d4f89c3a-e9ec-4ee9-be3f-566c4a3aa58e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'market for municipal solid waste' (kilogram, RoW, None)"
      ]
     },
     "execution_count": 106,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "test = [\n",
    "    activity for activity in eidb\n",
    "    if 'market for municipal solid waste' in activity['name']    \n",
    "    and 'RoW' in activity['location']  \n",
    "][0]\n",
    "test"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 123,
   "id": "0dde64e5-c9d3-4694-abe1-4813289fe541",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "'treatment of municipal solid waste, unsanitary landfill, dry infiltration class (100mm)' (kilogram, GLO, None) -0.0655322348590512 'market for municipal solid waste' (kilogram, RoW, None)\n",
      "'treatment of municipal solid waste, unsanitary landfill, wet infiltration class (500mm)' (kilogram, GLO, None) -0.238658368530976 'market for municipal solid waste' (kilogram, RoW, None)\n",
      "'treatment of municipal solid waste, open dump, wet infiltration class (500mm)' (kilogram, GLO, None) -0.207390654443263 'market for municipal solid waste' (kilogram, RoW, None)\n",
      "'treatment of municipal solid waste, open dump, very wet infiltration class (1000mm)' (kilogram, GLO, None) -0.0319643984297913 'market for municipal solid waste' (kilogram, RoW, None)\n",
      "'treatment of municipal solid waste, unsanitary landfill, hyperarid infiltration class (-250mm)' (kilogram, GLO, None) -0.0275828515230707 'market for municipal solid waste' (kilogram, RoW, None)\n",
      "'treatment of municipal solid waste, unsanitary landfill, very wet infiltration class (1000mm)' (kilogram, GLO, None) -0.0509696662136194 'market for municipal solid waste' (kilogram, RoW, None)\n",
      "'treatment of municipal solid waste, unsanitary landfill, moist infiltration class (300mm)' (kilogram, GLO, None) -0.0723864517249698 'market for municipal solid waste' (kilogram, RoW, None)\n",
      "'treatment of municipal solid waste, open dump, moist infiltration class (300mm)' (kilogram, GLO, None) -0.0357842131601113 'market for municipal solid waste' (kilogram, RoW, None)\n",
      "'treatment of municipal solid waste, municipal incineration' (kilogram, RoW, None) -0.0633545529885166 'market for municipal solid waste' (kilogram, RoW, None)\n",
      "'treatment of municipal solid waste, open dump, hyperarid infiltration class (-250mm)' (kilogram, GLO, None) -0.0196344977267085 'market for municipal solid waste' (kilogram, RoW, None)\n",
      "'treatment of municipal solid waste, open burning' (kilogram, GLO, None) -0.143757842420425 'market for municipal solid waste' (kilogram, RoW, None)\n",
      "'treatment of municipal solid waste, open dump, dry infiltration class (100mm)' (kilogram, GLO, None) -0.0429842679794977 'market for municipal solid waste' (kilogram, RoW, None)\n",
      "'market for transport, freight, lorry, unspecified' (ton kilometer, ZA, None) 0.0013796252463669672 'market for municipal solid waste' (kilogram, RoW, None)\n",
      "'market for transport, freight, lorry, unspecified' (ton kilometer, RoW, None) 0.06680843137801773 'market for municipal solid waste' (kilogram, RoW, None)\n",
      "'market for transport, freight, lorry, unspecified' (ton kilometer, BR, None) 0.008811943375615302 'market for municipal solid waste' (kilogram, RoW, None)\n"
     ]
    }
   ],
   "source": [
    "# Checker les échanges dans une activité\n",
    "for exc in test.technosphere():\n",
    "    print(exc.input, exc.amount, exc.output)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "8b46f8e6-0268-408e-b95a-3ecccc198854",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Supprimer toutes les activités répondant à un critère de la base de données\n",
    "for activity in elec_bl:\n",
    "    if ', onsite' in activity['name'] or ', offsite' in activity['name']:\n",
    "#        activity.delete()\n",
    "    else:\n",
    "        pass"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 80,
   "id": "a7fc66c7-5995-444f-aa1f-f170e07bb123",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Exchange: waste_market for municipal solid waste, Found in activities: waste_excavation, hydraulic digger, waste_furnace production, pellets, with silo, 300kW, waste_furnace production, pellets, with silo, 300kW, waste_furnace production, pellets, with silo, 300kW, waste_furnace production, pellets, with silo, 300kW, waste_furnace production, pellets, with silo, 300kW, waste_furnace production, pellets, with silo, 300kW, waste_furnace production, pellets, with silo, 300kW, waste_furnace production, pellets, with silo, 300kW, waste_furnace production, pellets, with silo, 300kW, waste_excavation, skid-steer loader, waste_transport, freight, lorry >32 metric ton, EURO3, waste_transport, freight, lorry >32 metric ton, EURO3, waste_transport, freight, lorry >32 metric ton, EURO3, waste_oil storage production, 3000l, waste_oil storage production, 3000l, waste_oil storage production, 3000l, waste_road construction, waste_road construction, waste_photovoltaic mounting system production, for facade installation, waste_photovoltaic mounting system production, for facade installation, waste_photovoltaic mounting system production, for facade installation, waste_photovoltaic mounting system production, for facade installation, waste_market for diesel, waste_market for diesel, waste_treatment of waste mineral wool, collection for final disposal, waste_oil power plant construction, 500MW, waste_oil power plant construction, 500MW, waste_oil power plant construction, 500MW, waste_chimney production, waste_chimney production, waste_hot water tank production, 600l, waste_hot water tank production, 600l, waste_hot water tank production, 600l, waste_hot water tank production, 600l, waste_heat production, wood pellet, at furnace 300kW, waste_diesel, burned in diesel-electric generating set, 10MW, waste_photovoltaic panel production, multi-Si wafer, waste_photovoltaic panel production, multi-Si wafer, waste_photovoltaic panel production, multi-Si wafer, waste_photovoltaic panel production, multi-Si wafer, waste_distribution network construction, electricity, low voltage, waste_distribution network construction, electricity, low voltage, waste_distribution network construction, electricity, low voltage, waste_distribution network construction, electricity, low voltage, waste_distribution network construction, electricity, low voltage, waste_distribution network construction, electricity, low voltage, waste_electricity production, oil, waste_electricity production, oil, waste_electricity production, oil, waste_electricity production, oil, waste_electricity production, oil, waste_electricity production, oil, waste_market for wood ash mixture, pure, waste_market for wood ash mixture, pure, waste_market for wood ash mixture, pure, waste_inverter production, 2.5kW, waste_inverter production, 2.5kW, waste_inverter production, 2.5kW, waste_oil boiler production, 100kW, waste_oil boiler production, 100kW, waste_oil boiler production, 100kW, waste_oil boiler production, 100kW, waste_oil boiler production, 100kW, waste_diesel, burned in building machine, waste_treatment of waste cement in concrete and mortar, collection for final disposal, waste_photovoltaics, electric installation for 3kWp module, at building, waste_photovoltaics, electric installation for 3kWp module, at building, waste_photovoltaics, electric installation for 3kWp module, at building, waste_photovoltaics, electric installation for 3kWp module, at building, waste_photovoltaics, electric installation for 3kWp module, at building, waste_treatment of waste cement in concrete and mortar, collection for final disposal, waste_treatment of waste mineral wool, collection for final disposal\n",
      "Exchange: waste_market for waste polyethylene, Found in activities: waste_furnace production, pellets, with silo, 300kW, waste_furnace production, pellets, with silo, 300kW, waste_photovoltaic mounting system production, for facade installation, waste_oil power plant construction, 500MW, waste_inverter production, 2.5kW, waste_photovoltaics, electric installation for 3kWp module, at building\n",
      "Exchange: treatment of waste polyvinylchloride, open dump, wet infiltration class (500mm), Found in activities: waste_market for waste polyvinylchloride\n",
      "Exchange: treatment of municipal solid waste, open dump, wet infiltration class (500mm), Found in activities: waste_market for municipal solid waste, waste_market for municipal solid waste\n",
      "Exchange: market for wastewater, average, Found in activities: waste_market for diesel, waste_hot water tank production, 600l, waste_photovoltaic panel production, multi-Si wafer, waste_electricity production, photovoltaic, 3kWp facade installation, multi-Si, panel, mounted\n",
      "Exchange: treatment of waste polystyrene, open dump, wet infiltration class (500mm), Found in activities: waste_market for waste polystyrene\n",
      "Exchange: treatment of waste plastic, mixture, open dump, wet infiltration class (500mm), Found in activities: waste_market for waste plastic, mixture\n",
      "Exchange: market for wastewater from pig iron production, Found in activities: waste_oil boiler production, 100kW\n",
      "Exchange: treatment of waste polyethylene, open dump, wet infiltration class (500mm), Found in activities: waste_market for waste polyethylene, waste_market for waste polyethylene\n"
     ]
    }
   ],
   "source": [
    "# Trouver une liste d'activités et lister les échanges de chaque activité\n",
    "\n",
    "# Step 1: Find all activities with 'waste_' in their name\n",
    "waste_activities = [act for act in elec_bl if 'waste_' in act['name']]\n",
    "\n",
    "# Step 2: Create a dictionary to map exchanges to the activities where they are found\n",
    "exchange_to_activities = {}\n",
    "\n",
    "for activity in waste_activities:\n",
    "    for exc in activity.exchanges():\n",
    "        exchange_name = exc.input['name']\n",
    "        if exchange_name not in exchange_to_activities:\n",
    "            # Initialize a list for the exchange if it's not already in the dictionary\n",
    "            exchange_to_activities[exchange_name] = []\n",
    "        # Add the activity name to the list for this exchange\n",
    "        exchange_to_activities[exchange_name].append(activity['name'])\n",
    "\n",
    "# Display the exchanges along with the list of activities in which they are found\n",
    "for exchange_name, activities in exchange_to_activities.items():\n",
    "    print(f\"Exchange: {exchange_name}, Found in activities: {', '.join(activities)}\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 80,
   "id": "ed464027-26ca-4ff4-aac2-b3e73d9cd9c1",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'offsite_transport, freight, lorry >32 metric ton, EURO3' (ton kilometer, GLO, None)"
      ]
     },
     "execution_count": 80,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Sélectionner une activité dans une bdd\n",
    "activity_1 = [\n",
    "    activity for activity in elec_bl\n",
    "    if 'offsite' in activity['name']\n",
    "    and 'transport' in activity['name']   \n",
    "#    and activity['location'] == 'RoW'\n",
    "][0]\n",
    "activity_1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 81,
   "id": "099b8f23-d8fb-4687-804f-f2168e0d39ee",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "market for diesel, low-sulfur 0.0195949765528\n",
      "market for lorry, 40 metric ton 9.65e-08\n",
      "market for maintenance, lorry 40 metric ton 9.65e-08\n",
      "market for road 0.00109\n",
      "market for road maintenance 8.09172e-05\n",
      "offsite_market for municipal solid waste -1.52615789473684e-05\n",
      "offsite_market for municipal solid waste -1.3140350877193e-05\n",
      "offsite_market for municipal solid waste -0.000151207894736842\n"
     ]
    }
   ],
   "source": [
    "for exc in activity_1.technosphere():\n",
    "    print(exc.input['name'], exc['amount'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 84,
   "id": "b830a59d-5225-4f4e-ab88-f284ca2bc0d7",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'offsite_diesel, burned in diesel-electric generating set, 10MW' (megajoule, GLO, None)"
      ]
     },
     "execution_count": 84,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Sélectionner une activité dans une bdd\n",
    "activity_2 = [\n",
    "    activity for activity in elec_bl\n",
    "    if 'offsite' in activity['name']\n",
    "    and 'burned' in activity['name']   \n",
    "#    and activity['location'] == 'RoW'\n",
    "][0]\n",
    "activity_2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 85,
   "id": "294aabf8-c415-45ba-b414-8c73f800a5e4",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "market group for diesel 0.0234\n",
      "market for diesel-electric generating set, 10MW 1.85e-10\n",
      "market for lubricating oil 6.700000000000002e-05\n",
      "offsite_market for municipal solid waste -6.7e-05\n"
     ]
    }
   ],
   "source": [
    "for exc in activity_2.technosphere():\n",
    "    print(exc.input['name'], exc['amount'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 86,
   "id": "5cf06d1d-07d9-4898-a6c4-ed36d89e3bba",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'offsite_excavation, skid-steer loader' (cubic meter, GLO, None)"
      ]
     },
     "execution_count": 86,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Sélectionner une activité dans une bdd\n",
    "activity_3 = [\n",
    "    activity for activity in elec_bl\n",
    "    if 'offsite' in activity['name']\n",
    "    and 'excavation' in activity['name']   \n",
    "#    and activity['location'] == 'RoW'\n",
    "][0]\n",
    "activity_3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 87,
   "id": "c78d41b6-df08-4c0b-9fbd-31fc3757fd32",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "market for building machine 9.09e-07\n",
      "market for diesel 0.13\n",
      "market for lubricating oil 0.003\n",
      "offsite_market for municipal solid waste -0.003\n"
     ]
    }
   ],
   "source": [
    "for exc in activity_3.technosphere():\n",
    "    print(exc.input['name'], exc['amount'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 90,
   "id": "2657e0c3-dfd5-40ea-8290-afb11689add8",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'offsite_excavation, hydraulic digger' (cubic meter, GLO, None)"
      ]
     },
     "execution_count": 90,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Sélectionner une activité dans une bdd\n",
    "activity_4 = [\n",
    "    activity for activity in elec_bl\n",
    "    if 'offsite' in activity['name']\n",
    "    and 'excavation' in activity['name']   \n",
    "#    and activity['location'] == 'RoW'\n",
    "][1]\n",
    "activity_4"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 91,
   "id": "cf123bce-fecf-4da9-b821-440608f87876",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "market for diesel 0.131\n",
      "market for hydraulic digger 1e-06\n",
      "market for lubricating oil 0.0025\n",
      "offsite_market for municipal solid waste -0.0025\n"
     ]
    }
   ],
   "source": [
    "for exc in activity_4.technosphere():\n",
    "    print(exc.input['name'], exc['amount'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 111,
   "id": "716b8d1d-9a0d-499c-b42b-08af538540ce",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'diesel, burned in diesel-electric generating set, 10MW, for oil and gas extraction' (megajoule, GLO, None)"
      ]
     },
     "execution_count": 111,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Sélectionner une activité dans une bdd\n",
    "activity_6 = [\n",
    "    activity for activity in eidb\n",
    "    if 'diesel, burned in diesel-electric generating set, 10MW' in activity['name']\n",
    "#    and 'road' in activity['name']   \n",
    "#    and activity['location'] == 'RoW'\n",
    "][0]\n",
    "activity_6"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 112,
   "id": "6e03aa2e-ce6a-4bf8-adfe-70f9d4de79a1",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "market group for diesel 0.0234000001\n",
      "market for diesel-electric generating set, 10MW 1.85000001e-10\n",
      "market for lubricating oil 1.1658000017399198e-05\n",
      "market for lubricating oil 5.53420000826008e-05\n",
      "market for waste mineral oil -4.815380165393589e-05\n",
      "market for waste mineral oil -1.839091251735534e-05\n",
      "market for waste mineral oil -4.5528583870877175e-07\n"
     ]
    }
   ],
   "source": [
    "for exc in activity_6.technosphere():\n",
    "    print(exc.input['name'], exc['amount'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 106,
   "id": "016c0a04-845f-4a2d-aab3-a46326cf91c2",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'electricity production, oil' (kilowatt hour, CA-NU, None)"
      ]
     },
     "execution_count": 106,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Sélectionner une activité dans une bdd\n",
    "activity_5 = [\n",
    "    activity for activity in eidb\n",
    "    if 'electricity production' in activity['name']\n",
    "    and 'oil' in activity['name']   \n",
    "    and activity['location'] == 'CA-NU'\n",
    "][0]\n",
    "activity_5"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 107,
   "id": "68e9c78b-f31d-4c76-8d1f-23f737173eb8",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "market for ammonia, anhydrous, liquid 0.000749716483861458\n",
      "market for bilge oil -2.53622741516298e-05\n",
      "market for fly ash and scrubber sludge -3.13826647401871e-05\n",
      "market for heavy fuel oil 0.289301745386436\n",
      "market for lignite ash -0.000673476292640615\n",
      "market for limestone, crushed, washed 0.0163237639637081\n",
      "market for municipal solid waste -0.000178579718058257\n",
      "market for oil power plant, 500MW 1.46595988103087e-11\n",
      "market for residue from cooling tower -0.000161318814201025\n",
      "market for waste mineral oil -0.000650001808939596\n",
      "market for water, completely softened 0.120442704519077\n",
      "market for water, decarbonised 0.599949098830776\n"
     ]
    }
   ],
   "source": [
    "for exc in activity_5.technosphere():\n",
    "    print(exc.input['name'], exc['amount'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "66760c7d-766e-4c16-aec9-3007c8be6287",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.12.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}