{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# don't run this again it will overwrite the csv" ] }, { "cell_type": "code", "execution_count": 4, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
AuthorPublication dateTitleEstimate (TWh)
0DigiconomistLive estimateBitcoin Energy Consumption Index{insert API}
1CoinMetricsJune 2023The Signal & The Nonce117.4
2De Vries, A., Gallersdorfer, U., Klaaßen, L. ...February 2022Revisiting Bitcoin's carbon footprint117.3
3CoinSharesJanuary 2022The Bitcoin Mining Network89.0
4Sandner, P., Lichti, C., Richter, R., Heidt, C...August 2021The Carbon Emissions of Bitcoin From an Invest...90.9
5Köhler, S. and Pizzol, M.November 2019Life Cycle Assessment of Bitcoin Mining31.3
6Stoll, C., Klaaßen, L. and Gallersdorfer, U.June 2019The Carbon Footprint of Bitcoin48.5
7Zade, M., Myklebost, J., Tzscheutschler, P. an...March 2019Is Bitcoin the Only Problem? A Scenario Model ...33.7
8Krause, M.J. and Tolaymat, T.November 2018Quantification of energy and carbon costs for ...30.1
9McCook, H.August 2018The cost & sustainability of Bitcoin105.0
10De Vries, A.May 2018Bitcoin's Growing Energy Problem22.4 to 67.2
11Vranken, H.October 2017Sustainability of bitcoin and blockchains0.9 to 4.4
12Bevand, M.February 2017Electricity consumption of Bitcoin: a market-b...4.1 to 4.7
13Hayes, A.S.March 2015A Cost Production Model for BitcoinNaN
14O'Dwyer, K.L. and Malone, D.September 2014Bitcoin Mining and its Energy Footprint0.9 to 87.6
\n", "
" ], "text/plain": [ " Author Publication date \\\n", "0 Digiconomist Live estimate \n", "1 CoinMetrics June 2023 \n", "2 De Vries, A., Gallersdorfer, U., Klaaßen, L. ... February 2022 \n", "3 CoinShares January 2022 \n", "4 Sandner, P., Lichti, C., Richter, R., Heidt, C... August 2021 \n", "5 Köhler, S. and Pizzol, M. November 2019 \n", "6 Stoll, C., Klaaßen, L. and Gallersdorfer, U. June 2019 \n", "7 Zade, M., Myklebost, J., Tzscheutschler, P. an... March 2019 \n", "8 Krause, M.J. and Tolaymat, T. November 2018 \n", "9 McCook, H. August 2018 \n", "10 De Vries, A. May 2018 \n", "11 Vranken, H. October 2017 \n", "12 Bevand, M. February 2017 \n", "13 Hayes, A.S. March 2015 \n", "14 O'Dwyer, K.L. and Malone, D. September 2014 \n", "\n", " Title Estimate (TWh) \n", "0 Bitcoin Energy Consumption Index {insert API} \n", "1 The Signal & The Nonce 117.4 \n", "2 Revisiting Bitcoin's carbon footprint 117.3 \n", "3 The Bitcoin Mining Network 89.0 \n", "4 The Carbon Emissions of Bitcoin From an Invest... 90.9 \n", "5 Life Cycle Assessment of Bitcoin Mining 31.3 \n", "6 The Carbon Footprint of Bitcoin 48.5 \n", "7 Is Bitcoin the Only Problem? A Scenario Model ... 33.7 \n", "8 Quantification of energy and carbon costs for ... 30.1 \n", "9 The cost & sustainability of Bitcoin 105.0 \n", "10 Bitcoin's Growing Energy Problem 22.4 to 67.2 \n", "11 Sustainability of bitcoin and blockchains 0.9 to 4.4 \n", "12 Electricity consumption of Bitcoin: a market-b... 4.1 to 4.7 \n", "13 A Cost Production Model for Bitcoin NaN \n", "14 Bitcoin Mining and its Energy Footprint 0.9 to 87.6 " ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "source": [ "import pandas as pd\n", "\n", "intensity_file = \"table.html\"\n", "# read the html file using the first row as header\n", "dfs = pd.read_html(intensity_file, header=0)\n", "\n", "# Access the second table (index 1)\n", "df = dfs[0]\n", "df.to_csv(\"table.csv\", index=False)\n", "df" ] } ], "metadata": { "kernelspec": { "display_name": "py310", "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.10.13" } }, "nbformat": 4, "nbformat_minor": 2 }