carbon_footprint_transportation.ipynb

{"cells":[{"cell_type":"code","source":["import numpy as np\n","import pandas as pd\n","import os\n","df = pd.read_csv(\"dream_market_cocaine_listings_edited.csv\", engine=\"python\")"],"metadata":{"id":"s-CmCocJBw1k"},"execution_count":null,"outputs":[]},{"cell_type":"code","source":["df.head()"],"metadata":{"id":"gFyrNMDbCgNJ","executionInfo":{"status":"ok","timestamp":1689242971398,"user_tz":-540,"elapsed":10,"user":{"displayName":"김준희","userId":"08405862139210390425"}},"colab":{"base_uri":"https://localhost:8080/","height":436},"outputId":"2aef1d45-57d4-41da-d152-ae9c5f5d890b"},"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":["   Unnamed: 0                                      product_title  \\\n","0          10              !!!!!INTRO OFFER!!!!! 1GR COCAINE 90%   \n","1          11              !!!!!INTRO OFFER!!!!! 2GR COCAINE 90%   \n","2          14  !!!INTRO!!! 0.5G COCAINE 89% - STRAIGHT FROM T...   \n","3          20  !1G! C O L O M B I A N C O C A I N E - 89% PURITY   \n","4          41      ** 1 Gram 87% Pure Uncut Colombian Cocaine **   \n","\n","  ships_from_to  grams  quality  btc_price  cost_per_gram  cost_per_gram_pure  \\\n","0      NL  → EU    1.0     90.0    0.02577        0.02577            0.028633   \n","1      NL  → EU    2.0     90.0    0.05150        0.02575            0.028611   \n","2      NL  → EU    0.5     89.0    0.01649        0.03298            0.037056   \n","3      FR  → EU    1.0     89.0    0.04120        0.04120            0.046292   \n","4      NL  → WW    1.0     87.0    0.03400        0.03400            0.039080   \n","\n","   escrow                                       product_link  \\\n","0       1  http://lchudifyeqm4ldjj.onion/viewProduct?offe...   \n","1       1  http://lchudifyeqm4ldjj.onion/viewProduct?offe...   \n","2       1  http://lchudifyeqm4ldjj.onion/viewProduct?offe...   \n","3       1  http://lchudifyeqm4ldjj.onion/viewProduct?offe...   \n","4       1  http://lchudifyeqm4ldjj.onion/viewProduct?offe...   \n","\n","                                         vendor_link        vendor_name  \\\n","0  http://lchudifyeqm4ldjj.onion/contactMember?me...       Mister-Molly   \n","1  http://lchudifyeqm4ldjj.onion/contactMember?me...       Mister-Molly   \n","2  http://lchudifyeqm4ldjj.onion/contactMember?me...      0ldamsterdamm   \n","3  http://lchudifyeqm4ldjj.onion/contactMember?me...     lhomme-masquer   \n","4  http://lchudifyeqm4ldjj.onion/contactMember?me...  SMOOTHCRIMINAL007   \n","\n","   successful_transactions  rating  \n","0                       90    4.63  \n","1                       90    4.63  \n","2                      620    4.94  \n","3                       15    5.00  \n","4                       28    4.78  "],"text/html":["\n","\n","  <div id=\"df-2cb6b9dd-90f0-45df-a439-9dba580876e9\">\n","    <div class=\"colab-df-container\">\n","      <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>Unnamed: 0</th>\n","      <th>product_title</th>\n","      <th>ships_from_to</th>\n","      <th>grams</th>\n","      <th>quality</th>\n","      <th>btc_price</th>\n","      <th>cost_per_gram</th>\n","      <th>cost_per_gram_pure</th>\n","      <th>escrow</th>\n","      <th>product_link</th>\n","      <th>vendor_link</th>\n","      <th>vendor_name</th>\n","      <th>successful_transactions</th>\n","      <th>rating</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>10</td>\n","      <td>!!!!!INTRO OFFER!!!!! 1GR COCAINE 90%</td>\n","      <td>NL  → EU</td>\n","      <td>1.0</td>\n","      <td>90.0</td>\n","      <td>0.02577</td>\n","      <td>0.02577</td>\n","      <td>0.028633</td>\n","      <td>1</td>\n","      <td>http://lchudifyeqm4ldjj.onion/viewProduct?offe...</td>\n","      <td>http://lchudifyeqm4ldjj.onion/contactMember?me...</td>\n","      <td>Mister-Molly</td>\n","      <td>90</td>\n","      <td>4.63</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>11</td>\n","      <td>!!!!!INTRO OFFER!!!!! 2GR COCAINE 90%</td>\n","      <td>NL  → EU</td>\n","      <td>2.0</td>\n","      <td>90.0</td>\n","      <td>0.05150</td>\n","      <td>0.02575</td>\n","      <td>0.028611</td>\n","      <td>1</td>\n","      <td>http://lchudifyeqm4ldjj.onion/viewProduct?offe...</td>\n","      <td>http://lchudifyeqm4ldjj.onion/contactMember?me...</td>\n","      <td>Mister-Molly</td>\n","      <td>90</td>\n","      <td>4.63</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>14</td>\n","      <td>!!!INTRO!!! 0.5G COCAINE 89% - STRAIGHT FROM T...</td>\n","      <td>NL  → EU</td>\n","      <td>0.5</td>\n","      <td>89.0</td>\n","      <td>0.01649</td>\n","      <td>0.03298</td>\n","      <td>0.037056</td>\n","      <td>1</td>\n","      <td>http://lchudifyeqm4ldjj.onion/viewProduct?offe...</td>\n","      <td>http://lchudifyeqm4ldjj.onion/contactMember?me...</td>\n","      <td>0ldamsterdamm</td>\n","      <td>620</td>\n","      <td>4.94</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>20</td>\n","      <td>!1G! C O L O M B I A N C O C A I N E - 89% PURITY</td>\n","      <td>FR  → EU</td>\n","      <td>1.0</td>\n","      <td>89.0</td>\n","      <td>0.04120</td>\n","      <td>0.04120</td>\n","      <td>0.046292</td>\n","      <td>1</td>\n","      <td>http://lchudifyeqm4ldjj.onion/viewProduct?offe...</td>\n","      <td>http://lchudifyeqm4ldjj.onion/contactMember?me...</td>\n","      <td>lhomme-masquer</td>\n","      <td>15</td>\n","      <td>5.00</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>41</td>\n","      <td>** 1 Gram 87% Pure Uncut Colombian Cocaine **</td>\n","      <td>NL  → WW</td>\n","      <td>1.0</td>\n","      <td>87.0</td>\n","      <td>0.03400</td>\n","      <td>0.03400</td>\n","      <td>0.039080</td>\n","      <td>1</td>\n","      <td>http://lchudifyeqm4ldjj.onion/viewProduct?offe...</td>\n","      <td>http://lchudifyeqm4ldjj.onion/contactMember?me...</td>\n","      <td>SMOOTHCRIMINAL007</td>\n","      <td>28</td>\n","      <td>4.78</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>\n","      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-2cb6b9dd-90f0-45df-a439-9dba580876e9')\"\n","              title=\"Convert this dataframe to an interactive table.\"\n","              style=\"display:none;\">\n","\n","  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n","       width=\"24px\">\n","    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n","    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n","  </svg>\n","      </button>\n","\n","\n","\n","    <div id=\"df-819ea538-7ba5-41d4-8441-5e3ab993396a\">\n","      <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-819ea538-7ba5-41d4-8441-5e3ab993396a')\"\n","              title=\"Suggest charts.\"\n","              style=\"display:none;\">\n","\n","<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n","     width=\"24px\">\n","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","      </button>\n","    </div>\n","\n","<style>\n","  .colab-df-quickchart {\n","    background-color: #E8F0FE;\n","    border: none;\n","    border-radius: 50%;\n","    cursor: pointer;\n","    display: none;\n","    fill: #1967D2;\n","    height: 32px;\n","    padding: 0 0 0 0;\n","    width: 32px;\n","  }\n","\n","  .colab-df-quickchart:hover {\n","    background-color: #E2EBFA;\n","    box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n","    fill: #174EA6;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart {\n","    background-color: #3B4455;\n","    fill: #D2E3FC;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart:hover {\n","    background-color: #434B5C;\n","    box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n","    filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n","    fill: #FFFFFF;\n","  }\n","</style>\n","\n","    <script>\n","      async function quickchart(key) {\n","        const containerElement = document.querySelector('#' + key);\n","        const charts = await google.colab.kernel.invokeFunction(\n","            'suggestCharts', [key], {});\n","      }\n","    </script>\n","\n","      <script>\n","\n","function displayQuickchartButton(domScope) {\n","  let quickchartButtonEl =\n","    domScope.querySelector('#df-819ea538-7ba5-41d4-8441-5e3ab993396a button.colab-df-quickchart');\n","  quickchartButtonEl.style.display =\n","    google.colab.kernel.accessAllowed ? 'block' : 'none';\n","}\n","\n","        displayQuickchartButton(document);\n","      </script>\n","      <style>\n","    .colab-df-container {\n","      display:flex;\n","      flex-wrap:wrap;\n","      gap: 12px;\n","    }\n","\n","    .colab-df-convert {\n","      background-color: #E8F0FE;\n","      border: none;\n","      border-radius: 50%;\n","      cursor: pointer;\n","      display: none;\n","      fill: #1967D2;\n","      height: 32px;\n","      padding: 0 0 0 0;\n","      width: 32px;\n","    }\n","\n","    .colab-df-convert:hover {\n","      background-color: #E2EBFA;\n","      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n","      fill: #174EA6;\n","    }\n","\n","    [theme=dark] .colab-df-convert {\n","      background-color: #3B4455;\n","      fill: #D2E3FC;\n","    }\n","\n","    [theme=dark] .colab-df-convert:hover {\n","      background-color: #434B5C;\n","      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n","      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n","      fill: #FFFFFF;\n","    }\n","  </style>\n","\n","      <script>\n","        const buttonEl =\n","          document.querySelector('#df-2cb6b9dd-90f0-45df-a439-9dba580876e9 button.colab-df-convert');\n","        buttonEl.style.display =\n","          google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n","        async function convertToInteractive(key) {\n","          const element = document.querySelector('#df-2cb6b9dd-90f0-45df-a439-9dba580876e9');\n","          const dataTable =\n","            await google.colab.kernel.invokeFunction('convertToInteractive',\n","                                                     [key], {});\n","          if (!dataTable) return;\n","\n","          const docLinkHtml = 'Like what you see? Visit the ' +\n","            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n","            + ' to learn more about interactive tables.';\n","          element.innerHTML = '';\n","          dataTable['output_type'] = 'display_data';\n","          await google.colab.output.renderOutput(dataTable, element);\n","          const docLink = document.createElement('div');\n","          docLink.innerHTML = docLinkHtml;\n","          element.appendChild(docLink);\n","        }\n","      </script>\n","    </div>\n","  </div>\n"]},"metadata":{},"execution_count":17}]},{"cell_type":"code","source":["# carbon footprint from transportation\n","distance = pd.read_csv(\"distance.csv\", engine=\"python\")\n","distance.head()"],"metadata":{"id":"-Z0KGPNjB_JC","colab":{"base_uri":"https://localhost:8080/","height":260},"executionInfo":{"status":"ok","timestamp":1689242971398,"user_tz":-540,"elapsed":8,"user":{"displayName":"김준희","userId":"08405862139210390425"}},"outputId":"f853fb1e-98ce-46a9-a048-da601a9faf5d"},"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":["   Unnamed: 0 ships_from_to  distance\n","0           0      AU  → AU         0\n","1           1  AU  → AU, NZ         0\n","2           2      BE  → WW         0\n","3           3      BR  → WW         0\n","4           4  CA  → CA, EU         0"],"text/html":["\n","\n","  <div id=\"df-93fc6cae-39b7-4624-9be0-1a4c9cdb0c14\">\n","    <div class=\"colab-df-container\">\n","      <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>Unnamed: 0</th>\n","      <th>ships_from_to</th>\n","      <th>distance</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>0</td>\n","      <td>AU  → AU</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>1</td>\n","      <td>AU  → AU, NZ</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>2</td>\n","      <td>BE  → WW</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>3</td>\n","      <td>BR  → WW</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>4</td>\n","      <td>CA  → CA, EU</td>\n","      <td>0</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>\n","      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-93fc6cae-39b7-4624-9be0-1a4c9cdb0c14')\"\n","              title=\"Convert this dataframe to an interactive table.\"\n","              style=\"display:none;\">\n","\n","  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n","       width=\"24px\">\n","    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n","    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n","  </svg>\n","      </button>\n","\n","\n","\n","    <div id=\"df-b90497b2-5051-4069-ab03-7274896d218e\">\n","      <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-b90497b2-5051-4069-ab03-7274896d218e')\"\n","              title=\"Suggest charts.\"\n","              style=\"display:none;\">\n","\n","<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n","     width=\"24px\">\n","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","      </button>\n","    </div>\n","\n","<style>\n","  .colab-df-quickchart {\n","    background-color: #E8F0FE;\n","    border: none;\n","    border-radius: 50%;\n","    cursor: pointer;\n","    display: none;\n","    fill: #1967D2;\n","    height: 32px;\n","    padding: 0 0 0 0;\n","    width: 32px;\n","  }\n","\n","  .colab-df-quickchart:hover {\n","    background-color: #E2EBFA;\n","    box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n","    fill: #174EA6;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart {\n","    background-color: #3B4455;\n","    fill: #D2E3FC;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart:hover {\n","    background-color: #434B5C;\n","    box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n","    filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n","    fill: #FFFFFF;\n","  }\n","</style>\n","\n","    <script>\n","      async function quickchart(key) {\n","        const containerElement = document.querySelector('#' + key);\n","        const charts = await google.colab.kernel.invokeFunction(\n","            'suggestCharts', [key], {});\n","      }\n","    </script>\n","\n","      <script>\n","\n","function displayQuickchartButton(domScope) {\n","  let quickchartButtonEl =\n","    domScope.querySelector('#df-b90497b2-5051-4069-ab03-7274896d218e button.colab-df-quickchart');\n","  quickchartButtonEl.style.display =\n","    google.colab.kernel.accessAllowed ? 'block' : 'none';\n","}\n","\n","        displayQuickchartButton(document);\n","      </script>\n","      <style>\n","    .colab-df-container {\n","      display:flex;\n","      flex-wrap:wrap;\n","      gap: 12px;\n","    }\n","\n","    .colab-df-convert {\n","      background-color: #E8F0FE;\n","      border: none;\n","      border-radius: 50%;\n","      cursor: pointer;\n","      display: none;\n","      fill: #1967D2;\n","      height: 32px;\n","      padding: 0 0 0 0;\n","      width: 32px;\n","    }\n","\n","    .colab-df-convert:hover {\n","      background-color: #E2EBFA;\n","      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n","      fill: #174EA6;\n","    }\n","\n","    [theme=dark] .colab-df-convert {\n","      background-color: #3B4455;\n","      fill: #D2E3FC;\n","    }\n","\n","    [theme=dark] .colab-df-convert:hover {\n","      background-color: #434B5C;\n","      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n","      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n","      fill: #FFFFFF;\n","    }\n","  </style>\n","\n","      <script>\n","        const buttonEl =\n","          document.querySelector('#df-93fc6cae-39b7-4624-9be0-1a4c9cdb0c14 button.colab-df-convert');\n","        buttonEl.style.display =\n","          google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n","        async function convertToInteractive(key) {\n","          const element = document.querySelector('#df-93fc6cae-39b7-4624-9be0-1a4c9cdb0c14');\n","          const dataTable =\n","            await google.colab.kernel.invokeFunction('convertToInteractive',\n","                                                     [key], {});\n","          if (!dataTable) return;\n","\n","          const docLinkHtml = 'Like what you see? Visit the ' +\n","            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n","            + ' to learn more about interactive tables.';\n","          element.innerHTML = '';\n","          dataTable['output_type'] = 'display_data';\n","          await google.colab.output.renderOutput(dataTable, element);\n","          const docLink = document.createElement('div');\n","          docLink.innerHTML = docLinkHtml;\n","          element.appendChild(docLink);\n","        }\n","      </script>\n","    </div>\n","  </div>\n"]},"metadata":{},"execution_count":18}]},{"cell_type":"code","source":["df = df.merge(distance, how=\"outer\", on='ships_from_to')\n","df.head()"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":1000},"id":"iIHDapCCpBTo","executionInfo":{"status":"ok","timestamp":1689242971398,"user_tz":-540,"elapsed":7,"user":{"displayName":"김준희","userId":"08405862139210390425"}},"outputId":"e689dbb3-23c7-444e-ddfa-8377f985d1f0"},"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":["      Unnamed: 0_x                                      product_title  \\\n","0               10              !!!!!INTRO OFFER!!!!! 1GR COCAINE 90%   \n","1               11              !!!!!INTRO OFFER!!!!! 2GR COCAINE 90%   \n","2               14  !!!INTRO!!! 0.5G COCAINE 89% - STRAIGHT FROM T...   \n","3              239  0,2g SAMPLE Cocaine 90%+ Pure Flakes Uncut Col...   \n","4              256      0,5g Cocaine 90%+ Pure Flakes Uncut Colombian   \n","...            ...                                                ...   \n","1499          3951                       Quality cocaine 0,5 gram 80%   \n","1500          3952                         Quality cocaine 1 gram 80%   \n","1501          3953                         Quality cocaine 2 gram 80%   \n","1502          3954                         Quality cocaine 3 gram 80%   \n","1503          3955                         Quality cocaine 5 gram 80%   \n","\n","     ships_from_to  grams  quality  btc_price  cost_per_gram  \\\n","0         NL  → EU    1.0     90.0    0.02577       0.025770   \n","1         NL  → EU    2.0     90.0    0.05150       0.025750   \n","2         NL  → EU    0.5     89.0    0.01649       0.032980   \n","3         NL  → EU    2.0     90.0    0.00773       0.003865   \n","4         NL  → EU    5.0     90.0    0.01597       0.003194   \n","...            ...    ...      ...        ...            ...   \n","1499  EU  → EU, US    5.0     80.0    0.01649       0.003298   \n","1500  EU  → EU, US    1.0     80.0    0.02577       0.025770   \n","1501  EU  → EU, US    2.0     80.0    0.05100       0.025500   \n","1502  EU  → EU, US    3.0     80.0    0.07470       0.024900   \n","1503  EU  → EU, US    5.0     80.0    0.12360       0.024720   \n","\n","      cost_per_gram_pure  escrow  \\\n","0               0.028633       1   \n","1               0.028611       1   \n","2               0.037056       1   \n","3               0.004294       1   \n","4               0.003549       1   \n","...                  ...     ...   \n","1499            0.004123       1   \n","1500            0.032212       1   \n","1501            0.031875       1   \n","1502            0.031125       1   \n","1503            0.030900       1   \n","\n","                                           product_link  \\\n","0     http://lchudifyeqm4ldjj.onion/viewProduct?offe...   \n","1     http://lchudifyeqm4ldjj.onion/viewProduct?offe...   \n","2     http://lchudifyeqm4ldjj.onion/viewProduct?offe...   \n","3     http://lchudifyeqm4ldjj.onion/viewProduct?offe...   \n","4     http://lchudifyeqm4ldjj.onion/viewProduct?offe...   \n","...                                                 ...   \n","1499  http://lchudifyeqm4ldjj.onion/viewProduct?offe...   \n","1500  http://lchudifyeqm4ldjj.onion/viewProduct?offe...   \n","1501  http://lchudifyeqm4ldjj.onion/viewProduct?offe...   \n","1502  http://lchudifyeqm4ldjj.onion/viewProduct?offe...   \n","1503  http://lchudifyeqm4ldjj.onion/viewProduct?offe...   \n","\n","                                            vendor_link    vendor_name  \\\n","0     http://lchudifyeqm4ldjj.onion/contactMember?me...   Mister-Molly   \n","1     http://lchudifyeqm4ldjj.onion/contactMember?me...   Mister-Molly   \n","2     http://lchudifyeqm4ldjj.onion/contactMember?me...  0ldamsterdamm   \n","3     http://lchudifyeqm4ldjj.onion/contactMember?me...      supercoop   \n","4     http://lchudifyeqm4ldjj.onion/contactMember?me...      supercoop   \n","...                                                 ...            ...   \n","1499  http://lchudifyeqm4ldjj.onion/contactMember?me...       Depanage   \n","1500  http://lchudifyeqm4ldjj.onion/contactMember?me...       Depanage   \n","1501  http://lchudifyeqm4ldjj.onion/contactMember?me...       Depanage   \n","1502  http://lchudifyeqm4ldjj.onion/contactMember?me...       Depanage   \n","1503  http://lchudifyeqm4ldjj.onion/contactMember?me...       Depanage   \n","\n","      successful_transactions  rating  Unnamed: 0_y  distance  \n","0                          90    4.63            43         0  \n","1                          90    4.63            43         0  \n","2                         620    4.94            43         0  \n","3                         720    4.96            43         0  \n","4                         720    4.96            43         0  \n","...                       ...     ...           ...       ...  \n","1499                      160    4.90            26         0  \n","1500                      160    4.90            26         0  \n","1501                      160    4.90            26         0  \n","1502                      160    4.90            26         0  \n","1503                      160    4.90            26         0  \n","\n","[1504 rows x 16 columns]"],"text/html":["\n","\n","  <div id=\"df-03232fc7-6f3e-438e-912f-73ee9c2376c7\">\n","    <div class=\"colab-df-container\">\n","      <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>Unnamed: 0_x</th>\n","      <th>product_title</th>\n","      <th>ships_from_to</th>\n","      <th>grams</th>\n","      <th>quality</th>\n","      <th>btc_price</th>\n","      <th>cost_per_gram</th>\n","      <th>cost_per_gram_pure</th>\n","      <th>escrow</th>\n","      <th>product_link</th>\n","      <th>vendor_link</th>\n","      <th>vendor_name</th>\n","      <th>successful_transactions</th>\n","      <th>rating</th>\n","      <th>Unnamed: 0_y</th>\n","      <th>distance</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>10</td>\n","      <td>!!!!!INTRO OFFER!!!!! 1GR COCAINE 90%</td>\n","      <td>NL  → EU</td>\n","      <td>1.0</td>\n","      <td>90.0</td>\n","      <td>0.02577</td>\n","      <td>0.025770</td>\n","      <td>0.028633</td>\n","      <td>1</td>\n","      <td>http://lchudifyeqm4ldjj.onion/viewProduct?offe...</td>\n","      <td>http://lchudifyeqm4ldjj.onion/contactMember?me...</td>\n","      <td>Mister-Molly</td>\n","      <td>90</td>\n","      <td>4.63</td>\n","      <td>43</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>11</td>\n","      <td>!!!!!INTRO OFFER!!!!! 2GR COCAINE 90%</td>\n","      <td>NL  → EU</td>\n","      <td>2.0</td>\n","      <td>90.0</td>\n","      <td>0.05150</td>\n","      <td>0.025750</td>\n","      <td>0.028611</td>\n","      <td>1</td>\n","      <td>http://lchudifyeqm4ldjj.onion/viewProduct?offe...</td>\n","      <td>http://lchudifyeqm4ldjj.onion/contactMember?me...</td>\n","      <td>Mister-Molly</td>\n","      <td>90</td>\n","      <td>4.63</td>\n","      <td>43</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>14</td>\n","      <td>!!!INTRO!!! 0.5G COCAINE 89% - STRAIGHT FROM T...</td>\n","      <td>NL  → EU</td>\n","      <td>0.5</td>\n","      <td>89.0</td>\n","      <td>0.01649</td>\n","      <td>0.032980</td>\n","      <td>0.037056</td>\n","      <td>1</td>\n","      <td>http://lchudifyeqm4ldjj.onion/viewProduct?offe...</td>\n","      <td>http://lchudifyeqm4ldjj.onion/contactMember?me...</td>\n","      <td>0ldamsterdamm</td>\n","      <td>620</td>\n","      <td>4.94</td>\n","      <td>43</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>239</td>\n","      <td>0,2g SAMPLE Cocaine 90%+ Pure Flakes Uncut Col...</td>\n","      <td>NL  → EU</td>\n","      <td>2.0</td>\n","      <td>90.0</td>\n","      <td>0.00773</td>\n","      <td>0.003865</td>\n","      <td>0.004294</td>\n","      <td>1</td>\n","      <td>http://lchudifyeqm4ldjj.onion/viewProduct?offe...</td>\n","      <td>http://lchudifyeqm4ldjj.onion/contactMember?me...</td>\n","      <td>supercoop</td>\n","      <td>720</td>\n","      <td>4.96</td>\n","      <td>43</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>256</td>\n","      <td>0,5g Cocaine 90%+ Pure Flakes Uncut Colombian</td>\n","      <td>NL  → EU</td>\n","      <td>5.0</td>\n","      <td>90.0</td>\n","      <td>0.01597</td>\n","      <td>0.003194</td>\n","      <td>0.003549</td>\n","      <td>1</td>\n","      <td>http://lchudifyeqm4ldjj.onion/viewProduct?offe...</td>\n","      <td>http://lchudifyeqm4ldjj.onion/contactMember?me...</td>\n","      <td>supercoop</td>\n","      <td>720</td>\n","      <td>4.96</td>\n","      <td>43</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>1499</th>\n","      <td>3951</td>\n","      <td>Quality cocaine 0,5 gram 80%</td>\n","      <td>EU  → EU, US</td>\n","      <td>5.0</td>\n","      <td>80.0</td>\n","      <td>0.01649</td>\n","      <td>0.003298</td>\n","      <td>0.004123</td>\n","      <td>1</td>\n","      <td>http://lchudifyeqm4ldjj.onion/viewProduct?offe...</td>\n","      <td>http://lchudifyeqm4ldjj.onion/contactMember?me...</td>\n","      <td>Depanage</td>\n","      <td>160</td>\n","      <td>4.90</td>\n","      <td>26</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>1500</th>\n","      <td>3952</td>\n","      <td>Quality cocaine 1 gram 80%</td>\n","      <td>EU  → EU, US</td>\n","      <td>1.0</td>\n","      <td>80.0</td>\n","      <td>0.02577</td>\n","      <td>0.025770</td>\n","      <td>0.032212</td>\n","      <td>1</td>\n","      <td>http://lchudifyeqm4ldjj.onion/viewProduct?offe...</td>\n","      <td>http://lchudifyeqm4ldjj.onion/contactMember?me...</td>\n","      <td>Depanage</td>\n","      <td>160</td>\n","      <td>4.90</td>\n","      <td>26</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>1501</th>\n","      <td>3953</td>\n","      <td>Quality cocaine 2 gram 80%</td>\n","      <td>EU  → EU, US</td>\n","      <td>2.0</td>\n","      <td>80.0</td>\n","      <td>0.05100</td>\n","      <td>0.025500</td>\n","      <td>0.031875</td>\n","      <td>1</td>\n","      <td>http://lchudifyeqm4ldjj.onion/viewProduct?offe...</td>\n","      <td>http://lchudifyeqm4ldjj.onion/contactMember?me...</td>\n","      <td>Depanage</td>\n","      <td>160</td>\n","      <td>4.90</td>\n","      <td>26</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>1502</th>\n","      <td>3954</td>\n","      <td>Quality cocaine 3 gram 80%</td>\n","      <td>EU  → EU, US</td>\n","      <td>3.0</td>\n","      <td>80.0</td>\n","      <td>0.07470</td>\n","      <td>0.024900</td>\n","      <td>0.031125</td>\n","      <td>1</td>\n","      <td>http://lchudifyeqm4ldjj.onion/viewProduct?offe...</td>\n","      <td>http://lchudifyeqm4ldjj.onion/contactMember?me...</td>\n","      <td>Depanage</td>\n","      <td>160</td>\n","      <td>4.90</td>\n","      <td>26</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>1503</th>\n","      <td>3955</td>\n","      <td>Quality cocaine 5 gram 80%</td>\n","      <td>EU  → EU, US</td>\n","      <td>5.0</td>\n","      <td>80.0</td>\n","      <td>0.12360</td>\n","      <td>0.024720</td>\n","      <td>0.030900</td>\n","      <td>1</td>\n","      <td>http://lchudifyeqm4ldjj.onion/viewProduct?offe...</td>\n","      <td>http://lchudifyeqm4ldjj.onion/contactMember?me...</td>\n","      <td>Depanage</td>\n","      <td>160</td>\n","      <td>4.90</td>\n","      <td>26</td>\n","      <td>0</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>1504 rows × 16 columns</p>\n","</div>\n","      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-03232fc7-6f3e-438e-912f-73ee9c2376c7')\"\n","              title=\"Convert this dataframe to an interactive table.\"\n","              style=\"display:none;\">\n","\n","  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n","       width=\"24px\">\n","    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n","    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n","  </svg>\n","      </button>\n","\n","\n","\n","    <div id=\"df-3cce144f-c573-4d05-92fa-d1152c1c41e4\">\n","      <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-3cce144f-c573-4d05-92fa-d1152c1c41e4')\"\n","              title=\"Suggest charts.\"\n","              style=\"display:none;\">\n","\n","<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n","     width=\"24px\">\n","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","      </button>\n","    </div>\n","\n","<style>\n","  .colab-df-quickchart {\n","    background-color: #E8F0FE;\n","    border: none;\n","    border-radius: 50%;\n","    cursor: pointer;\n","    display: none;\n","    fill: #1967D2;\n","    height: 32px;\n","    padding: 0 0 0 0;\n","    width: 32px;\n","  }\n","\n","  .colab-df-quickchart:hover {\n","    background-color: #E2EBFA;\n","    box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n","    fill: #174EA6;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart {\n","    background-color: #3B4455;\n","    fill: #D2E3FC;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart:hover {\n","    background-color: #434B5C;\n","    box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n","    filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n","    fill: #FFFFFF;\n","  }\n","</style>\n","\n","    <script>\n","      async function quickchart(key) {\n","        const containerElement = document.querySelector('#' + key);\n","        const charts = await google.colab.kernel.invokeFunction(\n","            'suggestCharts', [key], {});\n","      }\n","    </script>\n","\n","      <script>\n","\n","function displayQuickchartButton(domScope) {\n","  let quickchartButtonEl =\n","    domScope.querySelector('#df-3cce144f-c573-4d05-92fa-d1152c1c41e4 button.colab-df-quickchart');\n","  quickchartButtonEl.style.display =\n","    google.colab.kernel.accessAllowed ? 'block' : 'none';\n","}\n","\n","        displayQuickchartButton(document);\n","      </script>\n","      <style>\n","    .colab-df-container {\n","      display:flex;\n","      flex-wrap:wrap;\n","      gap: 12px;\n","    }\n","\n","    .colab-df-convert {\n","      background-color: #E8F0FE;\n","      border: none;\n","      border-radius: 50%;\n","      cursor: pointer;\n","      display: none;\n","      fill: #1967D2;\n","      height: 32px;\n","      padding: 0 0 0 0;\n","      width: 32px;\n","    }\n","\n","    .colab-df-convert:hover {\n","      background-color: #E2EBFA;\n","      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n","      fill: #174EA6;\n","    }\n","\n","    [theme=dark] .colab-df-convert {\n","      background-color: #3B4455;\n","      fill: #D2E3FC;\n","    }\n","\n","    [theme=dark] .colab-df-convert:hover {\n","      background-color: #434B5C;\n","      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n","      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n","      fill: #FFFFFF;\n","    }\n","  </style>\n","\n","      <script>\n","        const buttonEl =\n","          document.querySelector('#df-03232fc7-6f3e-438e-912f-73ee9c2376c7 button.colab-df-convert');\n","        buttonEl.style.display =\n","          google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n","        async function convertToInteractive(key) {\n","          const element = document.querySelector('#df-03232fc7-6f3e-438e-912f-73ee9c2376c7');\n","          const dataTable =\n","            await google.colab.kernel.invokeFunction('convertToInteractive',\n","                                                     [key], {});\n","          if (!dataTable) return;\n","\n","          const docLinkHtml = 'Like what you see? Visit the ' +\n","            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n","            + ' to learn more about interactive tables.';\n","          element.innerHTML = '';\n","          dataTable['output_type'] = 'display_data';\n","          await google.colab.output.renderOutput(dataTable, element);\n","          const docLink = document.createElement('div');\n","          docLink.innerHTML = docLinkHtml;\n","          element.appendChild(docLink);\n","        }\n","      </script>\n","    </div>\n","  </div>\n"]},"metadata":{},"execution_count":19}]},{"cell_type":"code","source":["ts = df.copy()\n","ts['carbon_footprint_transportation'] = 20 * ts['distance'] * 0.0000103 * ts['successful_transactions']\n","ts.head()"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":1000},"id":"AHAjuQ0msOc2","executionInfo":{"status":"ok","timestamp":1689243446723,"user_tz":-540,"elapsed":341,"user":{"displayName":"김준희","userId":"08405862139210390425"}},"outputId":"8fe2e829-4b17-4eab-a88d-e48ab9d29f01"},"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":["      Unnamed: 0_x                                      product_title  \\\n","0               10              !!!!!INTRO OFFER!!!!! 1GR COCAINE 90%   \n","1               11              !!!!!INTRO OFFER!!!!! 2GR COCAINE 90%   \n","2               14  !!!INTRO!!! 0.5G COCAINE 89% - STRAIGHT FROM T...   \n","3              239  0,2g SAMPLE Cocaine 90%+ Pure Flakes Uncut Col...   \n","4              256      0,5g Cocaine 90%+ Pure Flakes Uncut Colombian   \n","...            ...                                                ...   \n","1499          3951                       Quality cocaine 0,5 gram 80%   \n","1500          3952                         Quality cocaine 1 gram 80%   \n","1501          3953                         Quality cocaine 2 gram 80%   \n","1502          3954                         Quality cocaine 3 gram 80%   \n","1503          3955                         Quality cocaine 5 gram 80%   \n","\n","     ships_from_to  grams  quality  btc_price  cost_per_gram  \\\n","0         NL  → EU    1.0     90.0    0.02577       0.025770   \n","1         NL  → EU    2.0     90.0    0.05150       0.025750   \n","2         NL  → EU    0.5     89.0    0.01649       0.032980   \n","3         NL  → EU    2.0     90.0    0.00773       0.003865   \n","4         NL  → EU    5.0     90.0    0.01597       0.003194   \n","...            ...    ...      ...        ...            ...   \n","1499  EU  → EU, US    5.0     80.0    0.01649       0.003298   \n","1500  EU  → EU, US    1.0     80.0    0.02577       0.025770   \n","1501  EU  → EU, US    2.0     80.0    0.05100       0.025500   \n","1502  EU  → EU, US    3.0     80.0    0.07470       0.024900   \n","1503  EU  → EU, US    5.0     80.0    0.12360       0.024720   \n","\n","      cost_per_gram_pure  escrow  \\\n","0               0.028633       1   \n","1               0.028611       1   \n","2               0.037056       1   \n","3               0.004294       1   \n","4               0.003549       1   \n","...                  ...     ...   \n","1499            0.004123       1   \n","1500            0.032212       1   \n","1501            0.031875       1   \n","1502            0.031125       1   \n","1503            0.030900       1   \n","\n","                                           product_link  \\\n","0     http://lchudifyeqm4ldjj.onion/viewProduct?offe...   \n","1     http://lchudifyeqm4ldjj.onion/viewProduct?offe...   \n","2     http://lchudifyeqm4ldjj.onion/viewProduct?offe...   \n","3     http://lchudifyeqm4ldjj.onion/viewProduct?offe...   \n","4     http://lchudifyeqm4ldjj.onion/viewProduct?offe...   \n","...                                                 ...   \n","1499  http://lchudifyeqm4ldjj.onion/viewProduct?offe...   \n","1500  http://lchudifyeqm4ldjj.onion/viewProduct?offe...   \n","1501  http://lchudifyeqm4ldjj.onion/viewProduct?offe...   \n","1502  http://lchudifyeqm4ldjj.onion/viewProduct?offe...   \n","1503  http://lchudifyeqm4ldjj.onion/viewProduct?offe...   \n","\n","                                            vendor_link    vendor_name  \\\n","0     http://lchudifyeqm4ldjj.onion/contactMember?me...   Mister-Molly   \n","1     http://lchudifyeqm4ldjj.onion/contactMember?me...   Mister-Molly   \n","2     http://lchudifyeqm4ldjj.onion/contactMember?me...  0ldamsterdamm   \n","3     http://lchudifyeqm4ldjj.onion/contactMember?me...      supercoop   \n","4     http://lchudifyeqm4ldjj.onion/contactMember?me...      supercoop   \n","...                                                 ...            ...   \n","1499  http://lchudifyeqm4ldjj.onion/contactMember?me...       Depanage   \n","1500  http://lchudifyeqm4ldjj.onion/contactMember?me...       Depanage   \n","1501  http://lchudifyeqm4ldjj.onion/contactMember?me...       Depanage   \n","1502  http://lchudifyeqm4ldjj.onion/contactMember?me...       Depanage   \n","1503  http://lchudifyeqm4ldjj.onion/contactMember?me...       Depanage   \n","\n","      successful_transactions  rating  Unnamed: 0_y  distance  \\\n","0                          90    4.63            43         0   \n","1                          90    4.63            43         0   \n","2                         620    4.94            43         0   \n","3                         720    4.96            43         0   \n","4                         720    4.96            43         0   \n","...                       ...     ...           ...       ...   \n","1499                      160    4.90            26         0   \n","1500                      160    4.90            26         0   \n","1501                      160    4.90            26         0   \n","1502                      160    4.90            26         0   \n","1503                      160    4.90            26         0   \n","\n","      carbon_footprint_transportation  \n","0                                 0.0  \n","1                                 0.0  \n","2                                 0.0  \n","3                                 0.0  \n","4                                 0.0  \n","...                               ...  \n","1499                              0.0  \n","1500                              0.0  \n","1501                              0.0  \n","1502                              0.0  \n","1503                              0.0  \n","\n","[1504 rows x 17 columns]"],"text/html":["\n","\n","  <div id=\"df-d8ec3375-29d8-4de0-9b8d-a6d8fd056d10\">\n","    <div class=\"colab-df-container\">\n","      <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>Unnamed: 0_x</th>\n","      <th>product_title</th>\n","      <th>ships_from_to</th>\n","      <th>grams</th>\n","      <th>quality</th>\n","      <th>btc_price</th>\n","      <th>cost_per_gram</th>\n","      <th>cost_per_gram_pure</th>\n","      <th>escrow</th>\n","      <th>product_link</th>\n","      <th>vendor_link</th>\n","      <th>vendor_name</th>\n","      <th>successful_transactions</th>\n","      <th>rating</th>\n","      <th>Unnamed: 0_y</th>\n","      <th>distance</th>\n","      <th>carbon_footprint_transportation</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>10</td>\n","      <td>!!!!!INTRO OFFER!!!!! 1GR COCAINE 90%</td>\n","      <td>NL  → EU</td>\n","      <td>1.0</td>\n","      <td>90.0</td>\n","      <td>0.02577</td>\n","      <td>0.025770</td>\n","      <td>0.028633</td>\n","      <td>1</td>\n","      <td>http://lchudifyeqm4ldjj.onion/viewProduct?offe...</td>\n","      <td>http://lchudifyeqm4ldjj.onion/contactMember?me...</td>\n","      <td>Mister-Molly</td>\n","      <td>90</td>\n","      <td>4.63</td>\n","      <td>43</td>\n","      <td>0</td>\n","      <td>0.0</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>11</td>\n","      <td>!!!!!INTRO OFFER!!!!! 2GR COCAINE 90%</td>\n","      <td>NL  → EU</td>\n","      <td>2.0</td>\n","      <td>90.0</td>\n","      <td>0.05150</td>\n","      <td>0.025750</td>\n","      <td>0.028611</td>\n","      <td>1</td>\n","      <td>http://lchudifyeqm4ldjj.onion/viewProduct?offe...</td>\n","      <td>http://lchudifyeqm4ldjj.onion/contactMember?me...</td>\n","      <td>Mister-Molly</td>\n","      <td>90</td>\n","      <td>4.63</td>\n","      <td>43</td>\n","      <td>0</td>\n","      <td>0.0</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>14</td>\n","      <td>!!!INTRO!!! 0.5G COCAINE 89% - STRAIGHT FROM T...</td>\n","      <td>NL  → EU</td>\n","      <td>0.5</td>\n","      <td>89.0</td>\n","      <td>0.01649</td>\n","      <td>0.032980</td>\n","      <td>0.037056</td>\n","      <td>1</td>\n","      <td>http://lchudifyeqm4ldjj.onion/viewProduct?offe...</td>\n","      <td>http://lchudifyeqm4ldjj.onion/contactMember?me...</td>\n","      <td>0ldamsterdamm</td>\n","      <td>620</td>\n","      <td>4.94</td>\n","      <td>43</td>\n","      <td>0</td>\n","      <td>0.0</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>239</td>\n","      <td>0,2g SAMPLE Cocaine 90%+ Pure Flakes Uncut Col...</td>\n","      <td>NL  → EU</td>\n","      <td>2.0</td>\n","      <td>90.0</td>\n","      <td>0.00773</td>\n","      <td>0.003865</td>\n","      <td>0.004294</td>\n","      <td>1</td>\n","      <td>http://lchudifyeqm4ldjj.onion/viewProduct?offe...</td>\n","      <td>http://lchudifyeqm4ldjj.onion/contactMember?me...</td>\n","      <td>supercoop</td>\n","      <td>720</td>\n","      <td>4.96</td>\n","      <td>43</td>\n","      <td>0</td>\n","      <td>0.0</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>256</td>\n","      <td>0,5g Cocaine 90%+ Pure Flakes Uncut Colombian</td>\n","      <td>NL  → EU</td>\n","      <td>5.0</td>\n","      <td>90.0</td>\n","      <td>0.01597</td>\n","      <td>0.003194</td>\n","      <td>0.003549</td>\n","      <td>1</td>\n","      <td>http://lchudifyeqm4ldjj.onion/viewProduct?offe...</td>\n","      <td>http://lchudifyeqm4ldjj.onion/contactMember?me...</td>\n","      <td>supercoop</td>\n","      <td>720</td>\n","      <td>4.96</td>\n","      <td>43</td>\n","      <td>0</td>\n","      <td>0.0</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>1499</th>\n","      <td>3951</td>\n","      <td>Quality cocaine 0,5 gram 80%</td>\n","      <td>EU  → EU, US</td>\n","      <td>5.0</td>\n","      <td>80.0</td>\n","      <td>0.01649</td>\n","      <td>0.003298</td>\n","      <td>0.004123</td>\n","      <td>1</td>\n","      <td>http://lchudifyeqm4ldjj.onion/viewProduct?offe...</td>\n","      <td>http://lchudifyeqm4ldjj.onion/contactMember?me...</td>\n","      <td>Depanage</td>\n","      <td>160</td>\n","      <td>4.90</td>\n","      <td>26</td>\n","      <td>0</td>\n","      <td>0.0</td>\n","    </tr>\n","    <tr>\n","      <th>1500</th>\n","      <td>3952</td>\n","      <td>Quality cocaine 1 gram 80%</td>\n","      <td>EU  → EU, US</td>\n","      <td>1.0</td>\n","      <td>80.0</td>\n","      <td>0.02577</td>\n","      <td>0.025770</td>\n","      <td>0.032212</td>\n","      <td>1</td>\n","      <td>http://lchudifyeqm4ldjj.onion/viewProduct?offe...</td>\n","      <td>http://lchudifyeqm4ldjj.onion/contactMember?me...</td>\n","      <td>Depanage</td>\n","      <td>160</td>\n","      <td>4.90</td>\n","      <td>26</td>\n","      <td>0</td>\n","      <td>0.0</td>\n","    </tr>\n","    <tr>\n","      <th>1501</th>\n","      <td>3953</td>\n","      <td>Quality cocaine 2 gram 80%</td>\n","      <td>EU  → EU, US</td>\n","      <td>2.0</td>\n","      <td>80.0</td>\n","      <td>0.05100</td>\n","      <td>0.025500</td>\n","      <td>0.031875</td>\n","      <td>1</td>\n","      <td>http://lchudifyeqm4ldjj.onion/viewProduct?offe...</td>\n","      <td>http://lchudifyeqm4ldjj.onion/contactMember?me...</td>\n","      <td>Depanage</td>\n","      <td>160</td>\n","      <td>4.90</td>\n","      <td>26</td>\n","      <td>0</td>\n","      <td>0.0</td>\n","    </tr>\n","    <tr>\n","      <th>1502</th>\n","      <td>3954</td>\n","      <td>Quality cocaine 3 gram 80%</td>\n","      <td>EU  → EU, US</td>\n","      <td>3.0</td>\n","      <td>80.0</td>\n","      <td>0.07470</td>\n","      <td>0.024900</td>\n","      <td>0.031125</td>\n","      <td>1</td>\n","      <td>http://lchudifyeqm4ldjj.onion/viewProduct?offe...</td>\n","      <td>http://lchudifyeqm4ldjj.onion/contactMember?me...</td>\n","      <td>Depanage</td>\n","      <td>160</td>\n","      <td>4.90</td>\n","      <td>26</td>\n","      <td>0</td>\n","      <td>0.0</td>\n","    </tr>\n","    <tr>\n","      <th>1503</th>\n","      <td>3955</td>\n","      <td>Quality cocaine 5 gram 80%</td>\n","      <td>EU  → EU, US</td>\n","      <td>5.0</td>\n","      <td>80.0</td>\n","      <td>0.12360</td>\n","      <td>0.024720</td>\n","      <td>0.030900</td>\n","      <td>1</td>\n","      <td>http://lchudifyeqm4ldjj.onion/viewProduct?offe...</td>\n","      <td>http://lchudifyeqm4ldjj.onion/contactMember?me...</td>\n","      <td>Depanage</td>\n","      <td>160</td>\n","      <td>4.90</td>\n","      <td>26</td>\n","      <td>0</td>\n","      <td>0.0</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>1504 rows × 17 columns</p>\n","</div>\n","      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-d8ec3375-29d8-4de0-9b8d-a6d8fd056d10')\"\n","              title=\"Convert this dataframe to an interactive table.\"\n","              style=\"display:none;\">\n","\n","  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n","       width=\"24px\">\n","    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n","    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n","  </svg>\n","      </button>\n","\n","\n","\n","    <div id=\"df-f7b05bba-3c5d-4264-8888-c142292b94f1\">\n","      <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-f7b05bba-3c5d-4264-8888-c142292b94f1')\"\n","              title=\"Suggest charts.\"\n","              style=\"display:none;\">\n","\n","<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n","     width=\"24px\">\n","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","      </button>\n","    </div>\n","\n","<style>\n","  .colab-df-quickchart {\n","    background-color: #E8F0FE;\n","    border: none;\n","    border-radius: 50%;\n","    cursor: pointer;\n","    display: none;\n","    fill: #1967D2;\n","    height: 32px;\n","    padding: 0 0 0 0;\n","    width: 32px;\n","  }\n","\n","  .colab-df-quickchart:hover {\n","    background-color: #E2EBFA;\n","    box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n","    fill: #174EA6;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart {\n","    background-color: #3B4455;\n","    fill: #D2E3FC;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart:hover {\n","    background-color: #434B5C;\n","    box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n","    filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n","    fill: #FFFFFF;\n","  }\n","</style>\n","\n","    <script>\n","      async function quickchart(key) {\n","        const containerElement = document.querySelector('#' + key);\n","        const charts = await google.colab.kernel.invokeFunction(\n","            'suggestCharts', [key], {});\n","      }\n","    </script>\n","\n","      <script>\n","\n","function displayQuickchartButton(domScope) {\n","  let quickchartButtonEl =\n","    domScope.querySelector('#df-f7b05bba-3c5d-4264-8888-c142292b94f1 button.colab-df-quickchart');\n","  quickchartButtonEl.style.display =\n","    google.colab.kernel.accessAllowed ? 'block' : 'none';\n","}\n","\n","        displayQuickchartButton(document);\n","      </script>\n","      <style>\n","    .colab-df-container {\n","      display:flex;\n","      flex-wrap:wrap;\n","      gap: 12px;\n","    }\n","\n","    .colab-df-convert {\n","      background-color: #E8F0FE;\n","      border: none;\n","      border-radius: 50%;\n","      cursor: pointer;\n","      display: none;\n","      fill: #1967D2;\n","      height: 32px;\n","      padding: 0 0 0 0;\n","      width: 32px;\n","    }\n","\n","    .colab-df-convert:hover {\n","      background-color: #E2EBFA;\n","      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n","      fill: #174EA6;\n","    }\n","\n","    [theme=dark] .colab-df-convert {\n","      background-color: #3B4455;\n","      fill: #D2E3FC;\n","    }\n","\n","    [theme=dark] .colab-df-convert:hover {\n","      background-color: #434B5C;\n","      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n","      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n","      fill: #FFFFFF;\n","    }\n","  </style>\n","\n","      <script>\n","        const buttonEl =\n","          document.querySelector('#df-d8ec3375-29d8-4de0-9b8d-a6d8fd056d10 button.colab-df-convert');\n","        buttonEl.style.display =\n","          google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n","        async function convertToInteractive(key) {\n","          const element = document.querySelector('#df-d8ec3375-29d8-4de0-9b8d-a6d8fd056d10');\n","          const dataTable =\n","            await google.colab.kernel.invokeFunction('convertToInteractive',\n","                                                     [key], {});\n","          if (!dataTable) return;\n","\n","          const docLinkHtml = 'Like what you see? Visit the ' +\n","            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n","            + ' to learn more about interactive tables.';\n","          element.innerHTML = '';\n","          dataTable['output_type'] = 'display_data';\n","          await google.colab.output.renderOutput(dataTable, element);\n","          const docLink = document.createElement('div');\n","          docLink.innerHTML = docLinkHtml;\n","          element.appendChild(docLink);\n","        }\n","      </script>\n","    </div>\n","  </div>\n"]},"metadata":{},"execution_count":24}]},{"cell_type":"code","source":["route = ts.groupby(['ships_from_to'], as_index = False)['carbon_footprint_transportation'].sum()\n","route"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":1000},"id":"0YtJaDRWwhM1","executionInfo":{"status":"ok","timestamp":1689243654627,"user_tz":-540,"elapsed":344,"user":{"displayName":"김준희","userId":"08405862139210390425"}},"outputId":"669a8415-ecad-42c9-fd16-c7aa793a64dd"},"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":["           ships_from_to  carbon_footprint_transportation\n","0               AU  → AU                         0.000000\n","1           AU  → AU, NZ                         0.000000\n","2               BE  → WW                         0.000000\n","3               BR  → WW                         0.000000\n","4           CA  → CA, EU                         0.000000\n","5               CA  → WW                        98.710050\n","6           CA  → WW, EU                       737.035040\n","7               CH  → CH                         0.000000\n","8               CN  → WW                         2.632268\n","9           CZ  → WW, EU                        92.129380\n","10              DE  → DE                         0.000000\n","11          DE  → DE, EU                         0.000000\n","12          DE  → DE, NL                         0.000000\n","13          DE  → DE, WW                         0.000000\n","14              DE  → EU                         0.000000\n","15          DE  → EU, DE                         0.000000\n","16          DE  → EU, GB                         0.000000\n","17          DE  → EU, WW                         0.000000\n","18              DE  → WW                     42650.638404\n","19          DE  → WW, AU                       552.776280\n","20          DE  → WW, DE                     14832.830180\n","21          DE  → WW, US                      2118.975740\n","22  ES  → EU, N. America                       774.656820\n","23          ES  → EU, WW                       357.525360\n","24              ES  → WW                       658.067000\n","25              EU  → EU                         0.000000\n","26          EU  → EU, US                         0.000000\n","27          EU  → EU, WW                         0.000000\n","28              EU  → WW                      3658.852520\n","29              FR  → EU                         0.000000\n","30          FR  → FR, EU                         0.000000\n","31          FR  → FR, WW                         0.000000\n","32              FR  → WW                      8173.192140\n","33              GB  → EU                     12558.625200\n","34          GB  → EU, WW                       367.878920\n","35              GB  → GB                         0.000000\n","36          GB  → GB, EU                     32424.086880\n","37          GB  → GB, IE                         0.000000\n","38          GB  → GB, WW                         0.000000\n","39              GB  → WW                     57580.862500\n","40          GB  → WW, EU                     39799.892160\n","41          GB  → WW, GB                     12240.046200\n","42              IT  → WW                      1476.702348\n","43              NL  → EU                         0.000000\n","44        NL  → EU, ASIA                         0.000000\n","45          NL  → EU, WW                         0.000000\n","46              NL  → WW                     39041.798976\n","47          NL  → WW, EU                     28123.151312\n","48          NL  → WW, NL                       855.487100\n","49          NL  → WW, US                      6212.152480\n","50              SE  → EU                         1.555918\n","51  US  → N. America, WW                         0.000000\n","52              US  → US                         0.000000\n","53          US  → US, WW                         0.000000\n","54              US  → WW                      2336.137850\n","55          US  → WW, EU                        39.484020\n","56              WW  → WW                      1189.785136"],"text/html":["\n","\n","  <div id=\"df-354179fa-685e-4a6e-bc68-5cc140b36b17\">\n","    <div class=\"colab-df-container\">\n","      <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>ships_from_to</th>\n","      <th>carbon_footprint_transportation</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>AU  → AU</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>AU  → AU, NZ</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>BE  → WW</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>BR  → WW</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>CA  → CA, EU</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>5</th>\n","      <td>CA  → WW</td>\n","      <td>98.710050</td>\n","    </tr>\n","    <tr>\n","      <th>6</th>\n","      <td>CA  → WW, EU</td>\n","      <td>737.035040</td>\n","    </tr>\n","    <tr>\n","      <th>7</th>\n","      <td>CH  → CH</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>8</th>\n","      <td>CN  → WW</td>\n","      <td>2.632268</td>\n","    </tr>\n","    <tr>\n","      <th>9</th>\n","      <td>CZ  → WW, EU</td>\n","      <td>92.129380</td>\n","    </tr>\n","    <tr>\n","      <th>10</th>\n","      <td>DE  → DE</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>11</th>\n","      <td>DE  → DE, EU</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>12</th>\n","      <td>DE  → DE, NL</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>13</th>\n","      <td>DE  → DE, WW</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>14</th>\n","      <td>DE  → EU</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>15</th>\n","      <td>DE  → EU, DE</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>16</th>\n","      <td>DE  → EU, GB</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>17</th>\n","      <td>DE  → EU, WW</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>18</th>\n","      <td>DE  → WW</td>\n","      <td>42650.638404</td>\n","    </tr>\n","    <tr>\n","      <th>19</th>\n","      <td>DE  → WW, AU</td>\n","      <td>552.776280</td>\n","    </tr>\n","    <tr>\n","      <th>20</th>\n","      <td>DE  → WW, DE</td>\n","      <td>14832.830180</td>\n","    </tr>\n","    <tr>\n","      <th>21</th>\n","      <td>DE  → WW, US</td>\n","      <td>2118.975740</td>\n","    </tr>\n","    <tr>\n","      <th>22</th>\n","      <td>ES  → EU, N. America</td>\n","      <td>774.656820</td>\n","    </tr>\n","    <tr>\n","      <th>23</th>\n","      <td>ES  → EU, WW</td>\n","      <td>357.525360</td>\n","    </tr>\n","    <tr>\n","      <th>24</th>\n","      <td>ES  → WW</td>\n","      <td>658.067000</td>\n","    </tr>\n","    <tr>\n","      <th>25</th>\n","      <td>EU  → EU</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>26</th>\n","      <td>EU  → EU, US</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>27</th>\n","      <td>EU  → EU, WW</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>28</th>\n","      <td>EU  → WW</td>\n","      <td>3658.852520</td>\n","    </tr>\n","    <tr>\n","      <th>29</th>\n","      <td>FR  → EU</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>30</th>\n","      <td>FR  → FR, EU</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>31</th>\n","      <td>FR  → FR, WW</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>32</th>\n","      <td>FR  → WW</td>\n","      <td>8173.192140</td>\n","    </tr>\n","    <tr>\n","      <th>33</th>\n","      <td>GB  → EU</td>\n","      <td>12558.625200</td>\n","    </tr>\n","    <tr>\n","      <th>34</th>\n","      <td>GB  → EU, WW</td>\n","      <td>367.878920</td>\n","    </tr>\n","    <tr>\n","      <th>35</th>\n","      <td>GB  → GB</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>36</th>\n","      <td>GB  → GB, EU</td>\n","      <td>32424.086880</td>\n","    </tr>\n","    <tr>\n","      <th>37</th>\n","      <td>GB  → GB, IE</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>38</th>\n","      <td>GB  → GB, WW</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>39</th>\n","      <td>GB  → WW</td>\n","      <td>57580.862500</td>\n","    </tr>\n","    <tr>\n","      <th>40</th>\n","      <td>GB  → WW, EU</td>\n","      <td>39799.892160</td>\n","    </tr>\n","    <tr>\n","      <th>41</th>\n","      <td>GB  → WW, GB</td>\n","      <td>12240.046200</td>\n","    </tr>\n","    <tr>\n","      <th>42</th>\n","      <td>IT  → WW</td>\n","      <td>1476.702348</td>\n","    </tr>\n","    <tr>\n","      <th>43</th>\n","      <td>NL  → EU</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>44</th>\n","      <td>NL  → EU, ASIA</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>45</th>\n","      <td>NL  → EU, WW</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>46</th>\n","      <td>NL  → WW</td>\n","      <td>39041.798976</td>\n","    </tr>\n","    <tr>\n","      <th>47</th>\n","      <td>NL  → WW, EU</td>\n","      <td>28123.151312</td>\n","    </tr>\n","    <tr>\n","      <th>48</th>\n","      <td>NL  → WW, NL</td>\n","      <td>855.487100</td>\n","    </tr>\n","    <tr>\n","      <th>49</th>\n","      <td>NL  → WW, US</td>\n","      <td>6212.152480</td>\n","    </tr>\n","    <tr>\n","      <th>50</th>\n","      <td>SE  → EU</td>\n","      <td>1.555918</td>\n","    </tr>\n","    <tr>\n","      <th>51</th>\n","      <td>US  → N. America, WW</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>52</th>\n","      <td>US  → US</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>53</th>\n","      <td>US  → US, WW</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>54</th>\n","      <td>US  → WW</td>\n","      <td>2336.137850</td>\n","    </tr>\n","    <tr>\n","      <th>55</th>\n","      <td>US  → WW, EU</td>\n","      <td>39.484020</td>\n","    </tr>\n","    <tr>\n","      <th>56</th>\n","      <td>WW  → WW</td>\n","      <td>1189.785136</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>\n","      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-354179fa-685e-4a6e-bc68-5cc140b36b17')\"\n","              title=\"Convert this dataframe to an interactive table.\"\n","              style=\"display:none;\">\n","\n","  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n","       width=\"24px\">\n","    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n","    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n","  </svg>\n","      </button>\n","\n","\n","\n","    <div id=\"df-d34834d4-624d-4c39-ac68-d82d7376c678\">\n","      <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-d34834d4-624d-4c39-ac68-d82d7376c678')\"\n","              title=\"Suggest charts.\"\n","              style=\"display:none;\">\n","\n","<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n","     width=\"24px\">\n","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","      </button>\n","    </div>\n","\n","<style>\n","  .colab-df-quickchart {\n","    background-color: #E8F0FE;\n","    border: none;\n","    border-radius: 50%;\n","    cursor: pointer;\n","    display: none;\n","    fill: #1967D2;\n","    height: 32px;\n","    padding: 0 0 0 0;\n","    width: 32px;\n","  }\n","\n","  .colab-df-quickchart:hover {\n","    background-color: #E2EBFA;\n","    box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n","    fill: #174EA6;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart {\n","    background-color: #3B4455;\n","    fill: #D2E3FC;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart:hover {\n","    background-color: #434B5C;\n","    box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n","    filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n","    fill: #FFFFFF;\n","  }\n","</style>\n","\n","    <script>\n","      async function quickchart(key) {\n","        const containerElement = document.querySelector('#' + key);\n","        const charts = await google.colab.kernel.invokeFunction(\n","            'suggestCharts', [key], {});\n","      }\n","    </script>\n","\n","      <script>\n","\n","function displayQuickchartButton(domScope) {\n","  let quickchartButtonEl =\n","    domScope.querySelector('#df-d34834d4-624d-4c39-ac68-d82d7376c678 button.colab-df-quickchart');\n","  quickchartButtonEl.style.display =\n","    google.colab.kernel.accessAllowed ? 'block' : 'none';\n","}\n","\n","        displayQuickchartButton(document);\n","      </script>\n","      <style>\n","    .colab-df-container {\n","      display:flex;\n","      flex-wrap:wrap;\n","      gap: 12px;\n","    }\n","\n","    .colab-df-convert {\n","      background-color: #E8F0FE;\n","      border: none;\n","      border-radius: 50%;\n","      cursor: pointer;\n","      display: none;\n","      fill: #1967D2;\n","      height: 32px;\n","      padding: 0 0 0 0;\n","      width: 32px;\n","    }\n","\n","    .colab-df-convert:hover {\n","      background-color: #E2EBFA;\n","      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n","      fill: #174EA6;\n","    }\n","\n","    [theme=dark] .colab-df-convert {\n","      background-color: #3B4455;\n","      fill: #D2E3FC;\n","    }\n","\n","    [theme=dark] .colab-df-convert:hover {\n","      background-color: #434B5C;\n","      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n","      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n","      fill: #FFFFFF;\n","    }\n","  </style>\n","\n","      <script>\n","        const buttonEl =\n","          document.querySelector('#df-354179fa-685e-4a6e-bc68-5cc140b36b17 button.colab-df-convert');\n","        buttonEl.style.display =\n","          google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n","        async function convertToInteractive(key) {\n","          const element = document.querySelector('#df-354179fa-685e-4a6e-bc68-5cc140b36b17');\n","          const dataTable =\n","            await google.colab.kernel.invokeFunction('convertToInteractive',\n","                                                     [key], {});\n","          if (!dataTable) return;\n","\n","          const docLinkHtml = 'Like what you see? Visit the ' +\n","            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n","            + ' to learn more about interactive tables.';\n","          element.innerHTML = '';\n","          dataTable['output_type'] = 'display_data';\n","          await google.colab.output.renderOutput(dataTable, element);\n","          const docLink = document.createElement('div');\n","          docLink.innerHTML = docLinkHtml;\n","          element.appendChild(docLink);\n","        }\n","      </script>\n","    </div>\n","  </div>\n"]},"metadata":{},"execution_count":28}]},{"cell_type":"code","source":["# carbon footprint from transportation (bia)\n","df = pd.read_csv(\"dream_market_cocaine_listings_edited.csv\", engine=\"python\")\n","distance_bia = pd.read_csv(\"distance_bia.csv\", engine=\"python\")\n","df = df.merge(distance_bia, how=\"outer\", on='ships_from_to')\n","\n","# distance_bia\n","ts_bia = df.copy()\n","ts_bia['carbon_footprint_transportation'] = 20 * ts_bia['distance'] * 0.0000103 * ts_bia['successful_transactions']\n","ts_bia"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":1925},"id":"92XV6XAIxXK7","executionInfo":{"status":"ok","timestamp":1689244306647,"user_tz":-540,"elapsed":430,"user":{"displayName":"김준희","userId":"08405862139210390425"}},"outputId":"4e0bcaba-02ca-49f2-dce3-67b59b9c9afa"},"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":["      Unnamed: 0_x                                      product_title  \\\n","0               10              !!!!!INTRO OFFER!!!!! 1GR COCAINE 90%   \n","1               11              !!!!!INTRO OFFER!!!!! 2GR COCAINE 90%   \n","2               14  !!!INTRO!!! 0.5G COCAINE 89% - STRAIGHT FROM T...   \n","3              239  0,2g SAMPLE Cocaine 90%+ Pure Flakes Uncut Col...   \n","4              256      0,5g Cocaine 90%+ Pure Flakes Uncut Colombian   \n","...            ...                                                ...   \n","1499          3951                       Quality cocaine 0,5 gram 80%   \n","1500          3952                         Quality cocaine 1 gram 80%   \n","1501          3953                         Quality cocaine 2 gram 80%   \n","1502          3954                         Quality cocaine 3 gram 80%   \n","1503          3955                         Quality cocaine 5 gram 80%   \n","\n","     ships_from_to  grams  quality  btc_price  cost_per_gram  \\\n","0         NL  → EU    1.0     90.0    0.02577       0.025770   \n","1         NL  → EU    2.0     90.0    0.05150       0.025750   \n","2         NL  → EU    0.5     89.0    0.01649       0.032980   \n","3         NL  → EU    2.0     90.0    0.00773       0.003865   \n","4         NL  → EU    5.0     90.0    0.01597       0.003194   \n","...            ...    ...      ...        ...            ...   \n","1499  EU  → EU, US    5.0     80.0    0.01649       0.003298   \n","1500  EU  → EU, US    1.0     80.0    0.02577       0.025770   \n","1501  EU  → EU, US    2.0     80.0    0.05100       0.025500   \n","1502  EU  → EU, US    3.0     80.0    0.07470       0.024900   \n","1503  EU  → EU, US    5.0     80.0    0.12360       0.024720   \n","\n","      cost_per_gram_pure  escrow  \\\n","0               0.028633       1   \n","1               0.028611       1   \n","2               0.037056       1   \n","3               0.004294       1   \n","4               0.003549       1   \n","...                  ...     ...   \n","1499            0.004123       1   \n","1500            0.032212       1   \n","1501            0.031875       1   \n","1502            0.031125       1   \n","1503            0.030900       1   \n","\n","                                           product_link  \\\n","0     http://lchudifyeqm4ldjj.onion/viewProduct?offe...   \n","1     http://lchudifyeqm4ldjj.onion/viewProduct?offe...   \n","2     http://lchudifyeqm4ldjj.onion/viewProduct?offe...   \n","3     http://lchudifyeqm4ldjj.onion/viewProduct?offe...   \n","4     http://lchudifyeqm4ldjj.onion/viewProduct?offe...   \n","...                                                 ...   \n","1499  http://lchudifyeqm4ldjj.onion/viewProduct?offe...   \n","1500  http://lchudifyeqm4ldjj.onion/viewProduct?offe...   \n","1501  http://lchudifyeqm4ldjj.onion/viewProduct?offe...   \n","1502  http://lchudifyeqm4ldjj.onion/viewProduct?offe...   \n","1503  http://lchudifyeqm4ldjj.onion/viewProduct?offe...   \n","\n","                                            vendor_link    vendor_name  \\\n","0     http://lchudifyeqm4ldjj.onion/contactMember?me...   Mister-Molly   \n","1     http://lchudifyeqm4ldjj.onion/contactMember?me...   Mister-Molly   \n","2     http://lchudifyeqm4ldjj.onion/contactMember?me...  0ldamsterdamm   \n","3     http://lchudifyeqm4ldjj.onion/contactMember?me...      supercoop   \n","4     http://lchudifyeqm4ldjj.onion/contactMember?me...      supercoop   \n","...                                                 ...            ...   \n","1499  http://lchudifyeqm4ldjj.onion/contactMember?me...       Depanage   \n","1500  http://lchudifyeqm4ldjj.onion/contactMember?me...       Depanage   \n","1501  http://lchudifyeqm4ldjj.onion/contactMember?me...       Depanage   \n","1502  http://lchudifyeqm4ldjj.onion/contactMember?me...       Depanage   \n","1503  http://lchudifyeqm4ldjj.onion/contactMember?me...       Depanage   \n","\n","      successful_transactions  rating  Unnamed: 0_y  distance  \\\n","0                          90    4.63            43         0   \n","1                          90    4.63            43         0   \n","2                         620    4.94            43         0   \n","3                         720    4.96            43         0   \n","4                         720    4.96            43         0   \n","...                       ...     ...           ...       ...   \n","1499                      160    4.90            26         0   \n","1500                      160    4.90            26         0   \n","1501                      160    4.90            26         0   \n","1502                      160    4.90            26         0   \n","1503                      160    4.90            26         0   \n","\n","      carbon_footprint_transportation  \n","0                                 0.0  \n","1                                 0.0  \n","2                                 0.0  \n","3                                 0.0  \n","4                                 0.0  \n","...                               ...  \n","1499                              0.0  \n","1500                              0.0  \n","1501                              0.0  \n","1502                              0.0  \n","1503                              0.0  \n","\n","[1504 rows x 17 columns]"],"text/html":["\n","\n","  <div id=\"df-e3e77470-3d2c-4b28-b315-e048bb91a939\">\n","    <div class=\"colab-df-container\">\n","      <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>Unnamed: 0_x</th>\n","      <th>product_title</th>\n","      <th>ships_from_to</th>\n","      <th>grams</th>\n","      <th>quality</th>\n","      <th>btc_price</th>\n","      <th>cost_per_gram</th>\n","      <th>cost_per_gram_pure</th>\n","      <th>escrow</th>\n","      <th>product_link</th>\n","      <th>vendor_link</th>\n","      <th>vendor_name</th>\n","      <th>successful_transactions</th>\n","      <th>rating</th>\n","      <th>Unnamed: 0_y</th>\n","      <th>distance</th>\n","      <th>carbon_footprint_transportation</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>10</td>\n","      <td>!!!!!INTRO OFFER!!!!! 1GR COCAINE 90%</td>\n","      <td>NL  → EU</td>\n","      <td>1.0</td>\n","      <td>90.0</td>\n","      <td>0.02577</td>\n","      <td>0.025770</td>\n","      <td>0.028633</td>\n","      <td>1</td>\n","      <td>http://lchudifyeqm4ldjj.onion/viewProduct?offe...</td>\n","      <td>http://lchudifyeqm4ldjj.onion/contactMember?me...</td>\n","      <td>Mister-Molly</td>\n","      <td>90</td>\n","      <td>4.63</td>\n","      <td>43</td>\n","      <td>0</td>\n","      <td>0.0</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>11</td>\n","      <td>!!!!!INTRO OFFER!!!!! 2GR COCAINE 90%</td>\n","      <td>NL  → EU</td>\n","      <td>2.0</td>\n","      <td>90.0</td>\n","      <td>0.05150</td>\n","      <td>0.025750</td>\n","      <td>0.028611</td>\n","      <td>1</td>\n","      <td>http://lchudifyeqm4ldjj.onion/viewProduct?offe...</td>\n","      <td>http://lchudifyeqm4ldjj.onion/contactMember?me...</td>\n","      <td>Mister-Molly</td>\n","      <td>90</td>\n","      <td>4.63</td>\n","      <td>43</td>\n","      <td>0</td>\n","      <td>0.0</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>14</td>\n","      <td>!!!INTRO!!! 0.5G COCAINE 89% - STRAIGHT FROM T...</td>\n","      <td>NL  → EU</td>\n","      <td>0.5</td>\n","      <td>89.0</td>\n","      <td>0.01649</td>\n","      <td>0.032980</td>\n","      <td>0.037056</td>\n","      <td>1</td>\n","      <td>http://lchudifyeqm4ldjj.onion/viewProduct?offe...</td>\n","      <td>http://lchudifyeqm4ldjj.onion/contactMember?me...</td>\n","      <td>0ldamsterdamm</td>\n","      <td>620</td>\n","      <td>4.94</td>\n","      <td>43</td>\n","      <td>0</td>\n","      <td>0.0</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>239</td>\n","      <td>0,2g SAMPLE Cocaine 90%+ Pure Flakes Uncut Col...</td>\n","      <td>NL  → EU</td>\n","      <td>2.0</td>\n","      <td>90.0</td>\n","      <td>0.00773</td>\n","      <td>0.003865</td>\n","      <td>0.004294</td>\n","      <td>1</td>\n","      <td>http://lchudifyeqm4ldjj.onion/viewProduct?offe...</td>\n","      <td>http://lchudifyeqm4ldjj.onion/contactMember?me...</td>\n","      <td>supercoop</td>\n","      <td>720</td>\n","      <td>4.96</td>\n","      <td>43</td>\n","      <td>0</td>\n","      <td>0.0</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>256</td>\n","      <td>0,5g Cocaine 90%+ Pure Flakes Uncut Colombian</td>\n","      <td>NL  → EU</td>\n","      <td>5.0</td>\n","      <td>90.0</td>\n","      <td>0.01597</td>\n","      <td>0.003194</td>\n","      <td>0.003549</td>\n","      <td>1</td>\n","      <td>http://lchudifyeqm4ldjj.onion/viewProduct?offe...</td>\n","      <td>http://lchudifyeqm4ldjj.onion/contactMember?me...</td>\n","      <td>supercoop</td>\n","      <td>720</td>\n","      <td>4.96</td>\n","      <td>43</td>\n","      <td>0</td>\n","      <td>0.0</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>1499</th>\n","      <td>3951</td>\n","      <td>Quality cocaine 0,5 gram 80%</td>\n","      <td>EU  → EU, US</td>\n","      <td>5.0</td>\n","      <td>80.0</td>\n","      <td>0.01649</td>\n","      <td>0.003298</td>\n","      <td>0.004123</td>\n","      <td>1</td>\n","      <td>http://lchudifyeqm4ldjj.onion/viewProduct?offe...</td>\n","      <td>http://lchudifyeqm4ldjj.onion/contactMember?me...</td>\n","      <td>Depanage</td>\n","      <td>160</td>\n","      <td>4.90</td>\n","      <td>26</td>\n","      <td>0</td>\n","      <td>0.0</td>\n","    </tr>\n","    <tr>\n","      <th>1500</th>\n","      <td>3952</td>\n","      <td>Quality cocaine 1 gram 80%</td>\n","      <td>EU  → EU, US</td>\n","      <td>1.0</td>\n","      <td>80.0</td>\n","      <td>0.02577</td>\n","      <td>0.025770</td>\n","      <td>0.032212</td>\n","      <td>1</td>\n","      <td>http://lchudifyeqm4ldjj.onion/viewProduct?offe...</td>\n","      <td>http://lchudifyeqm4ldjj.onion/contactMember?me...</td>\n","      <td>Depanage</td>\n","      <td>160</td>\n","      <td>4.90</td>\n","      <td>26</td>\n","      <td>0</td>\n","      <td>0.0</td>\n","    </tr>\n","    <tr>\n","      <th>1501</th>\n","      <td>3953</td>\n","      <td>Quality cocaine 2 gram 80%</td>\n","      <td>EU  → EU, US</td>\n","      <td>2.0</td>\n","      <td>80.0</td>\n","      <td>0.05100</td>\n","      <td>0.025500</td>\n","      <td>0.031875</td>\n","      <td>1</td>\n","      <td>http://lchudifyeqm4ldjj.onion/viewProduct?offe...</td>\n","      <td>http://lchudifyeqm4ldjj.onion/contactMember?me...</td>\n","      <td>Depanage</td>\n","      <td>160</td>\n","      <td>4.90</td>\n","      <td>26</td>\n","      <td>0</td>\n","      <td>0.0</td>\n","    </tr>\n","    <tr>\n","      <th>1502</th>\n","      <td>3954</td>\n","      <td>Quality cocaine 3 gram 80%</td>\n","      <td>EU  → EU, US</td>\n","      <td>3.0</td>\n","      <td>80.0</td>\n","      <td>0.07470</td>\n","      <td>0.024900</td>\n","      <td>0.031125</td>\n","      <td>1</td>\n","      <td>http://lchudifyeqm4ldjj.onion/viewProduct?offe...</td>\n","      <td>http://lchudifyeqm4ldjj.onion/contactMember?me...</td>\n","      <td>Depanage</td>\n","      <td>160</td>\n","      <td>4.90</td>\n","      <td>26</td>\n","      <td>0</td>\n","      <td>0.0</td>\n","    </tr>\n","    <tr>\n","      <th>1503</th>\n","      <td>3955</td>\n","      <td>Quality cocaine 5 gram 80%</td>\n","      <td>EU  → EU, US</td>\n","      <td>5.0</td>\n","      <td>80.0</td>\n","      <td>0.12360</td>\n","      <td>0.024720</td>\n","      <td>0.030900</td>\n","      <td>1</td>\n","      <td>http://lchudifyeqm4ldjj.onion/viewProduct?offe...</td>\n","      <td>http://lchudifyeqm4ldjj.onion/contactMember?me...</td>\n","      <td>Depanage</td>\n","      <td>160</td>\n","      <td>4.90</td>\n","      <td>26</td>\n","      <td>0</td>\n","      <td>0.0</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>1504 rows × 17 columns</p>\n","</div>\n","      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-e3e77470-3d2c-4b28-b315-e048bb91a939')\"\n","              title=\"Convert this dataframe to an interactive table.\"\n","              style=\"display:none;\">\n","\n","  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n","       width=\"24px\">\n","    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n","    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n","  </svg>\n","      </button>\n","\n","\n","\n","    <div id=\"df-fe8ffcb8-90f4-4673-9e7d-2cbfca35ba04\">\n","      <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-fe8ffcb8-90f4-4673-9e7d-2cbfca35ba04')\"\n","              title=\"Suggest charts.\"\n","              style=\"display:none;\">\n","\n","<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n","     width=\"24px\">\n","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","      </button>\n","    </div>\n","\n","<style>\n","  .colab-df-quickchart {\n","    background-color: #E8F0FE;\n","    border: none;\n","    border-radius: 50%;\n","    cursor: pointer;\n","    display: none;\n","    fill: #1967D2;\n","    height: 32px;\n","    padding: 0 0 0 0;\n","    width: 32px;\n","  }\n","\n","  .colab-df-quickchart:hover {\n","    background-color: #E2EBFA;\n","    box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n","    fill: #174EA6;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart {\n","    background-color: #3B4455;\n","    fill: #D2E3FC;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart:hover {\n","    background-color: #434B5C;\n","    box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n","    filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n","    fill: #FFFFFF;\n","  }\n","</style>\n","\n","    <script>\n","      async function quickchart(key) {\n","        const containerElement = document.querySelector('#' + key);\n","        const charts = await google.colab.kernel.invokeFunction(\n","            'suggestCharts', [key], {});\n","      }\n","    </script>\n","\n","      <script>\n","\n","function displayQuickchartButton(domScope) {\n","  let quickchartButtonEl =\n","    domScope.querySelector('#df-fe8ffcb8-90f4-4673-9e7d-2cbfca35ba04 button.colab-df-quickchart');\n","  quickchartButtonEl.style.display =\n","    google.colab.kernel.accessAllowed ? 'block' : 'none';\n","}\n","\n","        displayQuickchartButton(document);\n","      </script>\n","      <style>\n","    .colab-df-container {\n","      display:flex;\n","      flex-wrap:wrap;\n","      gap: 12px;\n","    }\n","\n","    .colab-df-convert {\n","      background-color: #E8F0FE;\n","      border: none;\n","      border-radius: 50%;\n","      cursor: pointer;\n","      display: none;\n","      fill: #1967D2;\n","      height: 32px;\n","      padding: 0 0 0 0;\n","      width: 32px;\n","    }\n","\n","    .colab-df-convert:hover {\n","      background-color: #E2EBFA;\n","      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n","      fill: #174EA6;\n","    }\n","\n","    [theme=dark] .colab-df-convert {\n","      background-color: #3B4455;\n","      fill: #D2E3FC;\n","    }\n","\n","    [theme=dark] .colab-df-convert:hover {\n","      background-color: #434B5C;\n","      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n","      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n","      fill: #FFFFFF;\n","    }\n","  </style>\n","\n","      <script>\n","        const buttonEl =\n","          document.querySelector('#df-e3e77470-3d2c-4b28-b315-e048bb91a939 button.colab-df-convert');\n","        buttonEl.style.display =\n","          google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n","        async function convertToInteractive(key) {\n","          const element = document.querySelector('#df-e3e77470-3d2c-4b28-b315-e048bb91a939');\n","          const dataTable =\n","            await google.colab.kernel.invokeFunction('convertToInteractive',\n","                                                     [key], {});\n","          if (!dataTable) return;\n","\n","          const docLinkHtml = 'Like what you see? Visit the ' +\n","            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n","            + ' to learn more about interactive tables.';\n","          element.innerHTML = '';\n","          dataTable['output_type'] = 'display_data';\n","          await google.colab.output.renderOutput(dataTable, element);\n","          const docLink = document.createElement('div');\n","          docLink.innerHTML = docLinkHtml;\n","          element.appendChild(docLink);\n","        }\n","      </script>\n","    </div>\n","  </div>\n"]},"metadata":{},"execution_count":36}]},{"cell_type":"code","source":["route_bia = ts_bia.groupby(['ships_from_to'], as_index = False)['carbon_footprint_transportation'].sum()\n","route_bia"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":1000},"id":"zTc0KDBK0QTD","executionInfo":{"status":"ok","timestamp":1689244485901,"user_tz":-540,"elapsed":315,"user":{"displayName":"김준희","userId":"08405862139210390425"}},"outputId":"910027d8-839c-44bc-e5df-bc8575b6645b"},"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":["           ships_from_to  carbon_footprint_transportation\n","0               AU  → AU                         0.000000\n","1           AU  → AU, NZ                         0.000000\n","2               BE  → WW                         0.000000\n","3               BR  → WW                         0.000000\n","4           CA  → CA, EU                         0.000000\n","5               CA  → WW                       131.031450\n","6           CA  → WW, EU                       978.368160\n","7               CH  → CH                         0.000000\n","8               CN  → WW                         3.494172\n","9           CZ  → WW, EU                       122.296020\n","10              DE  → DE                         0.000000\n","11          DE  → DE, EU                         0.000000\n","12          DE  → DE, NL                         0.000000\n","13          DE  → DE, WW                         0.000000\n","14              DE  → EU                         0.000000\n","15          DE  → EU, DE                         0.000000\n","16          DE  → EU, GB                         0.000000\n","17          DE  → EU, WW                         0.000000\n","18              DE  → WW                     56616.068916\n","19          DE  → WW, AU                       733.776120\n","20          DE  → WW, DE                     19689.659220\n","21          DE  → WW, US                      2812.808460\n","22  ES  → EU, N. America                      3283.940760\n","23          ES  → EU, WW                       419.226480\n","24              ES  → WW                       873.543000\n","25              EU  → EU                         0.000000\n","26          EU  → EU, US                         0.000000\n","27          EU  → EU, WW                         0.000000\n","28              EU  → WW                      4856.899080\n","29              FR  → EU                         0.000000\n","30          FR  → FR, EU                         0.000000\n","31          FR  → FR, WW                         0.000000\n","32              FR  → WW                     10849.404060\n","33              GB  → EU                     12558.625200\n","34          GB  → EU, WW                       367.878920\n","35              GB  → GB                         0.000000\n","36          GB  → GB, EU                     32424.086880\n","37          GB  → GB, IE                         0.000000\n","38          GB  → GB, WW                         0.000000\n","39              GB  → WW                     76435.012500\n","40          GB  → WW, EU                     52831.880640\n","41          GB  → WW, GB                     16247.899800\n","42              IT  → WW                      1960.230492\n","43              NL  → EU                         0.000000\n","44        NL  → EU, ASIA                         0.000000\n","45          NL  → EU, WW                         0.000000\n","46              NL  → WW                     51825.559104\n","47          NL  → WW, EU                     37331.733648\n","48          NL  → WW, NL                      1135.605900\n","49          NL  → WW, US                      8246.245920\n","50              SE  → EU                         2.371678\n","51  US  → N. America, WW                      1100.664180\n","52              US  → US                         0.000000\n","53          US  → US, WW                         0.000000\n","54              US  → WW                      3101.077650\n","55          US  → WW, EU                        52.412580\n","56              WW  → WW                      1579.365744"],"text/html":["\n","\n","  <div id=\"df-282de143-8aa1-4aa0-b6f6-7f785e691664\">\n","    <div class=\"colab-df-container\">\n","      <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>ships_from_to</th>\n","      <th>carbon_footprint_transportation</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>AU  → AU</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>AU  → AU, NZ</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>BE  → WW</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>BR  → WW</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>CA  → CA, EU</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>5</th>\n","      <td>CA  → WW</td>\n","      <td>131.031450</td>\n","    </tr>\n","    <tr>\n","      <th>6</th>\n","      <td>CA  → WW, EU</td>\n","      <td>978.368160</td>\n","    </tr>\n","    <tr>\n","      <th>7</th>\n","      <td>CH  → CH</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>8</th>\n","      <td>CN  → WW</td>\n","      <td>3.494172</td>\n","    </tr>\n","    <tr>\n","      <th>9</th>\n","      <td>CZ  → WW, EU</td>\n","      <td>122.296020</td>\n","    </tr>\n","    <tr>\n","      <th>10</th>\n","      <td>DE  → DE</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>11</th>\n","      <td>DE  → DE, EU</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>12</th>\n","      <td>DE  → DE, NL</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>13</th>\n","      <td>DE  → DE, WW</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>14</th>\n","      <td>DE  → EU</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>15</th>\n","      <td>DE  → EU, DE</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>16</th>\n","      <td>DE  → EU, GB</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>17</th>\n","      <td>DE  → EU, WW</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>18</th>\n","      <td>DE  → WW</td>\n","      <td>56616.068916</td>\n","    </tr>\n","    <tr>\n","      <th>19</th>\n","      <td>DE  → WW, AU</td>\n","      <td>733.776120</td>\n","    </tr>\n","    <tr>\n","      <th>20</th>\n","      <td>DE  → WW, DE</td>\n","      <td>19689.659220</td>\n","    </tr>\n","    <tr>\n","      <th>21</th>\n","      <td>DE  → WW, US</td>\n","      <td>2812.808460</td>\n","    </tr>\n","    <tr>\n","      <th>22</th>\n","      <td>ES  → EU, N. America</td>\n","      <td>3283.940760</td>\n","    </tr>\n","    <tr>\n","      <th>23</th>\n","      <td>ES  → EU, WW</td>\n","      <td>419.226480</td>\n","    </tr>\n","    <tr>\n","      <th>24</th>\n","      <td>ES  → WW</td>\n","      <td>873.543000</td>\n","    </tr>\n","    <tr>\n","      <th>25</th>\n","      <td>EU  → EU</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>26</th>\n","      <td>EU  → EU, US</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>27</th>\n","      <td>EU  → EU, WW</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>28</th>\n","      <td>EU  → WW</td>\n","      <td>4856.899080</td>\n","    </tr>\n","    <tr>\n","      <th>29</th>\n","      <td>FR  → EU</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>30</th>\n","      <td>FR  → FR, EU</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>31</th>\n","      <td>FR  → FR, WW</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>32</th>\n","      <td>FR  → WW</td>\n","      <td>10849.404060</td>\n","    </tr>\n","    <tr>\n","      <th>33</th>\n","      <td>GB  → EU</td>\n","      <td>12558.625200</td>\n","    </tr>\n","    <tr>\n","      <th>34</th>\n","      <td>GB  → EU, WW</td>\n","      <td>367.878920</td>\n","    </tr>\n","    <tr>\n","      <th>35</th>\n","      <td>GB  → GB</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>36</th>\n","      <td>GB  → GB, EU</td>\n","      <td>32424.086880</td>\n","    </tr>\n","    <tr>\n","      <th>37</th>\n","      <td>GB  → GB, IE</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>38</th>\n","      <td>GB  → GB, WW</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>39</th>\n","      <td>GB  → WW</td>\n","      <td>76435.012500</td>\n","    </tr>\n","    <tr>\n","      <th>40</th>\n","      <td>GB  → WW, EU</td>\n","      <td>52831.880640</td>\n","    </tr>\n","    <tr>\n","      <th>41</th>\n","      <td>GB  → WW, GB</td>\n","      <td>16247.899800</td>\n","    </tr>\n","    <tr>\n","      <th>42</th>\n","      <td>IT  → WW</td>\n","      <td>1960.230492</td>\n","    </tr>\n","    <tr>\n","      <th>43</th>\n","      <td>NL  → EU</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>44</th>\n","      <td>NL  → EU, ASIA</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>45</th>\n","      <td>NL  → EU, WW</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>46</th>\n","      <td>NL  → WW</td>\n","      <td>51825.559104</td>\n","    </tr>\n","    <tr>\n","      <th>47</th>\n","      <td>NL  → WW, EU</td>\n","      <td>37331.733648</td>\n","    </tr>\n","    <tr>\n","      <th>48</th>\n","      <td>NL  → WW, NL</td>\n","      <td>1135.605900</td>\n","    </tr>\n","    <tr>\n","      <th>49</th>\n","      <td>NL  → WW, US</td>\n","      <td>8246.245920</td>\n","    </tr>\n","    <tr>\n","      <th>50</th>\n","      <td>SE  → EU</td>\n","      <td>2.371678</td>\n","    </tr>\n","    <tr>\n","      <th>51</th>\n","      <td>US  → N. America, WW</td>\n","      <td>1100.664180</td>\n","    </tr>\n","    <tr>\n","      <th>52</th>\n","      <td>US  → US</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>53</th>\n","      <td>US  → US, WW</td>\n","      <td>0.000000</td>\n","    </tr>\n","    <tr>\n","      <th>54</th>\n","      <td>US  → WW</td>\n","      <td>3101.077650</td>\n","    </tr>\n","    <tr>\n","      <th>55</th>\n","      <td>US  → WW, EU</td>\n","      <td>52.412580</td>\n","    </tr>\n","    <tr>\n","      <th>56</th>\n","      <td>WW  → WW</td>\n","      <td>1579.365744</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>\n","      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-282de143-8aa1-4aa0-b6f6-7f785e691664')\"\n","              title=\"Convert this dataframe to an interactive table.\"\n","              style=\"display:none;\">\n","\n","  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n","       width=\"24px\">\n","    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n","    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n","  </svg>\n","      </button>\n","\n","\n","\n","    <div id=\"df-d3318aea-822f-4ac1-99af-5867d6c63d96\">\n","      <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-d3318aea-822f-4ac1-99af-5867d6c63d96')\"\n","              title=\"Suggest charts.\"\n","              style=\"display:none;\">\n","\n","<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n","     width=\"24px\">\n","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","      </button>\n","    </div>\n","\n","<style>\n","  .colab-df-quickchart {\n","    background-color: #E8F0FE;\n","    border: none;\n","    border-radius: 50%;\n","    cursor: pointer;\n","    display: none;\n","    fill: #1967D2;\n","    height: 32px;\n","    padding: 0 0 0 0;\n","    width: 32px;\n","  }\n","\n","  .colab-df-quickchart:hover {\n","    background-color: #E2EBFA;\n","    box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n","    fill: #174EA6;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart {\n","    background-color: #3B4455;\n","    fill: #D2E3FC;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart:hover {\n","    background-color: #434B5C;\n","    box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n","    filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n","    fill: #FFFFFF;\n","  }\n","</style>\n","\n","    <script>\n","      async function quickchart(key) {\n","        const containerElement = document.querySelector('#' + key);\n","        const charts = await google.colab.kernel.invokeFunction(\n","            'suggestCharts', [key], {});\n","      }\n","    </script>\n","\n","      <script>\n","\n","function displayQuickchartButton(domScope) {\n","  let quickchartButtonEl =\n","    domScope.querySelector('#df-d3318aea-822f-4ac1-99af-5867d6c63d96 button.colab-df-quickchart');\n","  quickchartButtonEl.style.display =\n","    google.colab.kernel.accessAllowed ? 'block' : 'none';\n","}\n","\n","        displayQuickchartButton(document);\n","      </script>\n","      <style>\n","    .colab-df-container {\n","      display:flex;\n","      flex-wrap:wrap;\n","      gap: 12px;\n","    }\n","\n","    .colab-df-convert {\n","      background-color: #E8F0FE;\n","      border: none;\n","      border-radius: 50%;\n","      cursor: pointer;\n","      display: none;\n","      fill: #1967D2;\n","      height: 32px;\n","      padding: 0 0 0 0;\n","      width: 32px;\n","    }\n","\n","    .colab-df-convert:hover {\n","      background-color: #E2EBFA;\n","      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n","      fill: #174EA6;\n","    }\n","\n","    [theme=dark] .colab-df-convert {\n","      background-color: #3B4455;\n","      fill: #D2E3FC;\n","    }\n","\n","    [theme=dark] .colab-df-convert:hover {\n","      background-color: #434B5C;\n","      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n","      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n","      fill: #FFFFFF;\n","    }\n","  </style>\n","\n","      <script>\n","        const buttonEl =\n","          document.querySelector('#df-282de143-8aa1-4aa0-b6f6-7f785e691664 button.colab-df-convert');\n","        buttonEl.style.display =\n","          google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n","        async function convertToInteractive(key) {\n","          const element = document.querySelector('#df-282de143-8aa1-4aa0-b6f6-7f785e691664');\n","          const dataTable =\n","            await google.colab.kernel.invokeFunction('convertToInteractive',\n","                                                     [key], {});\n","          if (!dataTable) return;\n","\n","          const docLinkHtml = 'Like what you see? Visit the ' +\n","            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n","            + ' to learn more about interactive tables.';\n","          element.innerHTML = '';\n","          dataTable['output_type'] = 'display_data';\n","          await google.colab.output.renderOutput(dataTable, element);\n","          const docLink = document.createElement('div');\n","          docLink.innerHTML = docLinkHtml;\n","          element.appendChild(docLink);\n","        }\n","      </script>\n","    </div>\n","  </div>\n"]},"metadata":{},"execution_count":38}]},{"cell_type":"code","source":["print(\"carbon_footprint_transportation:\", ts['carbon_footprint_transportation'].sum())\n","print(\"carbon footprint from transportation (bia):\", ts_bia['carbon_footprint_transportation'].sum())"],"metadata":{"id":"lXY1fdhHLKXx","executionInfo":{"status":"ok","timestamp":1689244430738,"user_tz":-540,"elapsed":302,"user":{"displayName":"김준희","userId":"08405862139210390425"}},"colab":{"base_uri":"https://localhost:8080/"},"outputId":"413f27c0-8c82-4b4d-e678-d465e447e01b"},"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":["carbon_footprint_transportation: 308955.66818199994\n","carbon footprint from transportation (bia): 398571.16673399997\n"]}]}],"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.9.13"},"colab":{"provenance":[]}},"nbformat":4,"nbformat_minor":0}