EmissionBreakdowns.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# BU = 1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Biosphere database already present!!! No setup is needed\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "Writing activities to SQLite3 database:\n",
      "0% [##############################] 100% | ETA: 00:00:00\n",
      "Total time elapsed: 00:00:11\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Title: Writing activities to SQLite3 database:\n",
      "  Started: 10/29/2020 12:18:49\n",
      "  Finished: 10/29/2020 12:19:01\n",
      "  Total time elapsed: 00:00:11\n",
      "  CPU %: 69.90\n",
      "  Memory %: 1.07\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "Writing activities to SQLite3 database:\n",
      "0% [##############################] 100% | ETA: 00:00:00\n",
      "Total time elapsed: 00:00:00\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Title: Writing activities to SQLite3 database:\n",
      "  Started: 10/29/2020 12:19:02\n",
      "  Finished: 10/29/2020 12:19:02\n",
      "  Total time elapsed: 00:00:00\n",
      "  CPU %: 166.20\n",
      "  Memory %: 1.07\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "Writing activities to SQLite3 database:\n",
      "0% [#] 100% | ETA: 00:00:00\n",
      "Total time elapsed: 00:00:00\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Title: Writing activities to SQLite3 database:\n",
      "  Started: 10/29/2020 12:19:02\n",
      "  Finished: 10/29/2020 12:19:02\n",
      "  Total time elapsed: 00:00:00\n",
      "  CPU %: 0.00\n",
      "  Memory %: 1.07\n"
     ]
    }
   ],
   "source": [
    "from project_class import *\n",
    "from building_matrices import *\n",
    "from Compost_use import *\n",
    "from brightway2 import *\n",
    "from time import time\n",
    "from SWOLF_method import *\n",
    "from AbioticDepletion import import_aibiotic_depletion\n",
    "\n",
    "Treatment_processes = {}\n",
    "Treatment_processes['Compost_use']={'input_type':[],'model': Compost_use()}\n",
    "\n",
    "Treatment_processes['Compost_use']['model'].Compost_input.operation['choice_BU']['amount']=1\n",
    "\n",
    "demo = project(\"Compost_use\",Treatment_processes)\n",
    "demo.init_project('SWOLF_AccountMode_LCI DATA.csv')\n",
    "demo.write_project()\n",
    "demo.group_exchanges()\n",
    "import_methods()\n",
    "import_aibiotic_depletion()\n",
    "from Import_IPCC_new import *\n",
    "\n",
    "\n",
    "scenario1 = {\"Compost_use\":{\"Compost\":1}}\n",
    "demo.process_start_scenario(scenario1,'scenario1')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "db = Database(\"waste\")\n",
    "functional_unit = {db.get(\"scenario1\") : 1}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "311.0905669559603\n"
     ]
    }
   ],
   "source": [
    "method = ('IPCC 2013, Ecoinvent V3.5', 'climate change', 'GWP 100a, bioCO2=1, C1_36')\n",
    "A=LCA(functional_unit,method)\n",
    "A.lci()\n",
    "A.lcia()\n",
    "print(A.score)      "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>flow</th>\n",
       "      <th>category</th>\n",
       "      <th>val</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Carbon dioxide, non-fossil</td>\n",
       "      <td>(air,)</td>\n",
       "      <td>544.096416</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Carbon dioxide, fossil</td>\n",
       "      <td>(air,)</td>\n",
       "      <td>-193.319090</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Dinitrogen monoxide</td>\n",
       "      <td>(air,)</td>\n",
       "      <td>39.471016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Dinitrogen monoxide</td>\n",
       "      <td>(air, urban air close to ground)</td>\n",
       "      <td>-29.577465</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Carbon dioxide, fossil</td>\n",
       "      <td>(air, urban air close to ground)</td>\n",
       "      <td>-16.224863</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Carbon dioxide, non-fossil</td>\n",
       "      <td>(air, urban air close to ground)</td>\n",
       "      <td>-11.637393</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Carbon dioxide, fossil</td>\n",
       "      <td>(air, non-urban air or from high stacks)</td>\n",
       "      <td>-8.739701</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Methane, non-fossil</td>\n",
       "      <td>(air, urban air close to ground)</td>\n",
       "      <td>-7.643907</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Methane, fossil</td>\n",
       "      <td>(air, non-urban air or from high stacks)</td>\n",
       "      <td>-3.991012</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Other</td>\n",
       "      <td>_</td>\n",
       "      <td>-1.343434</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Total</td>\n",
       "      <td>_</td>\n",
       "      <td>311.090567</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                          flow                                  category  \\\n",
       "0   Carbon dioxide, non-fossil                                    (air,)   \n",
       "1       Carbon dioxide, fossil                                    (air,)   \n",
       "2          Dinitrogen monoxide                                    (air,)   \n",
       "3          Dinitrogen monoxide          (air, urban air close to ground)   \n",
       "4       Carbon dioxide, fossil          (air, urban air close to ground)   \n",
       "5   Carbon dioxide, non-fossil          (air, urban air close to ground)   \n",
       "6       Carbon dioxide, fossil  (air, non-urban air or from high stacks)   \n",
       "7          Methane, non-fossil          (air, urban air close to ground)   \n",
       "8              Methane, fossil  (air, non-urban air or from high stacks)   \n",
       "10                       Other                                         _   \n",
       "11                       Total                                         _   \n",
       "\n",
       "           val  \n",
       "0   544.096416  \n",
       "1  -193.319090  \n",
       "2    39.471016  \n",
       "3   -29.577465  \n",
       "4   -16.224863  \n",
       "5   -11.637393  \n",
       "6    -8.739701  \n",
       "7    -7.643907  \n",
       "8    -3.991012  \n",
       "10   -1.343434  \n",
       "11  311.090567  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "top_em = pd.DataFrame(columns=['flow','category','val'])\n",
    "cutoff = 9\n",
    "for i,item in enumerate(A.top_emissions()):\n",
    "    if i < cutoff:\n",
    "        top_em.loc[i] = [item[2].as_dict()['name'],item[2].as_dict()['categories'],item[0]]\n",
    "\n",
    "top_em.loc[cutoff+1] = ['Other', '_', A.score - sum(top_em['val'][0:cutoff])]\n",
    "top_em.loc[cutoff+2] = ['Total', '_', A.score]\n",
    "top_em"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>flow</th>\n",
       "      <th>val</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Compost_use_Compost</td>\n",
       "      <td>3.956067e+02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Nitrogen_Fertilizer</td>\n",
       "      <td>-6.889664e+01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Potassium_Fertilizer</td>\n",
       "      <td>-9.905913e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Peat</td>\n",
       "      <td>-7.380349e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Equipment_Diesel</td>\n",
       "      <td>3.093599e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Phosphorous_Fertilizer</td>\n",
       "      <td>-1.426836e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Other</td>\n",
       "      <td>-5.684342e-14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Total</td>\n",
       "      <td>3.110906e+02</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     flow           val\n",
       "0     Compost_use_Compost  3.956067e+02\n",
       "1     Nitrogen_Fertilizer -6.889664e+01\n",
       "2    Potassium_Fertilizer -9.905913e+00\n",
       "3                    Peat -7.380349e+00\n",
       "4        Equipment_Diesel  3.093599e+00\n",
       "5  Phosphorous_Fertilizer -1.426836e+00\n",
       "7                   Other -5.684342e-14\n",
       "8                   Total  3.110906e+02"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "top_act = pd.DataFrame(columns=['flow','val'])\n",
    "cutoff = 6\n",
    "for i,item in enumerate(A.top_activities()):\n",
    "    if i < cutoff:\n",
    "        top_act.loc[i] = [item[2].as_dict()['name'],item[0]]\n",
    "\n",
    "top_act.loc[cutoff+1] = ['Other', A.score - sum(top_act['val'][0:cutoff])]\n",
    "top_act.loc[cutoff+2] = ['Total', A.score]\n",
    "top_act"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "-281.8233524658356\n"
     ]
    }
   ],
   "source": [
    "method = ('IPCC 2013, Ecoinvent V3.5', 'climate change', 'GWP 100a, bioCO2=0, C1_36')\n",
    "A=LCA(functional_unit,method)\n",
    "A.lci()\n",
    "A.lcia()\n",
    "print(A.score)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>flow</th>\n",
       "      <th>category</th>\n",
       "      <th>val</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Carbon dioxide, fossil</td>\n",
       "      <td>(air,)</td>\n",
       "      <td>-193.319090</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Carbon dioxide, from soil or biomass stock</td>\n",
       "      <td>(air,)</td>\n",
       "      <td>-60.473456</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Dinitrogen monoxide</td>\n",
       "      <td>(air,)</td>\n",
       "      <td>39.471016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Dinitrogen monoxide</td>\n",
       "      <td>(air, urban air close to ground)</td>\n",
       "      <td>-29.577465</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Carbon dioxide, fossil</td>\n",
       "      <td>(air, urban air close to ground)</td>\n",
       "      <td>-16.224863</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Carbon dioxide, fossil</td>\n",
       "      <td>(air, non-urban air or from high stacks)</td>\n",
       "      <td>-8.739701</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Methane, non-fossil</td>\n",
       "      <td>(air, urban air close to ground)</td>\n",
       "      <td>-7.643907</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Methane, fossil</td>\n",
       "      <td>(air, non-urban air or from high stacks)</td>\n",
       "      <td>-3.991012</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Methane, fossil</td>\n",
       "      <td>(air,)</td>\n",
       "      <td>-0.343234</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Other</td>\n",
       "      <td>_</td>\n",
       "      <td>-0.981640</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Total</td>\n",
       "      <td>_</td>\n",
       "      <td>-281.823352</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                          flow  \\\n",
       "0                       Carbon dioxide, fossil   \n",
       "1   Carbon dioxide, from soil or biomass stock   \n",
       "2                          Dinitrogen monoxide   \n",
       "3                          Dinitrogen monoxide   \n",
       "4                       Carbon dioxide, fossil   \n",
       "5                       Carbon dioxide, fossil   \n",
       "6                          Methane, non-fossil   \n",
       "7                              Methane, fossil   \n",
       "8                              Methane, fossil   \n",
       "10                                       Other   \n",
       "11                                       Total   \n",
       "\n",
       "                                    category         val  \n",
       "0                                     (air,) -193.319090  \n",
       "1                                     (air,)  -60.473456  \n",
       "2                                     (air,)   39.471016  \n",
       "3           (air, urban air close to ground)  -29.577465  \n",
       "4           (air, urban air close to ground)  -16.224863  \n",
       "5   (air, non-urban air or from high stacks)   -8.739701  \n",
       "6           (air, urban air close to ground)   -7.643907  \n",
       "7   (air, non-urban air or from high stacks)   -3.991012  \n",
       "8                                     (air,)   -0.343234  \n",
       "10                                         _   -0.981640  \n",
       "11                                         _ -281.823352  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "top_em = pd.DataFrame(columns=['flow','category','val'])\n",
    "cutoff = 9\n",
    "for i,item in enumerate(A.top_emissions()):\n",
    "    if i < cutoff:\n",
    "        top_em.loc[i] = [item[2].as_dict()['name'],item[2].as_dict()['categories'],item[0]]\n",
    "\n",
    "top_em.loc[cutoff+1] = ['Other', '_', A.score - sum(top_em['val'][0:cutoff])]\n",
    "top_em.loc[cutoff+2] = ['Total', '_', A.score]\n",
    "top_em"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>flow</th>\n",
       "      <th>val</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Compost_use_Compost</td>\n",
       "      <td>-2.089629e+02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Nitrogen_Fertilizer</td>\n",
       "      <td>-6.141820e+01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Peat</td>\n",
       "      <td>-7.274971e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Potassium_Fertilizer</td>\n",
       "      <td>-5.780132e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Equipment_Diesel</td>\n",
       "      <td>2.880236e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Phosphorous_Fertilizer</td>\n",
       "      <td>-1.267431e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Other</td>\n",
       "      <td>-5.684342e-14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Total</td>\n",
       "      <td>-2.818234e+02</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     flow           val\n",
       "0     Compost_use_Compost -2.089629e+02\n",
       "1     Nitrogen_Fertilizer -6.141820e+01\n",
       "2                    Peat -7.274971e+00\n",
       "3    Potassium_Fertilizer -5.780132e+00\n",
       "4        Equipment_Diesel  2.880236e+00\n",
       "5  Phosphorous_Fertilizer -1.267431e+00\n",
       "7                   Other -5.684342e-14\n",
       "8                   Total -2.818234e+02"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "top_act = pd.DataFrame(columns=['flow','val'])\n",
    "cutoff = 6\n",
    "for i,item in enumerate(A.top_activities()):\n",
    "    if i < cutoff:\n",
    "        top_act.loc[i] = [item[2].as_dict()['name'],item[0]]\n",
    "\n",
    "top_act.loc[cutoff+1] = ['Other', A.score - sum(top_act['val'][0:cutoff])]\n",
    "top_act.loc[cutoff+2] = ['Total', A.score]\n",
    "top_act"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "316.2367166997689\n"
     ]
    }
   ],
   "source": [
    "method = ('IPCC 2007, Ecoinvent V3.5', 'climate change', 'GWP 100a, bioCO2=1')\n",
    "A=LCA(functional_unit,method)\n",
    "A.lci()\n",
    "A.lcia()\n",
    "print(A.score)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>flow</th>\n",
       "      <th>category</th>\n",
       "      <th>val</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Carbon dioxide, non-fossil</td>\n",
       "      <td>(air,)</td>\n",
       "      <td>544.096416</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Carbon dioxide, fossil</td>\n",
       "      <td>(air,)</td>\n",
       "      <td>-193.319090</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Dinitrogen monoxide</td>\n",
       "      <td>(air,)</td>\n",
       "      <td>44.419801</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Dinitrogen monoxide</td>\n",
       "      <td>(air, urban air close to ground)</td>\n",
       "      <td>-33.285819</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Carbon dioxide, fossil</td>\n",
       "      <td>(air, urban air close to ground)</td>\n",
       "      <td>-16.224863</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Carbon dioxide, non-fossil</td>\n",
       "      <td>(air, urban air close to ground)</td>\n",
       "      <td>-11.637393</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Carbon dioxide, fossil</td>\n",
       "      <td>(air, non-urban air or from high stacks)</td>\n",
       "      <td>-8.739701</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Methane, non-fossil</td>\n",
       "      <td>(air, urban air close to ground)</td>\n",
       "      <td>-5.308269</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Methane, fossil</td>\n",
       "      <td>(air, non-urban air or from high stacks)</td>\n",
       "      <td>-2.771536</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Other</td>\n",
       "      <td>_</td>\n",
       "      <td>-0.992829</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Total</td>\n",
       "      <td>_</td>\n",
       "      <td>316.236717</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                          flow                                  category  \\\n",
       "0   Carbon dioxide, non-fossil                                    (air,)   \n",
       "1       Carbon dioxide, fossil                                    (air,)   \n",
       "2          Dinitrogen monoxide                                    (air,)   \n",
       "3          Dinitrogen monoxide          (air, urban air close to ground)   \n",
       "4       Carbon dioxide, fossil          (air, urban air close to ground)   \n",
       "5   Carbon dioxide, non-fossil          (air, urban air close to ground)   \n",
       "6       Carbon dioxide, fossil  (air, non-urban air or from high stacks)   \n",
       "7          Methane, non-fossil          (air, urban air close to ground)   \n",
       "8              Methane, fossil  (air, non-urban air or from high stacks)   \n",
       "10                       Other                                         _   \n",
       "11                       Total                                         _   \n",
       "\n",
       "           val  \n",
       "0   544.096416  \n",
       "1  -193.319090  \n",
       "2    44.419801  \n",
       "3   -33.285819  \n",
       "4   -16.224863  \n",
       "5   -11.637393  \n",
       "6    -8.739701  \n",
       "7    -5.308269  \n",
       "8    -2.771536  \n",
       "10   -0.992829  \n",
       "11  316.236717  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "top_em = pd.DataFrame(columns=['flow','category','val'])\n",
    "cutoff = 9\n",
    "for i,item in enumerate(A.top_emissions()):\n",
    "    if i < cutoff:\n",
    "        top_em.loc[i] = [item[2].as_dict()['name'],item[2].as_dict()['categories'],item[0]]\n",
    "\n",
    "top_em.loc[cutoff+1] = ['Other', '_', A.score - sum(top_em['val'][0:cutoff])]\n",
    "top_em.loc[cutoff+2] = ['Total', '_', A.score]\n",
    "top_em"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>flow</th>\n",
       "      <th>val</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Compost_use_Compost</td>\n",
       "      <td>4.005641e+02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Nitrogen_Fertilizer</td>\n",
       "      <td>-7.034113e+01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Potassium_Fertilizer</td>\n",
       "      <td>-9.078177e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Peat</td>\n",
       "      <td>-6.589843e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Equipment_Diesel</td>\n",
       "      <td>3.047933e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Phosphorous_Fertilizer</td>\n",
       "      <td>-1.366135e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Other</td>\n",
       "      <td>-1.136868e-13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Total</td>\n",
       "      <td>3.162367e+02</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     flow           val\n",
       "0     Compost_use_Compost  4.005641e+02\n",
       "1     Nitrogen_Fertilizer -7.034113e+01\n",
       "2    Potassium_Fertilizer -9.078177e+00\n",
       "3                    Peat -6.589843e+00\n",
       "4        Equipment_Diesel  3.047933e+00\n",
       "5  Phosphorous_Fertilizer -1.366135e+00\n",
       "7                   Other -1.136868e-13\n",
       "8                   Total  3.162367e+02"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "top_act = pd.DataFrame(columns=['flow','val'])\n",
    "cutoff = 6\n",
    "for i,item in enumerate(A.top_activities()):\n",
    "    if i < cutoff:\n",
    "        top_act.loc[i] = [item[2].as_dict()['name'],item[0]]\n",
    "\n",
    "top_act.loc[cutoff+1] = ['Other', A.score - sum(top_act['val'][0:cutoff])]\n",
    "top_act.loc[cutoff+2] = ['Total', A.score]\n",
    "top_act"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "-276.10892230268536\n"
     ]
    }
   ],
   "source": [
    "method = ('IPCC 2007, Ecoinvent V3.5', 'climate change', 'GWP 100a, bioCO2=0')\n",
    "A=LCA(functional_unit,method)\n",
    "A.lci()\n",
    "A.lcia()\n",
    "print(A.score)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>flow</th>\n",
       "      <th>category</th>\n",
       "      <th>val</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Carbon dioxide, fossil</td>\n",
       "      <td>(air,)</td>\n",
       "      <td>-193.319090</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Carbon dioxide, from soil or biomass stock</td>\n",
       "      <td>(air,)</td>\n",
       "      <td>-60.473456</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Dinitrogen monoxide</td>\n",
       "      <td>(air,)</td>\n",
       "      <td>44.419801</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Dinitrogen monoxide</td>\n",
       "      <td>(air, urban air close to ground)</td>\n",
       "      <td>-33.285819</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Carbon dioxide, fossil</td>\n",
       "      <td>(air, urban air close to ground)</td>\n",
       "      <td>-16.224863</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Carbon dioxide, fossil</td>\n",
       "      <td>(air, non-urban air or from high stacks)</td>\n",
       "      <td>-8.739701</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Methane, non-fossil</td>\n",
       "      <td>(air, urban air close to ground)</td>\n",
       "      <td>-4.724359</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Methane, fossil</td>\n",
       "      <td>(air, non-urban air or from high stacks)</td>\n",
       "      <td>-2.771536</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Dinitrogen monoxide</td>\n",
       "      <td>(air, non-urban air or from high stacks)</td>\n",
       "      <td>-0.352542</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Other</td>\n",
       "      <td>_</td>\n",
       "      <td>-0.637356</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Total</td>\n",
       "      <td>_</td>\n",
       "      <td>-276.108922</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                          flow  \\\n",
       "0                       Carbon dioxide, fossil   \n",
       "1   Carbon dioxide, from soil or biomass stock   \n",
       "2                          Dinitrogen monoxide   \n",
       "3                          Dinitrogen monoxide   \n",
       "4                       Carbon dioxide, fossil   \n",
       "5                       Carbon dioxide, fossil   \n",
       "6                          Methane, non-fossil   \n",
       "7                              Methane, fossil   \n",
       "8                          Dinitrogen monoxide   \n",
       "10                                       Other   \n",
       "11                                       Total   \n",
       "\n",
       "                                    category         val  \n",
       "0                                     (air,) -193.319090  \n",
       "1                                     (air,)  -60.473456  \n",
       "2                                     (air,)   44.419801  \n",
       "3           (air, urban air close to ground)  -33.285819  \n",
       "4           (air, urban air close to ground)  -16.224863  \n",
       "5   (air, non-urban air or from high stacks)   -8.739701  \n",
       "6           (air, urban air close to ground)   -4.724359  \n",
       "7   (air, non-urban air or from high stacks)   -2.771536  \n",
       "8   (air, non-urban air or from high stacks)   -0.352542  \n",
       "10                                         _   -0.637356  \n",
       "11                                         _ -276.108922  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "top_em = pd.DataFrame(columns=['flow','category','val'])\n",
    "cutoff = 9\n",
    "for i,item in enumerate(A.top_emissions()):\n",
    "    if i < cutoff:\n",
    "        top_em.loc[i] = [item[2].as_dict()['name'],item[2].as_dict()['categories'],item[0]]\n",
    "\n",
    "top_em.loc[cutoff+1] = ['Other', '_', A.score - sum(top_em['val'][0:cutoff])]\n",
    "top_em.loc[cutoff+2] = ['Total', '_', A.score]\n",
    "top_em"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>flow</th>\n",
       "      <th>val</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Compost_use_Compost</td>\n",
       "      <td>-204.005498</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Nitrogen_Fertilizer</td>\n",
       "      <td>-62.497017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Peat</td>\n",
       "      <td>-6.484345</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Potassium_Fertilizer</td>\n",
       "      <td>-4.757364</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Equipment_Diesel</td>\n",
       "      <td>2.835499</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Phosphorous_Fertilizer</td>\n",
       "      <td>-1.200197</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Other</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Total</td>\n",
       "      <td>-276.108922</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     flow         val\n",
       "0     Compost_use_Compost -204.005498\n",
       "1     Nitrogen_Fertilizer  -62.497017\n",
       "2                    Peat   -6.484345\n",
       "3    Potassium_Fertilizer   -4.757364\n",
       "4        Equipment_Diesel    2.835499\n",
       "5  Phosphorous_Fertilizer   -1.200197\n",
       "7                   Other    0.000000\n",
       "8                   Total -276.108922"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "top_act = pd.DataFrame(columns=['flow','val'])\n",
    "cutoff = 6\n",
    "for i,item in enumerate(A.top_activities()):\n",
    "    if i < cutoff:\n",
    "        top_act.loc[i] = [item[2].as_dict()['name'],item[0]]\n",
    "\n",
    "top_act.loc[cutoff+1] = ['Other', A.score - sum(top_act['val'][0:cutoff])]\n",
    "top_act.loc[cutoff+2] = ['Total', A.score]\n",
    "top_act"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# BU = 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Biosphere database already present!!! No setup is needed\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "Writing activities to SQLite3 database:\n",
      "0% [##############################] 100% | ETA: 00:00:00\n",
      "Total time elapsed: 00:00:12\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Title: Writing activities to SQLite3 database:\n",
      "  Started: 10/29/2020 12:19:11\n",
      "  Finished: 10/29/2020 12:19:23\n",
      "  Total time elapsed: 00:00:12\n",
      "  CPU %: 69.80\n",
      "  Memory %: 1.15\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "Writing activities to SQLite3 database:\n",
      "0% [##############################] 100% | ETA: 00:00:00\n",
      "Total time elapsed: 00:00:00\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Title: Writing activities to SQLite3 database:\n",
      "  Started: 10/29/2020 12:19:24\n",
      "  Finished: 10/29/2020 12:19:24\n",
      "  Total time elapsed: 00:00:00\n",
      "  CPU %: 100.80\n",
      "  Memory %: 1.16\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "Writing activities to SQLite3 database:\n",
      "0% [#] 100% | ETA: 00:00:00\n",
      "Total time elapsed: 00:00:00\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Title: Writing activities to SQLite3 database:\n",
      "  Started: 10/29/2020 12:19:24\n",
      "  Finished: 10/29/2020 12:19:24\n",
      "  Total time elapsed: 00:00:00\n",
      "  CPU %: 97.70\n",
      "  Memory %: 1.16\n"
     ]
    }
   ],
   "source": [
    "from project_class import *\n",
    "from building_matrices import *\n",
    "from Compost_use import *\n",
    "from brightway2 import *\n",
    "from time import time\n",
    "from SWOLF_method import *\n",
    "from AbioticDepletion import import_aibiotic_depletion\n",
    "\n",
    "Treatment_processes = {}\n",
    "Treatment_processes['Compost_use']={'input_type':[],'model': Compost_use()}\n",
    "\n",
    "Treatment_processes['Compost_use']['model'].Compost_input.operation['choice_BU']['amount']=0\n",
    "\n",
    "demo = project(\"Compost_use\",Treatment_processes)\n",
    "demo.init_project('SWOLF_AccountMode_LCI DATA.csv')\n",
    "demo.write_project()\n",
    "demo.group_exchanges()\n",
    "import_methods()\n",
    "import_aibiotic_depletion()\n",
    "from Import_IPCC_new import *\n",
    "\n",
    "\n",
    "scenario1 = {\"Compost_use\":{\"Compost\":1}}\n",
    "demo.process_start_scenario(scenario1,'scenario1')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "db = Database(\"waste\")\n",
    "functional_unit = {db.get(\"scenario1\") : 1}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "175.97307501394835\n"
     ]
    }
   ],
   "source": [
    "method = ('IPCC 2013, Ecoinvent V3.5', 'climate change', 'GWP 100a, bioCO2=1, C1_36')\n",
    "A=LCA(functional_unit,method)\n",
    "A.lci()\n",
    "A.lcia()\n",
    "print(A.score)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>flow</th>\n",
       "      <th>category</th>\n",
       "      <th>val</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Methane, non-fossil</td>\n",
       "      <td>(air,)</td>\n",
       "      <td>131.704596</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Carbon dioxide, non-fossil</td>\n",
       "      <td>(air,)</td>\n",
       "      <td>50.417723</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Carbon dioxide, fossil</td>\n",
       "      <td>(air, non-urban air or from high stacks)</td>\n",
       "      <td>-6.150791</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Carbon dioxide, fossil</td>\n",
       "      <td>(air,)</td>\n",
       "      <td>0.753606</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Methane, fossil</td>\n",
       "      <td>(air,)</td>\n",
       "      <td>-0.722942</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Methane, fossil</td>\n",
       "      <td>(air, non-urban air or from high stacks)</td>\n",
       "      <td>-0.206160</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Carbon dioxide, fossil</td>\n",
       "      <td>(air, urban air close to ground)</td>\n",
       "      <td>0.075478</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Carbon dioxide, non-fossil</td>\n",
       "      <td>(air, urban air close to ground)</td>\n",
       "      <td>0.065335</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Carbon monoxide, fossil</td>\n",
       "      <td>(air,)</td>\n",
       "      <td>0.053089</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Other</td>\n",
       "      <td>_</td>\n",
       "      <td>-0.016860</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Total</td>\n",
       "      <td>_</td>\n",
       "      <td>175.973075</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                          flow                                  category  \\\n",
       "0          Methane, non-fossil                                    (air,)   \n",
       "1   Carbon dioxide, non-fossil                                    (air,)   \n",
       "2       Carbon dioxide, fossil  (air, non-urban air or from high stacks)   \n",
       "3       Carbon dioxide, fossil                                    (air,)   \n",
       "4              Methane, fossil                                    (air,)   \n",
       "5              Methane, fossil  (air, non-urban air or from high stacks)   \n",
       "6       Carbon dioxide, fossil          (air, urban air close to ground)   \n",
       "7   Carbon dioxide, non-fossil          (air, urban air close to ground)   \n",
       "8      Carbon monoxide, fossil                                    (air,)   \n",
       "10                       Other                                         _   \n",
       "11                       Total                                         _   \n",
       "\n",
       "           val  \n",
       "0   131.704596  \n",
       "1    50.417723  \n",
       "2    -6.150791  \n",
       "3     0.753606  \n",
       "4    -0.722942  \n",
       "5    -0.206160  \n",
       "6     0.075478  \n",
       "7     0.065335  \n",
       "8     0.053089  \n",
       "10   -0.016860  \n",
       "11  175.973075  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "top_em = pd.DataFrame(columns=['flow','category','val'])\n",
    "cutoff = 9\n",
    "for i,item in enumerate(A.top_emissions()):\n",
    "    if i < cutoff:\n",
    "        top_em.loc[i] = [item[2].as_dict()['name'],item[2].as_dict()['categories'],item[0]]\n",
    "\n",
    "top_em.loc[cutoff+1] = ['Other', '_', A.score - sum(top_em['val'][0:cutoff])]\n",
    "top_em.loc[cutoff+2] = ['Total', '_', A.score]\n",
    "top_em"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[(182.1256999969482,\n",
       "  0.9999999999999999,\n",
       "  'Compost_use_Compost' (Mg, None, None)),\n",
       " (-12.028855533141714,\n",
       "  19.008571624755856,\n",
       "  'Electricity_production' (kWh/Mg, None, None)),\n",
       " (5.350219761759122, 0.49999999999999994, 'compost_to_LF' (kg/Mg, None, None)),\n",
       " (0.526010788382705,\n",
       "  0.8571428656578063,\n",
       "  'market_for_excavation_skid_steer_loader' (kg/m3, None, None)),\n",
       " (0.0, 0.0, 'Electricity_consumption' (kWh/Mg, None, None)),\n",
       " (0.0, 0.0, 'Heat_Steam' (MJ/Mg, None, None)),\n",
       " (0.0, 0.0, 'Boiler_Coal' (0, None, None)),\n",
       " (0.0, 0.0, 'Boiler_Bitumen' (0, None, None)),\n",
       " (0.0, 0.0, 'Boiler_Coke' (0, None, None)),\n",
       " (0.0, 0.0, 'Boiler_Petroleum_Crude_Oil' (L/Mg, None, None)),\n",
       " (0.0, 0.0, 'Boiler_Kerosene' (L/Mg, None, None)),\n",
       " (0.0, 0.0, 'Boiler_Distillate' (L/Mg, None, None)),\n",
       " (0.0, 0.0, 'Boiler_Residual_Fuel_Oil' (L/Mg, None, None)),\n",
       " (0.0, 0.0, 'Boiler_CNG' (m3/Mg, None, None)),\n",
       " (0.0, 0.0, 'Boiler_LPG' (L/Mg, None, None)),\n",
       " (0.0, 0.0, 'Boiler_Gasoline' (L/Mg, None, None)),\n",
       " (0.0, 0.0, 'Boiler_Diesel' (L/Mg, None, None)),\n",
       " (0.0, 0.0, 'Boiler_Wood' (0, None, None)),\n",
       " (0.0, 0.0, 'Equipment_Kerosene' (L/Mg, None, None)),\n",
       " (0.0, 0.0, 'Equipment_Distillate' (L/Mg, None, None)),\n",
       " (0.0, 0.0, 'Equipment_Residual_Fuel_Oil' (L/Mg, None, None)),\n",
       " (0.0, 0.0, 'Equipment_CNG' (0, None, None)),\n",
       " (0.0, 0.0, 'Equipment_LPG' (L/Mg, None, None)),\n",
       " (0.0, 0.0, 'Equipment_Gasoline' (L/Mg, None, None)),\n",
       " (0.0, 0.0, 'Equipment_Diesel' (L/Mg, None, None))]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "A.top_activities()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>flow</th>\n",
       "      <th>val</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Compost_use_Compost</td>\n",
       "      <td>1.821257e+02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Electricity_production</td>\n",
       "      <td>-1.202886e+01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>compost_to_LF</td>\n",
       "      <td>5.350220e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>market_for_excavation_skid_steer_loader</td>\n",
       "      <td>5.260108e-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Electricity_consumption</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Heat_Steam</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Other</td>\n",
       "      <td>2.842171e-14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Total</td>\n",
       "      <td>1.759731e+02</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                      flow           val\n",
       "0                      Compost_use_Compost  1.821257e+02\n",
       "1                   Electricity_production -1.202886e+01\n",
       "2                            compost_to_LF  5.350220e+00\n",
       "3  market_for_excavation_skid_steer_loader  5.260108e-01\n",
       "4                  Electricity_consumption  0.000000e+00\n",
       "5                               Heat_Steam  0.000000e+00\n",
       "7                                    Other  2.842171e-14\n",
       "8                                    Total  1.759731e+02"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "top_act = pd.DataFrame(columns=['flow','val'])\n",
    "cutoff = 6\n",
    "for i,item in enumerate(A.top_activities()):\n",
    "    if i < cutoff:\n",
    "        top_act.loc[i] = [item[2].as_dict()['name'],item[0]]\n",
    "\n",
    "top_act.loc[cutoff+1] = ['Other', A.score - sum(top_act['val'][0:cutoff])]\n",
    "top_act.loc[cutoff+2] = ['Total', A.score]\n",
    "top_act"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "-418.6260319339887\n"
     ]
    }
   ],
   "source": [
    "method = ('IPCC 2013, Ecoinvent V3.5', 'climate change', 'GWP 100a, bioCO2=0, C1_36')\n",
    "A=LCA(functional_unit,method)\n",
    "A.lci()\n",
    "A.lcia()\n",
    "print(A.score)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>flow</th>\n",
       "      <th>category</th>\n",
       "      <th>val</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Carbon dioxide, from soil or biomass stock</td>\n",
       "      <td>(air,)</td>\n",
       "      <td>-544.113019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Methane, non-fossil</td>\n",
       "      <td>(air,)</td>\n",
       "      <td>131.704596</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Carbon dioxide, fossil</td>\n",
       "      <td>(air, non-urban air or from high stacks)</td>\n",
       "      <td>-6.150791</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Carbon dioxide, fossil</td>\n",
       "      <td>(air,)</td>\n",
       "      <td>0.753606</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Methane, fossil</td>\n",
       "      <td>(air,)</td>\n",
       "      <td>-0.722942</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Methane, fossil</td>\n",
       "      <td>(air, non-urban air or from high stacks)</td>\n",
       "      <td>-0.206160</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Carbon dioxide, fossil</td>\n",
       "      <td>(air, urban air close to ground)</td>\n",
       "      <td>0.075478</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Carbon monoxide, fossil</td>\n",
       "      <td>(air,)</td>\n",
       "      <td>0.053089</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Dinitrogen monoxide</td>\n",
       "      <td>(air, non-urban air or from high stacks)</td>\n",
       "      <td>-0.038002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Other</td>\n",
       "      <td>_</td>\n",
       "      <td>0.018111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Total</td>\n",
       "      <td>_</td>\n",
       "      <td>-418.626032</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                          flow  \\\n",
       "0   Carbon dioxide, from soil or biomass stock   \n",
       "1                          Methane, non-fossil   \n",
       "2                       Carbon dioxide, fossil   \n",
       "3                       Carbon dioxide, fossil   \n",
       "4                              Methane, fossil   \n",
       "5                              Methane, fossil   \n",
       "6                       Carbon dioxide, fossil   \n",
       "7                      Carbon monoxide, fossil   \n",
       "8                          Dinitrogen monoxide   \n",
       "10                                       Other   \n",
       "11                                       Total   \n",
       "\n",
       "                                    category         val  \n",
       "0                                     (air,) -544.113019  \n",
       "1                                     (air,)  131.704596  \n",
       "2   (air, non-urban air or from high stacks)   -6.150791  \n",
       "3                                     (air,)    0.753606  \n",
       "4                                     (air,)   -0.722942  \n",
       "5   (air, non-urban air or from high stacks)   -0.206160  \n",
       "6           (air, urban air close to ground)    0.075478  \n",
       "7                                     (air,)    0.053089  \n",
       "8   (air, non-urban air or from high stacks)   -0.038002  \n",
       "10                                         _    0.018111  \n",
       "11                                         _ -418.626032  "
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "top_em = pd.DataFrame(columns=['flow','category','val'])\n",
    "cutoff = 9\n",
    "for i,item in enumerate(A.top_emissions()):\n",
    "    if i < cutoff:\n",
    "        top_em.loc[i] = [item[2].as_dict()['name'],item[2].as_dict()['categories'],item[0]]\n",
    "\n",
    "top_em.loc[cutoff+1] = ['Other', '_', A.score - sum(top_em['val'][0:cutoff])]\n",
    "top_em.loc[cutoff+2] = ['Total', '_', A.score]\n",
    "top_em"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>flow</th>\n",
       "      <th>val</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Compost_use_Compost</td>\n",
       "      <td>-412.408010</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Electricity_production</td>\n",
       "      <td>-11.715651</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>compost_to_LF</td>\n",
       "      <td>5.006771</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>market_for_excavation_skid_steer_loader</td>\n",
       "      <td>0.490858</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Electricity_consumption</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Heat_Steam</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Other</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Total</td>\n",
       "      <td>-418.626032</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                      flow         val\n",
       "0                      Compost_use_Compost -412.408010\n",
       "1                   Electricity_production  -11.715651\n",
       "2                            compost_to_LF    5.006771\n",
       "3  market_for_excavation_skid_steer_loader    0.490858\n",
       "4                  Electricity_consumption    0.000000\n",
       "5                               Heat_Steam    0.000000\n",
       "7                                    Other    0.000000\n",
       "8                                    Total -418.626032"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "top_act = pd.DataFrame(columns=['flow','val'])\n",
    "cutoff = 6\n",
    "for i,item in enumerate(A.top_activities()):\n",
    "    if i < cutoff:\n",
    "        top_act.loc[i] = [item[2].as_dict()['name'],item[0]]\n",
    "\n",
    "top_act.loc[cutoff+1] = ['Other', A.score - sum(top_act['val'][0:cutoff])]\n",
    "top_act.loc[cutoff+2] = ['Total', A.score]\n",
    "top_act"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "135.96284146977564\n"
     ]
    }
   ],
   "source": [
    "method = ('IPCC 2007, Ecoinvent V3.5', 'climate change', 'GWP 100a, bioCO2=1')\n",
    "A=LCA(functional_unit,method)\n",
    "A.lci()\n",
    "A.lcia()\n",
    "print(A.score)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>flow</th>\n",
       "      <th>category</th>\n",
       "      <th>val</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Methane, non-fossil</td>\n",
       "      <td>(air,)</td>\n",
       "      <td>91.461525</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Carbon dioxide, non-fossil</td>\n",
       "      <td>(air,)</td>\n",
       "      <td>50.417723</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Carbon dioxide, fossil</td>\n",
       "      <td>(air, non-urban air or from high stacks)</td>\n",
       "      <td>-6.150791</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Carbon dioxide, fossil</td>\n",
       "      <td>(air,)</td>\n",
       "      <td>0.753606</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Methane, fossil</td>\n",
       "      <td>(air,)</td>\n",
       "      <td>-0.502043</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Methane, fossil</td>\n",
       "      <td>(air, non-urban air or from high stacks)</td>\n",
       "      <td>-0.143167</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Carbon dioxide, fossil</td>\n",
       "      <td>(air, urban air close to ground)</td>\n",
       "      <td>0.075478</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Carbon dioxide, non-fossil</td>\n",
       "      <td>(air, urban air close to ground)</td>\n",
       "      <td>0.065335</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Dinitrogen monoxide</td>\n",
       "      <td>(air, non-urban air or from high stacks)</td>\n",
       "      <td>-0.042766</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Other</td>\n",
       "      <td>_</td>\n",
       "      <td>0.027940</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Total</td>\n",
       "      <td>_</td>\n",
       "      <td>135.962841</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                          flow                                  category  \\\n",
       "0          Methane, non-fossil                                    (air,)   \n",
       "1   Carbon dioxide, non-fossil                                    (air,)   \n",
       "2       Carbon dioxide, fossil  (air, non-urban air or from high stacks)   \n",
       "3       Carbon dioxide, fossil                                    (air,)   \n",
       "4              Methane, fossil                                    (air,)   \n",
       "5              Methane, fossil  (air, non-urban air or from high stacks)   \n",
       "6       Carbon dioxide, fossil          (air, urban air close to ground)   \n",
       "7   Carbon dioxide, non-fossil          (air, urban air close to ground)   \n",
       "8          Dinitrogen monoxide  (air, non-urban air or from high stacks)   \n",
       "10                       Other                                         _   \n",
       "11                       Total                                         _   \n",
       "\n",
       "           val  \n",
       "0    91.461525  \n",
       "1    50.417723  \n",
       "2    -6.150791  \n",
       "3     0.753606  \n",
       "4    -0.502043  \n",
       "5    -0.143167  \n",
       "6     0.075478  \n",
       "7     0.065335  \n",
       "8    -0.042766  \n",
       "10    0.027940  \n",
       "11  135.962841  "
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "top_em = pd.DataFrame(columns=['flow','category','val'])\n",
    "cutoff = 9\n",
    "for i,item in enumerate(A.top_emissions()):\n",
    "    if i < cutoff:\n",
    "        top_em.loc[i] = [item[2].as_dict()['name'],item[2].as_dict()['categories'],item[0]]\n",
    "\n",
    "top_em.loc[cutoff+1] = ['Other', '_', A.score - sum(top_em['val'][0:cutoff])]\n",
    "top_em.loc[cutoff+2] = ['Total', '_', A.score]\n",
    "top_em"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>flow</th>\n",
       "      <th>val</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Compost_use_Compost</td>\n",
       "      <td>1.418826e+02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Electricity_production</td>\n",
       "      <td>-1.169739e+01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>compost_to_LF</td>\n",
       "      <td>5.259715e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>market_for_excavation_skid_steer_loader</td>\n",
       "      <td>5.178866e-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Electricity_consumption</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Heat_Steam</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Other</td>\n",
       "      <td>2.842171e-14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Total</td>\n",
       "      <td>1.359628e+02</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                      flow           val\n",
       "0                      Compost_use_Compost  1.418826e+02\n",
       "1                   Electricity_production -1.169739e+01\n",
       "2                            compost_to_LF  5.259715e+00\n",
       "3  market_for_excavation_skid_steer_loader  5.178866e-01\n",
       "4                  Electricity_consumption  0.000000e+00\n",
       "5                               Heat_Steam  0.000000e+00\n",
       "7                                    Other  2.842171e-14\n",
       "8                                    Total  1.359628e+02"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "top_act = pd.DataFrame(columns=['flow','val'])\n",
    "cutoff = 6\n",
    "for i,item in enumerate(A.top_activities()):\n",
    "    if i < cutoff:\n",
    "        top_act.loc[i] = [item[2].as_dict()['name'],item[0]]\n",
    "\n",
    "top_act.loc[cutoff+1] = ['Other', A.score - sum(top_act['val'][0:cutoff])]\n",
    "top_act.loc[cutoff+2] = ['Total', A.score]\n",
    "top_act"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "-468.69537447281635\n"
     ]
    }
   ],
   "source": [
    "method = ('IPCC 2007, Ecoinvent V3.5', 'climate change', 'GWP 100a, bioCO2=0')\n",
    "A=LCA(functional_unit,method)\n",
    "A.lci()\n",
    "A.lcia()\n",
    "print(A.score)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>flow</th>\n",
       "      <th>category</th>\n",
       "      <th>val</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Carbon dioxide, from soil or biomass stock</td>\n",
       "      <td>(air,)</td>\n",
       "      <td>-544.113019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Methane, non-fossil</td>\n",
       "      <td>(air,)</td>\n",
       "      <td>81.400757</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Carbon dioxide, fossil</td>\n",
       "      <td>(air, non-urban air or from high stacks)</td>\n",
       "      <td>-6.150791</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Carbon dioxide, fossil</td>\n",
       "      <td>(air,)</td>\n",
       "      <td>0.753606</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Methane, fossil</td>\n",
       "      <td>(air,)</td>\n",
       "      <td>-0.502043</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Methane, fossil</td>\n",
       "      <td>(air, non-urban air or from high stacks)</td>\n",
       "      <td>-0.143167</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Carbon dioxide, fossil</td>\n",
       "      <td>(air, urban air close to ground)</td>\n",
       "      <td>0.075478</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Dinitrogen monoxide</td>\n",
       "      <td>(air, non-urban air or from high stacks)</td>\n",
       "      <td>-0.042766</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Dinitrogen monoxide</td>\n",
       "      <td>(air, urban air close to ground)</td>\n",
       "      <td>-0.028970</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Other</td>\n",
       "      <td>_</td>\n",
       "      <td>0.055539</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Total</td>\n",
       "      <td>_</td>\n",
       "      <td>-468.695374</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                          flow  \\\n",
       "0   Carbon dioxide, from soil or biomass stock   \n",
       "1                          Methane, non-fossil   \n",
       "2                       Carbon dioxide, fossil   \n",
       "3                       Carbon dioxide, fossil   \n",
       "4                              Methane, fossil   \n",
       "5                              Methane, fossil   \n",
       "6                       Carbon dioxide, fossil   \n",
       "7                          Dinitrogen monoxide   \n",
       "8                          Dinitrogen monoxide   \n",
       "10                                       Other   \n",
       "11                                       Total   \n",
       "\n",
       "                                    category         val  \n",
       "0                                     (air,) -544.113019  \n",
       "1                                     (air,)   81.400757  \n",
       "2   (air, non-urban air or from high stacks)   -6.150791  \n",
       "3                                     (air,)    0.753606  \n",
       "4                                     (air,)   -0.502043  \n",
       "5   (air, non-urban air or from high stacks)   -0.143167  \n",
       "6           (air, urban air close to ground)    0.075478  \n",
       "7   (air, non-urban air or from high stacks)   -0.042766  \n",
       "8           (air, urban air close to ground)   -0.028970  \n",
       "10                                         _    0.055539  \n",
       "11                                         _ -468.695374  "
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "top_em = pd.DataFrame(columns=['flow','category','val'])\n",
    "cutoff = 9\n",
    "for i,item in enumerate(A.top_emissions()):\n",
    "    if i < cutoff:\n",
    "        top_em.loc[i] = [item[2].as_dict()['name'],item[2].as_dict()['categories'],item[0]]\n",
    "\n",
    "top_em.loc[cutoff+1] = ['Other', '_', A.score - sum(top_em['val'][0:cutoff])]\n",
    "top_em.loc[cutoff+2] = ['Total', '_', A.score]\n",
    "top_em"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>flow</th>\n",
       "      <th>val</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Compost_use_Compost</td>\n",
       "      <td>-4.627119e+02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Electricity_production</td>\n",
       "      <td>-1.138412e+01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>compost_to_LF</td>\n",
       "      <td>4.917719e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>market_for_excavation_skid_steer_loader</td>\n",
       "      <td>4.828780e-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Electricity_consumption</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Heat_Steam</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Other</td>\n",
       "      <td>-1.705303e-13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Total</td>\n",
       "      <td>-4.686954e+02</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                      flow           val\n",
       "0                      Compost_use_Compost -4.627119e+02\n",
       "1                   Electricity_production -1.138412e+01\n",
       "2                            compost_to_LF  4.917719e+00\n",
       "3  market_for_excavation_skid_steer_loader  4.828780e-01\n",
       "4                  Electricity_consumption  0.000000e+00\n",
       "5                               Heat_Steam  0.000000e+00\n",
       "7                                    Other -1.705303e-13\n",
       "8                                    Total -4.686954e+02"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "top_act = pd.DataFrame(columns=['flow','val'])\n",
    "cutoff = 6\n",
    "for i,item in enumerate(A.top_activities()):\n",
    "    if i < cutoff:\n",
    "        top_act.loc[i] = [item[2].as_dict()['name'],item[0]]\n",
    "\n",
    "top_act.loc[cutoff+1] = ['Other', A.score - sum(top_act['val'][0:cutoff])]\n",
    "top_act.loc[cutoff+2] = ['Total', A.score]\n",
    "top_act"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "175.97307501394835\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>flow</th>\n",
       "      <th>val</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Compost_use_Compost</td>\n",
       "      <td>1.821257e+02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Electricity_production</td>\n",
       "      <td>-1.202886e+01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>compost_to_LF</td>\n",
       "      <td>5.350220e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>market_for_excavation_skid_steer_loader</td>\n",
       "      <td>5.260108e-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Electricity_consumption</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Heat_Steam</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Other</td>\n",
       "      <td>2.842171e-14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Total</td>\n",
       "      <td>1.759731e+02</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                      flow           val\n",
       "0                      Compost_use_Compost  1.821257e+02\n",
       "1                   Electricity_production -1.202886e+01\n",
       "2                            compost_to_LF  5.350220e+00\n",
       "3  market_for_excavation_skid_steer_loader  5.260108e-01\n",
       "4                  Electricity_consumption  0.000000e+00\n",
       "5                               Heat_Steam  0.000000e+00\n",
       "7                                    Other  2.842171e-14\n",
       "8                                    Total  1.759731e+02"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "method = ('IPCC 2013, Ecoinvent V3.5', 'climate change', 'GWP 100a, bioCO2=1, C1_36')\n",
    "A=LCA(functional_unit,method)\n",
    "A.lci()\n",
    "A.lcia()\n",
    "print(A.score)\n",
    "top_act = pd.DataFrame(columns=['flow','val'])\n",
    "cutoff = 6\n",
    "for i,item in enumerate(A.top_activities()):\n",
    "    if i < cutoff:\n",
    "        top_act.loc[i] = [item[2].as_dict()['name'],item[0]]\n",
    "\n",
    "top_act.loc[cutoff+1] = ['Other', A.score - sum(top_act['val'][0:cutoff])]\n",
    "top_act.loc[cutoff+2] = ['Total', A.score]\n",
    "top_act"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "199.50477529184906"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sum(abs(top_act['val'][0:3]))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "175.97307501394835\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>flow</th>\n",
       "      <th>val</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Compost_use_Compost</td>\n",
       "      <td>1.821257e+02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Electricity_production</td>\n",
       "      <td>-1.202886e+01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>compost_to_LF</td>\n",
       "      <td>5.350220e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>market_for_excavation_skid_steer_loader</td>\n",
       "      <td>5.260108e-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Electricity_consumption</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Heat_Steam</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Boiler_Coal</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Other</td>\n",
       "      <td>2.842171e-14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Total</td>\n",
       "      <td>1.759731e+02</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                      flow           val\n",
       "0                      Compost_use_Compost  1.821257e+02\n",
       "1                   Electricity_production -1.202886e+01\n",
       "2                            compost_to_LF  5.350220e+00\n",
       "3  market_for_excavation_skid_steer_loader  5.260108e-01\n",
       "4                  Electricity_consumption  0.000000e+00\n",
       "5                               Heat_Steam  0.000000e+00\n",
       "6                              Boiler_Coal  0.000000e+00\n",
       "7                                    Other  2.842171e-14\n",
       "8                                    Total  1.759731e+02"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#method = ('SWOLF_Acidification','SWOLF')\n",
    "# method = ('SWOLF_Eutrophication','SWOLF')\n",
    "# method = ('SWOLF_CED','SWOLF')\n",
    "# method = ('CML (v4.4, 2015)', 'resources', 'depletion of abiotic resources - elements, ultimate reserves')\n",
    "method = ('IPCC 2013, Ecoinvent V3.5', 'climate change', 'GWP 100a, bioCO2=1, C1_36')\n",
    "A=LCA(functional_unit,method)\n",
    "A.lci()\n",
    "A.lcia()\n",
    "print(A.score)\n",
    "top_act = pd.DataFrame(columns=['flow','val'])\n",
    "cutoff = 6\n",
    "for i,item in enumerate(A.top_activities()):\n",
    "    if i <= cutoff:\n",
    "        top_act.loc[i] = [item[2].as_dict()['name'],item[0]]\n",
    "\n",
    "top_act.loc[cutoff+1] = ['Other', A.score - sum(top_act['val'][0:cutoff])]\n",
    "top_act.loc[cutoff+2] = ['Total', A.score]\n",
    "top_act"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([-6.01350211])"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "top_act[top_act['flow']=='Electricity_production']['val'].values / sum(abs(top_act['val'][0:8].values))* 100"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "CED -63.61007063833658\n",
    "Eutrophication -26.03517242\n",
    "Acidification -62.21088919\n",
    "ADP -49.89611205\n",
    "GWp -6.01350211"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "CED -63.61007063833658 Eutrophication -26.03517242 Acidification -62.21088919 ADP -49.89611205 GWp -6.01350211"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "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.7.9"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}