carbon_footprint_bitcoin.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":1689245806521,"user_tz":-540,"elapsed":8,"user":{"displayName":"김준희","userId":"08405862139210390425"}},"colab":{"base_uri":"https://localhost:8080/","height":495},"outputId":"dcbaa5fd-5292-4eb7-ed7a-3cd396688ea2"},"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-678ab09a-94d0-493b-bc94-8e87d41829e1\">\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-678ab09a-94d0-493b-bc94-8e87d41829e1')\"\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-fc0333bf-e1da-4260-afac-bc95e09358b8\">\n","      <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-fc0333bf-e1da-4260-afac-bc95e09358b8')\"\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-fc0333bf-e1da-4260-afac-bc95e09358b8 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-678ab09a-94d0-493b-bc94-8e87d41829e1 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-678ab09a-94d0-493b-bc94-8e87d41829e1');\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":5}]},{"cell_type":"code","source":["bit = df.copy()\n","bit['carbon_footprint_bitcoin'] =  bit['btc_price'] * bit['successful_transactions']\n","bit.head()"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":495},"id":"AHAjuQ0msOc2","executionInfo":{"status":"ok","timestamp":1689245806521,"user_tz":-540,"elapsed":6,"user":{"displayName":"김준희","userId":"08405862139210390425"}},"outputId":"1a626d44-78f6-4b65-82a9-3edd5b75ce18"},"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  carbon_footprint_bitcoin  \n","0                       90    4.63                    2.3193  \n","1                       90    4.63                    4.6350  \n","2                      620    4.94                   10.2238  \n","3                       15    5.00                    0.6180  \n","4                       28    4.78                    0.9520  "],"text/html":["\n","\n","  <div id=\"df-db69c72d-f7a5-4934-99d3-09d3efabe486\">\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","      <th>carbon_footprint_bitcoin</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","      <td>2.3193</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","      <td>4.6350</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","      <td>10.2238</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","      <td>0.6180</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","      <td>0.9520</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>\n","      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-db69c72d-f7a5-4934-99d3-09d3efabe486')\"\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-1895b8a4-7908-4b51-95dc-9e55cf2db55b\">\n","      <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-1895b8a4-7908-4b51-95dc-9e55cf2db55b')\"\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-1895b8a4-7908-4b51-95dc-9e55cf2db55b 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-db69c72d-f7a5-4934-99d3-09d3efabe486 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-db69c72d-f7a5-4934-99d3-09d3efabe486');\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":6}]},{"cell_type":"code","source":["print(\"carbon_footprint_bitcoin(kg):\", bit['carbon_footprint_bitcoin'].sum() * 113000,\"\\n\")\n","\n","print(\"carbon_footprint_total(t)\", int((63587804701.5117 + 398571.16673399997) * 0.001),\"\\n\")\n","\n","print(\"Percentage of 2021 global emissions\", 63588203/36300000000*100,\"%\\n\")\n","print(\"Percentage of 2021 korea emissions\", 63588203/679600000*100,\"%\\n\")"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"0YtJaDRWwhM1","executionInfo":{"status":"ok","timestamp":1689247805996,"user_tz":-540,"elapsed":382,"user":{"displayName":"김준희","userId":"08405862139210390425"}},"outputId":"a13fc626-02ca-427b-e529-3f80236862e0"},"execution_count":27,"outputs":[{"output_type":"stream","name":"stdout","text":["carbon_footprint_bitcoin(kg): 63587804701.5117 \n","\n","carbon_footprint_total(t) 63588203 \n","\n","Percentage of 2021 global emissions 0.1751741129476584 %\n","\n","Percentage of 2021 korea emissions 9.356710270747499 %\n","\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":[{"file_id":"1aBraRNgdqd8zv7kFG1xl1Orh4hWmPOO6","timestamp":1689245647840}]}},"nbformat":4,"nbformat_minor":0}