Day 2 Intro to pandas.ipynb

{
 "metadata": {
  "name": "",
  "signature": "sha256:84932d91b967ff7211cccbba9e6f5f3335024c027fc88270ebc27de5f5f97aed"
 },
 "nbformat": 3,
 "nbformat_minor": 0,
 "worksheets": [
  {
   "cells": [
    {
     "cell_type": "markdown",
     "metadata": {},
     "source": [
      "### pandas\n",
      "\n",
      "- ####read csv data and pickled data\n",
      "    - WRI csv data\n",
      "    - pickled CDP data\n",
      "- ####dataframes\n",
      "    - http://pandas.pydata.org/pandas-docs/stable/basics.html\n",
      "    - series is one column\n",
      "- ####select data\n",
      "    - http://pandas.pydata.org/pandas-docs/stable/indexing.html\n",
      "    - get rows\n",
      "    - columns\n",
      "    - isin\n",
      "- ####python modules\n",
      "    - functions\n",
      "- ####pickle"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "import csv\n",
      "import pandas as pd"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 2
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "dict_reader = csv.DictReader(open('data/CAIT 2.0 Country GHG Emissions.csv'))\n",
      "country_year = []\n",
      "for row in dict_reader:\n",
      "    keys = row.keys()\n",
      "    clean_row = {}\n",
      "    for key in keys:\n",
      "        clean_row[key] = row[key].strip()\n",
      "    country_year.append(clean_row)"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 9
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "cy = pd.read_csv('data/CAIT 2.0 Country GHG Emissions.csv')"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 10
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "country_year\n",
      "cy[cy[\"Country\"].isin([\"Germany\", \"Austria\"])]"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>Country</th>\n",
        "      <th>Year</th>\n",
        "      <th>Total GHG Emissions Excluding Land-Use Change and Forestry (MtCO2e)</th>\n",
        "      <th>Total GHG Emissions Including Land-Use Change and Forestry (MtCO2e)</th>\n",
        "      <th>Total CO? Excluding Land-Use Change and Forestry (MtCO2)</th>\n",
        "      <th>Total CH4 (MtCO2e)</th>\n",
        "      <th>Total N2O (MtCO2e)</th>\n",
        "      <th>Total F-Gas (MtCO2e)</th>\n",
        "      <th>Energy (MtCO2e)</th>\n",
        "      <th>Industrial Processes (MtCO2e)</th>\n",
        "      <th>Agriculture (MtCO2e)</th>\n",
        "      <th>Waste (MtCO2e)</th>\n",
        "      <th>LUCF (MtCO2)</th>\n",
        "      <th>Bunker Fuels (MtCO2)</th>\n",
        "      <th>Electricity/Heat (MtCO2)</th>\n",
        "      <th>Manufacturing/Construction (MtCO2)</th>\n",
        "      <th>Transportation (MtCO2)</th>\n",
        "      <th>Other Fuel Combustion (MtCO2e)</th>\n",
        "      <th>Fugitive Emissions (MtCO2e)</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>176 </th>\n",
        "      <td> Austria</td>\n",
        "      <td> 1990</td>\n",
        "      <td>   74.9340</td>\n",
        "      <td>   62.1559</td>\n",
        "      <td>  58.8802</td>\n",
        "      <td>   8.357588</td>\n",
        "      <td>  6.260281</td>\n",
        "      <td>  1.435894</td>\n",
        "      <td>  57.655646</td>\n",
        "      <td>  5.035472</td>\n",
        "      <td>  8.676659</td>\n",
        "      <td>  3.556211</td>\n",
        "      <td>-12.77809</td>\n",
        "      <td>  0.86</td>\n",
        "      <td>  19.78</td>\n",
        "      <td>  10.08</td>\n",
        "      <td>  13.64</td>\n",
        "      <td>  13.946938</td>\n",
        "      <td>  0.208707</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>177 </th>\n",
        "      <td> Austria</td>\n",
        "      <td> 1991</td>\n",
        "      <td>   79.0045</td>\n",
        "      <td>   66.2084</td>\n",
        "      <td>  63.0588</td>\n",
        "      <td>   8.215910</td>\n",
        "      <td>  6.334795</td>\n",
        "      <td>  1.394931</td>\n",
        "      <td>  61.793464</td>\n",
        "      <td>  5.042084</td>\n",
        "      <td>  8.699697</td>\n",
        "      <td>  3.459241</td>\n",
        "      <td>-12.79612</td>\n",
        "      <td>  0.96</td>\n",
        "      <td>  20.66</td>\n",
        "      <td>  10.59</td>\n",
        "      <td>  15.03</td>\n",
        "      <td>  15.301357</td>\n",
        "      <td>  0.212107</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>178 </th>\n",
        "      <td> Austria</td>\n",
        "      <td> 1992</td>\n",
        "      <td>   74.0037</td>\n",
        "      <td>   61.1715</td>\n",
        "      <td>  58.1662</td>\n",
        "      <td>   8.074233</td>\n",
        "      <td>  6.409309</td>\n",
        "      <td>  1.353969</td>\n",
        "      <td>  56.921282</td>\n",
        "      <td>  4.997399</td>\n",
        "      <td>  8.722735</td>\n",
        "      <td>  3.362271</td>\n",
        "      <td>-12.83217</td>\n",
        "      <td>  1.04</td>\n",
        "      <td>  17.38</td>\n",
        "      <td>   9.67</td>\n",
        "      <td>  15.04</td>\n",
        "      <td>  14.615776</td>\n",
        "      <td>  0.215506</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>179 </th>\n",
        "      <td> Austria</td>\n",
        "      <td> 1993</td>\n",
        "      <td>   74.1716</td>\n",
        "      <td>   61.3034</td>\n",
        "      <td>  58.4422</td>\n",
        "      <td>   7.932555</td>\n",
        "      <td>  6.483823</td>\n",
        "      <td>  1.313006</td>\n",
        "      <td>  57.259100</td>\n",
        "      <td>  4.901418</td>\n",
        "      <td>  8.745773</td>\n",
        "      <td>  3.265301</td>\n",
        "      <td>-12.86823</td>\n",
        "      <td>  1.10</td>\n",
        "      <td>  17.47</td>\n",
        "      <td>  10.08</td>\n",
        "      <td>  15.18</td>\n",
        "      <td>  14.310195</td>\n",
        "      <td>  0.218905</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>180 </th>\n",
        "      <td> Austria</td>\n",
        "      <td> 1994</td>\n",
        "      <td>   74.1885</td>\n",
        "      <td>   61.2842</td>\n",
        "      <td>  58.5672</td>\n",
        "      <td>   7.790877</td>\n",
        "      <td>  6.558337</td>\n",
        "      <td>  1.272043</td>\n",
        "      <td>  57.466918</td>\n",
        "      <td>  4.794445</td>\n",
        "      <td>  8.768811</td>\n",
        "      <td>  3.168330</td>\n",
        "      <td>-12.90428</td>\n",
        "      <td>  1.14</td>\n",
        "      <td>  18.85</td>\n",
        "      <td>   9.84</td>\n",
        "      <td>  15.24</td>\n",
        "      <td>  13.314614</td>\n",
        "      <td>  0.222304</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>181 </th>\n",
        "      <td> Austria</td>\n",
        "      <td> 1995</td>\n",
        "      <td>   76.8094</td>\n",
        "      <td>   63.8691</td>\n",
        "      <td>  61.2963</td>\n",
        "      <td>   7.649199</td>\n",
        "      <td>  6.632851</td>\n",
        "      <td>  1.231080</td>\n",
        "      <td>  60.684736</td>\n",
        "      <td>  4.251457</td>\n",
        "      <td>  8.791849</td>\n",
        "      <td>  3.071360</td>\n",
        "      <td>-12.94033</td>\n",
        "      <td>  1.28</td>\n",
        "      <td>  20.43</td>\n",
        "      <td>  10.12</td>\n",
        "      <td>  15.45</td>\n",
        "      <td>  14.459033</td>\n",
        "      <td>  0.225703</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>182 </th>\n",
        "      <td> Austria</td>\n",
        "      <td> 1996</td>\n",
        "      <td>   80.2882</td>\n",
        "      <td>   67.3119</td>\n",
        "      <td>  65.0609</td>\n",
        "      <td>   7.449835</td>\n",
        "      <td>  6.564551</td>\n",
        "      <td>  1.212927</td>\n",
        "      <td>  64.444008</td>\n",
        "      <td>  4.266895</td>\n",
        "      <td>  8.628689</td>\n",
        "      <td>  2.958649</td>\n",
        "      <td>-12.97639</td>\n",
        "      <td>  1.42</td>\n",
        "      <td>  20.94</td>\n",
        "      <td>  10.36</td>\n",
        "      <td>  17.07</td>\n",
        "      <td>  15.850811</td>\n",
        "      <td>  0.223197</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>183 </th>\n",
        "      <td> Austria</td>\n",
        "      <td> 1997</td>\n",
        "      <td>   79.2814</td>\n",
        "      <td>   66.2690</td>\n",
        "      <td>  64.3399</td>\n",
        "      <td>   7.250471</td>\n",
        "      <td>  6.496251</td>\n",
        "      <td>  1.194773</td>\n",
        "      <td>  63.703280</td>\n",
        "      <td>  4.256685</td>\n",
        "      <td>  8.465528</td>\n",
        "      <td>  2.845937</td>\n",
        "      <td>-13.01246</td>\n",
        "      <td>  1.47</td>\n",
        "      <td>  21.32</td>\n",
        "      <td>  11.68</td>\n",
        "      <td>  16.15</td>\n",
        "      <td>  14.332590</td>\n",
        "      <td>  0.220690</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>184 </th>\n",
        "      <td> Austria</td>\n",
        "      <td> 1998</td>\n",
        "      <td>   79.4956</td>\n",
        "      <td>   66.4471</td>\n",
        "      <td>  64.8399</td>\n",
        "      <td>   7.051106</td>\n",
        "      <td>  6.427951</td>\n",
        "      <td>  1.176619</td>\n",
        "      <td>  64.202552</td>\n",
        "      <td>  4.257468</td>\n",
        "      <td>  8.302367</td>\n",
        "      <td>  2.733225</td>\n",
        "      <td>-13.04851</td>\n",
        "      <td>  1.54</td>\n",
        "      <td>  20.46</td>\n",
        "      <td>  10.90</td>\n",
        "      <td>  18.25</td>\n",
        "      <td>  14.374368</td>\n",
        "      <td>  0.218184</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>185 </th>\n",
        "      <td> Austria</td>\n",
        "      <td> 1999</td>\n",
        "      <td>   77.6415</td>\n",
        "      <td>   64.5569</td>\n",
        "      <td>  63.2716</td>\n",
        "      <td>   6.851742</td>\n",
        "      <td>  6.359651</td>\n",
        "      <td>  1.158465</td>\n",
        "      <td>  62.641824</td>\n",
        "      <td>  4.239930</td>\n",
        "      <td>  8.139207</td>\n",
        "      <td>  2.620513</td>\n",
        "      <td>-13.08456</td>\n",
        "      <td>  1.49</td>\n",
        "      <td>  19.58</td>\n",
        "      <td>  10.21</td>\n",
        "      <td>  17.76</td>\n",
        "      <td>  14.876146</td>\n",
        "      <td>  0.215678</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>186 </th>\n",
        "      <td> Austria</td>\n",
        "      <td> 2000</td>\n",
        "      <td>   77.6673</td>\n",
        "      <td>   64.5467</td>\n",
        "      <td>  63.5833</td>\n",
        "      <td>   6.652378</td>\n",
        "      <td>  6.291351</td>\n",
        "      <td>  1.140311</td>\n",
        "      <td>  62.961096</td>\n",
        "      <td>  4.222393</td>\n",
        "      <td>  7.976046</td>\n",
        "      <td>  2.507801</td>\n",
        "      <td>-13.12062</td>\n",
        "      <td>  1.63</td>\n",
        "      <td>  19.21</td>\n",
        "      <td>  11.30</td>\n",
        "      <td>  18.50</td>\n",
        "      <td>  13.737924</td>\n",
        "      <td>  0.213171</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>187 </th>\n",
        "      <td> Austria</td>\n",
        "      <td> 2001</td>\n",
        "      <td>   81.5971</td>\n",
        "      <td>   64.3176</td>\n",
        "      <td>  67.7643</td>\n",
        "      <td>   6.543902</td>\n",
        "      <td>  6.111568</td>\n",
        "      <td>  1.177361</td>\n",
        "      <td>  67.137434</td>\n",
        "      <td>  4.123388</td>\n",
        "      <td>  7.863260</td>\n",
        "      <td>  2.463037</td>\n",
        "      <td>-17.27952</td>\n",
        "      <td>  1.59</td>\n",
        "      <td>  20.98</td>\n",
        "      <td>  11.05</td>\n",
        "      <td>  19.97</td>\n",
        "      <td>  14.919769</td>\n",
        "      <td>  0.217664</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>188 </th>\n",
        "      <td> Austria</td>\n",
        "      <td> 2002</td>\n",
        "      <td>   82.9345</td>\n",
        "      <td>   65.6155</td>\n",
        "      <td>  69.3529</td>\n",
        "      <td>   6.435426</td>\n",
        "      <td>  5.931786</td>\n",
        "      <td>  1.214410</td>\n",
        "      <td>  68.693771</td>\n",
        "      <td>  4.072016</td>\n",
        "      <td>  7.750474</td>\n",
        "      <td>  2.418272</td>\n",
        "      <td>-17.31901</td>\n",
        "      <td>  1.49</td>\n",
        "      <td>  21.44</td>\n",
        "      <td>  10.96</td>\n",
        "      <td>  21.84</td>\n",
        "      <td>  14.231614</td>\n",
        "      <td>  0.222157</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>189 </th>\n",
        "      <td> Austria</td>\n",
        "      <td> 2003</td>\n",
        "      <td>   87.8550</td>\n",
        "      <td>   70.4970</td>\n",
        "      <td>  74.5246</td>\n",
        "      <td>   6.326950</td>\n",
        "      <td>  5.752004</td>\n",
        "      <td>  1.251459</td>\n",
        "      <td>  73.900109</td>\n",
        "      <td>  3.943700</td>\n",
        "      <td>  7.637688</td>\n",
        "      <td>  2.373508</td>\n",
        "      <td>-17.35805</td>\n",
        "      <td>  1.41</td>\n",
        "      <td>  23.58</td>\n",
        "      <td>  11.70</td>\n",
        "      <td>  23.40</td>\n",
        "      <td>  14.993459</td>\n",
        "      <td>  0.226651</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>190 </th>\n",
        "      <td> Austria</td>\n",
        "      <td> 2004</td>\n",
        "      <td>   88.9483</td>\n",
        "      <td>   71.5509</td>\n",
        "      <td>  75.8691</td>\n",
        "      <td>   6.218474</td>\n",
        "      <td>  5.572221</td>\n",
        "      <td>  1.288508</td>\n",
        "      <td>  75.036447</td>\n",
        "      <td>  4.068200</td>\n",
        "      <td>  7.524901</td>\n",
        "      <td>  2.328744</td>\n",
        "      <td>-17.39736</td>\n",
        "      <td>  1.67</td>\n",
        "      <td>  24.16</td>\n",
        "      <td>  12.38</td>\n",
        "      <td>  23.73</td>\n",
        "      <td>  14.535303</td>\n",
        "      <td>  0.231144</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>191 </th>\n",
        "      <td> Austria</td>\n",
        "      <td> 2005</td>\n",
        "      <td>   89.7697</td>\n",
        "      <td>   72.3322</td>\n",
        "      <td>  76.9417</td>\n",
        "      <td>   6.109998</td>\n",
        "      <td>  5.392439</td>\n",
        "      <td>  1.325558</td>\n",
        "      <td>  76.012785</td>\n",
        "      <td>  4.060796</td>\n",
        "      <td>  7.412115</td>\n",
        "      <td>  2.283979</td>\n",
        "      <td>-17.43743</td>\n",
        "      <td>  1.89</td>\n",
        "      <td>  24.72</td>\n",
        "      <td>  12.62</td>\n",
        "      <td>  24.45</td>\n",
        "      <td>  13.987148</td>\n",
        "      <td>  0.235637</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>192 </th>\n",
        "      <td> Austria</td>\n",
        "      <td> 2006</td>\n",
        "      <td>   87.7557</td>\n",
        "      <td>   92.3648</td>\n",
        "      <td>  74.9182</td>\n",
        "      <td>   6.010376</td>\n",
        "      <td>  5.455878</td>\n",
        "      <td>  1.371213</td>\n",
        "      <td>  73.828167</td>\n",
        "      <td>  4.278990</td>\n",
        "      <td>  7.449715</td>\n",
        "      <td>  2.198834</td>\n",
        "      <td>  4.60913</td>\n",
        "      <td>  1.98</td>\n",
        "      <td>  24.35</td>\n",
        "      <td>  12.61</td>\n",
        "      <td>  23.18</td>\n",
        "      <td>  13.454362</td>\n",
        "      <td>  0.233806</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>193 </th>\n",
        "      <td> Austria</td>\n",
        "      <td> 2007</td>\n",
        "      <td>   85.4511</td>\n",
        "      <td>   90.0768</td>\n",
        "      <td>  72.6041</td>\n",
        "      <td>   5.910754</td>\n",
        "      <td>  5.519316</td>\n",
        "      <td>  1.416869</td>\n",
        "      <td>  71.323550</td>\n",
        "      <td>  4.526497</td>\n",
        "      <td>  7.487315</td>\n",
        "      <td>  2.113689</td>\n",
        "      <td>  4.62574</td>\n",
        "      <td>  2.10</td>\n",
        "      <td>  23.93</td>\n",
        "      <td>  12.11</td>\n",
        "      <td>  23.37</td>\n",
        "      <td>  11.681576</td>\n",
        "      <td>  0.231975</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>194 </th>\n",
        "      <td> Austria</td>\n",
        "      <td> 2008</td>\n",
        "      <td>   86.1118</td>\n",
        "      <td>   90.7534</td>\n",
        "      <td>  73.2554</td>\n",
        "      <td>   5.811132</td>\n",
        "      <td>  5.582755</td>\n",
        "      <td>  1.462525</td>\n",
        "      <td>  71.908933</td>\n",
        "      <td>  4.649428</td>\n",
        "      <td>  7.524916</td>\n",
        "      <td>  2.028544</td>\n",
        "      <td>  4.64154</td>\n",
        "      <td>  2.11</td>\n",
        "      <td>  23.96</td>\n",
        "      <td>  13.41</td>\n",
        "      <td>  22.04</td>\n",
        "      <td>  12.268789</td>\n",
        "      <td>  0.230143</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>195 </th>\n",
        "      <td> Austria</td>\n",
        "      <td> 2009</td>\n",
        "      <td>   79.3915</td>\n",
        "      <td>   84.0492</td>\n",
        "      <td>  66.5256</td>\n",
        "      <td>   5.711510</td>\n",
        "      <td>  5.646194</td>\n",
        "      <td>  1.508180</td>\n",
        "      <td>  65.504315</td>\n",
        "      <td>  4.391303</td>\n",
        "      <td>  7.562516</td>\n",
        "      <td>  1.943399</td>\n",
        "      <td>  4.65771</td>\n",
        "      <td>  1.83</td>\n",
        "      <td>  20.46</td>\n",
        "      <td>  12.28</td>\n",
        "      <td>  21.47</td>\n",
        "      <td>  11.066003</td>\n",
        "      <td>  0.228312</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>196 </th>\n",
        "      <td> Austria</td>\n",
        "      <td> 2010</td>\n",
        "      <td>   85.0568</td>\n",
        "      <td>   89.7307</td>\n",
        "      <td>  72.1815</td>\n",
        "      <td>   5.611888</td>\n",
        "      <td>  5.709633</td>\n",
        "      <td>  1.553836</td>\n",
        "      <td>  71.339698</td>\n",
        "      <td>  4.268746</td>\n",
        "      <td>  7.600116</td>\n",
        "      <td>  1.858254</td>\n",
        "      <td>  4.67391</td>\n",
        "      <td>  1.98</td>\n",
        "      <td>  24.43</td>\n",
        "      <td>  12.25</td>\n",
        "      <td>  22.16</td>\n",
        "      <td>  12.273217</td>\n",
        "      <td>  0.226481</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>197 </th>\n",
        "      <td> Austria</td>\n",
        "      <td> 2011</td>\n",
        "      <td>   83.6993</td>\n",
        "      <td>   88.3732</td>\n",
        "      <td>  70.6977</td>\n",
        "      <td>   5.619402</td>\n",
        "      <td>  5.760892</td>\n",
        "      <td>  1.621245</td>\n",
        "      <td>  69.767853</td>\n",
        "      <td>  4.421615</td>\n",
        "      <td>  7.651142</td>\n",
        "      <td>  1.858660</td>\n",
        "      <td>  4.67391</td>\n",
        "      <td>  2.06</td>\n",
        "      <td>  24.69</td>\n",
        "      <td>  12.16</td>\n",
        "      <td>  21.62</td>\n",
        "      <td>  11.072787</td>\n",
        "      <td>  0.225066</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1430</th>\n",
        "      <td> Germany</td>\n",
        "      <td> 1990</td>\n",
        "      <td> 1170.6905</td>\n",
        "      <td> 1107.4739</td>\n",
        "      <td> 968.4600</td>\n",
        "      <td> 105.603288</td>\n",
        "      <td> 90.130354</td>\n",
        "      <td>  6.496875</td>\n",
        "      <td> 961.860808</td>\n",
        "      <td> 52.680302</td>\n",
        "      <td> 87.002776</td>\n",
        "      <td> 43.111498</td>\n",
        "      <td>-63.21663</td>\n",
        "      <td> 21.13</td>\n",
        "      <td> 402.63</td>\n",
        "      <td> 179.26</td>\n",
        "      <td> 157.59</td>\n",
        "      <td> 222.380808</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1431</th>\n",
        "      <td> Germany</td>\n",
        "      <td> 1991</td>\n",
        "      <td> 1141.5211</td>\n",
        "      <td> 1078.1033</td>\n",
        "      <td> 942.9715</td>\n",
        "      <td> 102.488747</td>\n",
        "      <td> 89.260737</td>\n",
        "      <td>  6.800162</td>\n",
        "      <td> 962.310678</td>\n",
        "      <td> 51.837333</td>\n",
        "      <td> 84.919839</td>\n",
        "      <td> 42.453248</td>\n",
        "      <td>-63.41781</td>\n",
        "      <td> 19.25</td>\n",
        "      <td> 399.98</td>\n",
        "      <td> 153.93</td>\n",
        "      <td> 160.28</td>\n",
        "      <td> 222.184333</td>\n",
        "      <td> 25.936346</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1432</th>\n",
        "      <td> Germany</td>\n",
        "      <td> 1992</td>\n",
        "      <td> 1100.8033</td>\n",
        "      <td> 1036.9831</td>\n",
        "      <td> 905.9345</td>\n",
        "      <td>  99.374206</td>\n",
        "      <td> 88.391119</td>\n",
        "      <td>  7.103450</td>\n",
        "      <td> 921.956391</td>\n",
        "      <td> 54.215020</td>\n",
        "      <td> 82.836902</td>\n",
        "      <td> 41.794998</td>\n",
        "      <td>-63.82017</td>\n",
        "      <td> 19.08</td>\n",
        "      <td> 383.75</td>\n",
        "      <td> 145.92</td>\n",
        "      <td> 162.79</td>\n",
        "      <td> 204.977857</td>\n",
        "      <td> 24.518533</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1433</th>\n",
        "      <td> Germany</td>\n",
        "      <td> 1993</td>\n",
        "      <td> 1089.9713</td>\n",
        "      <td> 1025.7488</td>\n",
        "      <td> 898.7834</td>\n",
        "      <td>  96.259665</td>\n",
        "      <td> 87.521502</td>\n",
        "      <td>  7.406737</td>\n",
        "      <td> 913.488454</td>\n",
        "      <td> 54.592163</td>\n",
        "      <td> 80.753965</td>\n",
        "      <td> 41.136747</td>\n",
        "      <td>-64.22252</td>\n",
        "      <td> 21.25</td>\n",
        "      <td> 375.97</td>\n",
        "      <td> 137.48</td>\n",
        "      <td> 167.36</td>\n",
        "      <td> 209.321382</td>\n",
        "      <td> 23.357071</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1434</th>\n",
        "      <td> Germany</td>\n",
        "      <td> 1994</td>\n",
        "      <td> 1075.3534</td>\n",
        "      <td> 1010.7285</td>\n",
        "      <td> 887.8463</td>\n",
        "      <td>  93.145123</td>\n",
        "      <td> 86.651884</td>\n",
        "      <td>  7.710024</td>\n",
        "      <td> 901.051336</td>\n",
        "      <td> 55.152506</td>\n",
        "      <td> 78.671029</td>\n",
        "      <td> 40.478497</td>\n",
        "      <td>-64.62488</td>\n",
        "      <td> 22.09</td>\n",
        "      <td> 376.24</td>\n",
        "      <td> 139.31</td>\n",
        "      <td> 164.81</td>\n",
        "      <td> 197.754907</td>\n",
        "      <td> 22.936429</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1435</th>\n",
        "      <td> Germany</td>\n",
        "      <td> 1995</td>\n",
        "      <td> 1069.1875</td>\n",
        "      <td> 1004.1603</td>\n",
        "      <td> 885.3614</td>\n",
        "      <td>  90.030582</td>\n",
        "      <td> 85.782267</td>\n",
        "      <td>  8.013311</td>\n",
        "      <td> 898.230509</td>\n",
        "      <td> 54.558689</td>\n",
        "      <td> 76.588092</td>\n",
        "      <td> 39.820247</td>\n",
        "      <td>-65.02723</td>\n",
        "      <td> 22.19</td>\n",
        "      <td> 370.37</td>\n",
        "      <td> 140.07</td>\n",
        "      <td> 166.68</td>\n",
        "      <td> 199.668432</td>\n",
        "      <td> 21.442077</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1436</th>\n",
        "      <td> Germany</td>\n",
        "      <td> 1996</td>\n",
        "      <td> 1090.0924</td>\n",
        "      <td> 1024.6622</td>\n",
        "      <td> 913.1011</td>\n",
        "      <td>  86.450525</td>\n",
        "      <td> 82.057757</td>\n",
        "      <td>  8.482937</td>\n",
        "      <td> 926.072973</td>\n",
        "      <td> 50.008721</td>\n",
        "      <td> 76.738323</td>\n",
        "      <td> 37.272343</td>\n",
        "      <td>-65.43018</td>\n",
        "      <td> 22.49</td>\n",
        "      <td> 381.12</td>\n",
        "      <td> 132.30</td>\n",
        "      <td> 167.78</td>\n",
        "      <td> 224.124015</td>\n",
        "      <td> 20.748958</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1437</th>\n",
        "      <td> Germany</td>\n",
        "      <td> 1997</td>\n",
        "      <td> 1054.5583</td>\n",
        "      <td>  988.7256</td>\n",
        "      <td> 884.4020</td>\n",
        "      <td>  82.870467</td>\n",
        "      <td> 78.333246</td>\n",
        "      <td>  8.952563</td>\n",
        "      <td> 894.411467</td>\n",
        "      <td> 48.543841</td>\n",
        "      <td> 76.888555</td>\n",
        "      <td> 34.724440</td>\n",
        "      <td>-65.83274</td>\n",
        "      <td> 23.58</td>\n",
        "      <td> 365.48</td>\n",
        "      <td> 131.08</td>\n",
        "      <td> 168.43</td>\n",
        "      <td> 209.449598</td>\n",
        "      <td> 19.971869</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1438</th>\n",
        "      <td> Germany</td>\n",
        "      <td> 1998</td>\n",
        "      <td> 1041.1293</td>\n",
        "      <td>  974.8944</td>\n",
        "      <td> 877.8080</td>\n",
        "      <td>  79.290410</td>\n",
        "      <td> 74.608736</td>\n",
        "      <td>  9.422189</td>\n",
        "      <td> 886.717341</td>\n",
        "      <td> 45.206658</td>\n",
        "      <td> 77.038786</td>\n",
        "      <td> 32.176536</td>\n",
        "      <td>-66.23491</td>\n",
        "      <td> 23.87</td>\n",
        "      <td> 365.47</td>\n",
        "      <td> 129.90</td>\n",
        "      <td> 171.33</td>\n",
        "      <td> 200.715181</td>\n",
        "      <td> 19.302160</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1439</th>\n",
        "      <td> Germany</td>\n",
        "      <td> 1999</td>\n",
        "      <td> 1003.8816</td>\n",
        "      <td>  937.2443</td>\n",
        "      <td> 847.3952</td>\n",
        "      <td>  75.710352</td>\n",
        "      <td> 70.884225</td>\n",
        "      <td>  9.891816</td>\n",
        "      <td> 855.872295</td>\n",
        "      <td> 41.191634</td>\n",
        "      <td> 77.189018</td>\n",
        "      <td> 29.628632</td>\n",
        "      <td>-66.63727</td>\n",
        "      <td> 25.08</td>\n",
        "      <td> 351.40</td>\n",
        "      <td> 124.34</td>\n",
        "      <td> 176.11</td>\n",
        "      <td> 183.310764</td>\n",
        "      <td> 20.711531</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1440</th>\n",
        "      <td> Germany</td>\n",
        "      <td> 2000</td>\n",
        "      <td>  994.8552</td>\n",
        "      <td>  927.8154</td>\n",
        "      <td> 845.2038</td>\n",
        "      <td>  72.130295</td>\n",
        "      <td> 67.159715</td>\n",
        "      <td> 10.361442</td>\n",
        "      <td> 853.159689</td>\n",
        "      <td> 37.275539</td>\n",
        "      <td> 77.339249</td>\n",
        "      <td> 27.080729</td>\n",
        "      <td>-67.03983</td>\n",
        "      <td> 26.35</td>\n",
        "      <td> 356.29</td>\n",
        "      <td> 126.26</td>\n",
        "      <td> 171.89</td>\n",
        "      <td> 178.746347</td>\n",
        "      <td> 19.973342</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1441</th>\n",
        "      <td> Germany</td>\n",
        "      <td> 2001</td>\n",
        "      <td> 1008.8681</td>\n",
        "      <td>  955.3679</td>\n",
        "      <td> 861.7905</td>\n",
        "      <td>  69.152698</td>\n",
        "      <td> 66.779153</td>\n",
        "      <td> 11.145801</td>\n",
        "      <td> 870.599851</td>\n",
        "      <td> 36.515479</td>\n",
        "      <td> 76.577768</td>\n",
        "      <td> 25.185046</td>\n",
        "      <td>-53.50029</td>\n",
        "      <td> 25.62</td>\n",
        "      <td> 368.40</td>\n",
        "      <td> 120.29</td>\n",
        "      <td> 167.96</td>\n",
        "      <td> 194.815112</td>\n",
        "      <td> 19.134739</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1442</th>\n",
        "      <td> Germany</td>\n",
        "      <td> 2002</td>\n",
        "      <td>  993.1553</td>\n",
        "      <td>  939.6549</td>\n",
        "      <td> 848.6514</td>\n",
        "      <td>  66.175102</td>\n",
        "      <td> 66.398590</td>\n",
        "      <td> 11.930160</td>\n",
        "      <td> 857.206014</td>\n",
        "      <td> 36.843627</td>\n",
        "      <td> 75.816286</td>\n",
        "      <td> 23.289363</td>\n",
        "      <td>-53.50036</td>\n",
        "      <td> 26.11</td>\n",
        "      <td> 370.17</td>\n",
        "      <td> 120.31</td>\n",
        "      <td> 165.55</td>\n",
        "      <td> 182.893877</td>\n",
        "      <td> 18.282137</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1443</th>\n",
        "      <td> Germany</td>\n",
        "      <td> 2003</td>\n",
        "      <td>  984.4538</td>\n",
        "      <td>  930.9535</td>\n",
        "      <td> 842.5238</td>\n",
        "      <td>  63.197506</td>\n",
        "      <td> 66.018028</td>\n",
        "      <td> 12.714519</td>\n",
        "      <td> 849.401916</td>\n",
        "      <td> 38.593408</td>\n",
        "      <td> 75.054805</td>\n",
        "      <td> 21.393680</td>\n",
        "      <td>-53.50034</td>\n",
        "      <td> 27.32</td>\n",
        "      <td> 374.06</td>\n",
        "      <td> 117.61</td>\n",
        "      <td> 160.62</td>\n",
        "      <td> 179.772642</td>\n",
        "      <td> 17.339274</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1444</th>\n",
        "      <td> Germany</td>\n",
        "      <td> 2004</td>\n",
        "      <td>  985.5316</td>\n",
        "      <td>  932.0327</td>\n",
        "      <td> 846.1753</td>\n",
        "      <td>  60.219909</td>\n",
        "      <td> 65.637465</td>\n",
        "      <td> 13.498879</td>\n",
        "      <td> 852.722459</td>\n",
        "      <td> 39.027812</td>\n",
        "      <td> 74.293324</td>\n",
        "      <td> 19.497997</td>\n",
        "      <td>-53.49885</td>\n",
        "      <td> 29.26</td>\n",
        "      <td> 382.16</td>\n",
        "      <td> 120.82</td>\n",
        "      <td> 162.64</td>\n",
        "      <td> 170.771408</td>\n",
        "      <td> 16.331051</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1445</th>\n",
        "      <td> Germany</td>\n",
        "      <td> 2005</td>\n",
        "      <td>  954.5998</td>\n",
        "      <td>  901.0995</td>\n",
        "      <td> 817.8173</td>\n",
        "      <td>  57.242313</td>\n",
        "      <td> 65.256903</td>\n",
        "      <td> 14.283238</td>\n",
        "      <td> 823.977751</td>\n",
        "      <td> 39.487864</td>\n",
        "      <td> 73.531842</td>\n",
        "      <td> 17.602314</td>\n",
        "      <td>-53.50032</td>\n",
        "      <td> 30.39</td>\n",
        "      <td> 367.47</td>\n",
        "      <td> 120.26</td>\n",
        "      <td> 154.89</td>\n",
        "      <td> 165.820173</td>\n",
        "      <td> 15.537578</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1446</th>\n",
        "      <td> Germany</td>\n",
        "      <td> 2006</td>\n",
        "      <td>  965.5155</td>\n",
        "      <td>  888.5549</td>\n",
        "      <td> 832.3991</td>\n",
        "      <td>  54.315077</td>\n",
        "      <td> 64.181395</td>\n",
        "      <td> 14.619890</td>\n",
        "      <td> 837.012320</td>\n",
        "      <td> 41.344575</td>\n",
        "      <td> 71.007761</td>\n",
        "      <td> 16.150842</td>\n",
        "      <td>-76.96061</td>\n",
        "      <td> 31.80</td>\n",
        "      <td> 373.75</td>\n",
        "      <td> 122.05</td>\n",
        "      <td> 152.48</td>\n",
        "      <td> 173.699382</td>\n",
        "      <td> 15.032938</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1447</th>\n",
        "      <td> Germany</td>\n",
        "      <td> 2007</td>\n",
        "      <td>  935.4004</td>\n",
        "      <td>  858.4334</td>\n",
        "      <td> 805.9501</td>\n",
        "      <td>  51.387841</td>\n",
        "      <td> 63.105887</td>\n",
        "      <td> 14.956542</td>\n",
        "      <td> 810.448659</td>\n",
        "      <td> 41.768661</td>\n",
        "      <td> 68.483679</td>\n",
        "      <td> 14.699371</td>\n",
        "      <td>-76.96702</td>\n",
        "      <td> 34.23</td>\n",
        "      <td> 386.52</td>\n",
        "      <td> 123.57</td>\n",
        "      <td> 148.23</td>\n",
        "      <td> 137.688592</td>\n",
        "      <td> 14.440068</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1448</th>\n",
        "      <td> Germany</td>\n",
        "      <td> 2008</td>\n",
        "      <td>  938.7277</td>\n",
        "      <td>  861.8190</td>\n",
        "      <td> 812.9435</td>\n",
        "      <td>  48.460606</td>\n",
        "      <td> 62.030379</td>\n",
        "      <td> 15.293193</td>\n",
        "      <td> 817.113968</td>\n",
        "      <td> 42.416251</td>\n",
        "      <td> 65.959598</td>\n",
        "      <td> 13.247899</td>\n",
        "      <td>-76.90871</td>\n",
        "      <td> 34.27</td>\n",
        "      <td> 366.85</td>\n",
        "      <td> 123.36</td>\n",
        "      <td> 147.02</td>\n",
        "      <td> 166.027801</td>\n",
        "      <td> 13.856167</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1449</th>\n",
        "      <td> Germany</td>\n",
        "      <td> 2009</td>\n",
        "      <td>  876.1988</td>\n",
        "      <td>  799.2322</td>\n",
        "      <td> 754.0807</td>\n",
        "      <td>  45.533370</td>\n",
        "      <td> 60.954871</td>\n",
        "      <td> 15.629845</td>\n",
        "      <td> 759.576488</td>\n",
        "      <td> 41.400385</td>\n",
        "      <td> 63.435516</td>\n",
        "      <td> 11.796427</td>\n",
        "      <td>-76.96658</td>\n",
        "      <td> 32.86</td>\n",
        "      <td> 338.75</td>\n",
        "      <td> 106.06</td>\n",
        "      <td> 147.16</td>\n",
        "      <td> 154.307011</td>\n",
        "      <td> 13.299477</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1450</th>\n",
        "      <td> Germany</td>\n",
        "      <td> 2010</td>\n",
        "      <td>  903.9783</td>\n",
        "      <td>  827.0112</td>\n",
        "      <td> 785.5263</td>\n",
        "      <td>  42.606134</td>\n",
        "      <td> 59.879363</td>\n",
        "      <td> 15.966497</td>\n",
        "      <td> 791.053957</td>\n",
        "      <td> 41.677912</td>\n",
        "      <td> 60.911435</td>\n",
        "      <td> 10.344956</td>\n",
        "      <td>-76.96702</td>\n",
        "      <td> 32.70</td>\n",
        "      <td> 353.46</td>\n",
        "      <td> 115.57</td>\n",
        "      <td> 147.01</td>\n",
        "      <td> 162.466221</td>\n",
        "      <td> 12.547736</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1451</th>\n",
        "      <td> Germany</td>\n",
        "      <td> 2011</td>\n",
        "      <td>  882.9341</td>\n",
        "      <td>  805.9671</td>\n",
        "      <td> 765.9803</td>\n",
        "      <td>  42.020623</td>\n",
        "      <td> 58.041694</td>\n",
        "      <td> 16.891529</td>\n",
        "      <td> 769.594747</td>\n",
        "      <td> 42.752812</td>\n",
        "      <td> 60.640635</td>\n",
        "      <td>  9.945956</td>\n",
        "      <td>-76.96702</td>\n",
        "      <td> 31.71</td>\n",
        "      <td> 350.51</td>\n",
        "      <td> 114.15</td>\n",
        "      <td> 148.74</td>\n",
        "      <td> 143.711204</td>\n",
        "      <td> 12.483543</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 44,
       "text": [
        "      Country  Year  \\\n",
        "176   Austria  1990   \n",
        "177   Austria  1991   \n",
        "178   Austria  1992   \n",
        "179   Austria  1993   \n",
        "180   Austria  1994   \n",
        "181   Austria  1995   \n",
        "182   Austria  1996   \n",
        "183   Austria  1997   \n",
        "184   Austria  1998   \n",
        "185   Austria  1999   \n",
        "186   Austria  2000   \n",
        "187   Austria  2001   \n",
        "188   Austria  2002   \n",
        "189   Austria  2003   \n",
        "190   Austria  2004   \n",
        "191   Austria  2005   \n",
        "192   Austria  2006   \n",
        "193   Austria  2007   \n",
        "194   Austria  2008   \n",
        "195   Austria  2009   \n",
        "196   Austria  2010   \n",
        "197   Austria  2011   \n",
        "1430  Germany  1990   \n",
        "1431  Germany  1991   \n",
        "1432  Germany  1992   \n",
        "1433  Germany  1993   \n",
        "1434  Germany  1994   \n",
        "1435  Germany  1995   \n",
        "1436  Germany  1996   \n",
        "1437  Germany  1997   \n",
        "1438  Germany  1998   \n",
        "1439  Germany  1999   \n",
        "1440  Germany  2000   \n",
        "1441  Germany  2001   \n",
        "1442  Germany  2002   \n",
        "1443  Germany  2003   \n",
        "1444  Germany  2004   \n",
        "1445  Germany  2005   \n",
        "1446  Germany  2006   \n",
        "1447  Germany  2007   \n",
        "1448  Germany  2008   \n",
        "1449  Germany  2009   \n",
        "1450  Germany  2010   \n",
        "1451  Germany  2011   \n",
        "\n",
        "      Total GHG Emissions Excluding Land-Use Change and Forestry (MtCO2e)  \\\n",
        "176                                             74.9340                     \n",
        "177                                             79.0045                     \n",
        "178                                             74.0037                     \n",
        "179                                             74.1716                     \n",
        "180                                             74.1885                     \n",
        "181                                             76.8094                     \n",
        "182                                             80.2882                     \n",
        "183                                             79.2814                     \n",
        "184                                             79.4956                     \n",
        "185                                             77.6415                     \n",
        "186                                             77.6673                     \n",
        "187                                             81.5971                     \n",
        "188                                             82.9345                     \n",
        "189                                             87.8550                     \n",
        "190                                             88.9483                     \n",
        "191                                             89.7697                     \n",
        "192                                             87.7557                     \n",
        "193                                             85.4511                     \n",
        "194                                             86.1118                     \n",
        "195                                             79.3915                     \n",
        "196                                             85.0568                     \n",
        "197                                             83.6993                     \n",
        "1430                                          1170.6905                     \n",
        "1431                                          1141.5211                     \n",
        "1432                                          1100.8033                     \n",
        "1433                                          1089.9713                     \n",
        "1434                                          1075.3534                     \n",
        "1435                                          1069.1875                     \n",
        "1436                                          1090.0924                     \n",
        "1437                                          1054.5583                     \n",
        "1438                                          1041.1293                     \n",
        "1439                                          1003.8816                     \n",
        "1440                                           994.8552                     \n",
        "1441                                          1008.8681                     \n",
        "1442                                           993.1553                     \n",
        "1443                                           984.4538                     \n",
        "1444                                           985.5316                     \n",
        "1445                                           954.5998                     \n",
        "1446                                           965.5155                     \n",
        "1447                                           935.4004                     \n",
        "1448                                           938.7277                     \n",
        "1449                                           876.1988                     \n",
        "1450                                           903.9783                     \n",
        "1451                                           882.9341                     \n",
        "\n",
        "      Total GHG Emissions Including Land-Use Change and Forestry (MtCO2e)  \\\n",
        "176                                             62.1559                     \n",
        "177                                             66.2084                     \n",
        "178                                             61.1715                     \n",
        "179                                             61.3034                     \n",
        "180                                             61.2842                     \n",
        "181                                             63.8691                     \n",
        "182                                             67.3119                     \n",
        "183                                             66.2690                     \n",
        "184                                             66.4471                     \n",
        "185                                             64.5569                     \n",
        "186                                             64.5467                     \n",
        "187                                             64.3176                     \n",
        "188                                             65.6155                     \n",
        "189                                             70.4970                     \n",
        "190                                             71.5509                     \n",
        "191                                             72.3322                     \n",
        "192                                             92.3648                     \n",
        "193                                             90.0768                     \n",
        "194                                             90.7534                     \n",
        "195                                             84.0492                     \n",
        "196                                             89.7307                     \n",
        "197                                             88.3732                     \n",
        "1430                                          1107.4739                     \n",
        "1431                                          1078.1033                     \n",
        "1432                                          1036.9831                     \n",
        "1433                                          1025.7488                     \n",
        "1434                                          1010.7285                     \n",
        "1435                                          1004.1603                     \n",
        "1436                                          1024.6622                     \n",
        "1437                                           988.7256                     \n",
        "1438                                           974.8944                     \n",
        "1439                                           937.2443                     \n",
        "1440                                           927.8154                     \n",
        "1441                                           955.3679                     \n",
        "1442                                           939.6549                     \n",
        "1443                                           930.9535                     \n",
        "1444                                           932.0327                     \n",
        "1445                                           901.0995                     \n",
        "1446                                           888.5549                     \n",
        "1447                                           858.4334                     \n",
        "1448                                           861.8190                     \n",
        "1449                                           799.2322                     \n",
        "1450                                           827.0112                     \n",
        "1451                                           805.9671                     \n",
        "\n",
        "      Total CO? Excluding Land-Use Change and Forestry (MtCO2)  \\\n",
        "176                                             58.8802          \n",
        "177                                             63.0588          \n",
        "178                                             58.1662          \n",
        "179                                             58.4422          \n",
        "180                                             58.5672          \n",
        "181                                             61.2963          \n",
        "182                                             65.0609          \n",
        "183                                             64.3399          \n",
        "184                                             64.8399          \n",
        "185                                             63.2716          \n",
        "186                                             63.5833          \n",
        "187                                             67.7643          \n",
        "188                                             69.3529          \n",
        "189                                             74.5246          \n",
        "190                                             75.8691          \n",
        "191                                             76.9417          \n",
        "192                                             74.9182          \n",
        "193                                             72.6041          \n",
        "194                                             73.2554          \n",
        "195                                             66.5256          \n",
        "196                                             72.1815          \n",
        "197                                             70.6977          \n",
        "1430                                           968.4600          \n",
        "1431                                           942.9715          \n",
        "1432                                           905.9345          \n",
        "1433                                           898.7834          \n",
        "1434                                           887.8463          \n",
        "1435                                           885.3614          \n",
        "1436                                           913.1011          \n",
        "1437                                           884.4020          \n",
        "1438                                           877.8080          \n",
        "1439                                           847.3952          \n",
        "1440                                           845.2038          \n",
        "1441                                           861.7905          \n",
        "1442                                           848.6514          \n",
        "1443                                           842.5238          \n",
        "1444                                           846.1753          \n",
        "1445                                           817.8173          \n",
        "1446                                           832.3991          \n",
        "1447                                           805.9501          \n",
        "1448                                           812.9435          \n",
        "1449                                           754.0807          \n",
        "1450                                           785.5263          \n",
        "1451                                           765.9803          \n",
        "\n",
        "      Total CH4 (MtCO2e)  Total N2O (MtCO2e)  Total F-Gas (MtCO2e)  \\\n",
        "176             8.357588            6.260281              1.435894   \n",
        "177             8.215910            6.334795              1.394931   \n",
        "178             8.074233            6.409309              1.353969   \n",
        "179             7.932555            6.483823              1.313006   \n",
        "180             7.790877            6.558337              1.272043   \n",
        "181             7.649199            6.632851              1.231080   \n",
        "182             7.449835            6.564551              1.212927   \n",
        "183             7.250471            6.496251              1.194773   \n",
        "184             7.051106            6.427951              1.176619   \n",
        "185             6.851742            6.359651              1.158465   \n",
        "186             6.652378            6.291351              1.140311   \n",
        "187             6.543902            6.111568              1.177361   \n",
        "188             6.435426            5.931786              1.214410   \n",
        "189             6.326950            5.752004              1.251459   \n",
        "190             6.218474            5.572221              1.288508   \n",
        "191             6.109998            5.392439              1.325558   \n",
        "192             6.010376            5.455878              1.371213   \n",
        "193             5.910754            5.519316              1.416869   \n",
        "194             5.811132            5.582755              1.462525   \n",
        "195             5.711510            5.646194              1.508180   \n",
        "196             5.611888            5.709633              1.553836   \n",
        "197             5.619402            5.760892              1.621245   \n",
        "1430          105.603288           90.130354              6.496875   \n",
        "1431          102.488747           89.260737              6.800162   \n",
        "1432           99.374206           88.391119              7.103450   \n",
        "1433           96.259665           87.521502              7.406737   \n",
        "1434           93.145123           86.651884              7.710024   \n",
        "1435           90.030582           85.782267              8.013311   \n",
        "1436           86.450525           82.057757              8.482937   \n",
        "1437           82.870467           78.333246              8.952563   \n",
        "1438           79.290410           74.608736              9.422189   \n",
        "1439           75.710352           70.884225              9.891816   \n",
        "1440           72.130295           67.159715             10.361442   \n",
        "1441           69.152698           66.779153             11.145801   \n",
        "1442           66.175102           66.398590             11.930160   \n",
        "1443           63.197506           66.018028             12.714519   \n",
        "1444           60.219909           65.637465             13.498879   \n",
        "1445           57.242313           65.256903             14.283238   \n",
        "1446           54.315077           64.181395             14.619890   \n",
        "1447           51.387841           63.105887             14.956542   \n",
        "1448           48.460606           62.030379             15.293193   \n",
        "1449           45.533370           60.954871             15.629845   \n",
        "1450           42.606134           59.879363             15.966497   \n",
        "1451           42.020623           58.041694             16.891529   \n",
        "\n",
        "      Energy (MtCO2e)  Industrial Processes (MtCO2e)  Agriculture (MtCO2e)  \\\n",
        "176         57.655646                       5.035472              8.676659   \n",
        "177         61.793464                       5.042084              8.699697   \n",
        "178         56.921282                       4.997399              8.722735   \n",
        "179         57.259100                       4.901418              8.745773   \n",
        "180         57.466918                       4.794445              8.768811   \n",
        "181         60.684736                       4.251457              8.791849   \n",
        "182         64.444008                       4.266895              8.628689   \n",
        "183         63.703280                       4.256685              8.465528   \n",
        "184         64.202552                       4.257468              8.302367   \n",
        "185         62.641824                       4.239930              8.139207   \n",
        "186         62.961096                       4.222393              7.976046   \n",
        "187         67.137434                       4.123388              7.863260   \n",
        "188         68.693771                       4.072016              7.750474   \n",
        "189         73.900109                       3.943700              7.637688   \n",
        "190         75.036447                       4.068200              7.524901   \n",
        "191         76.012785                       4.060796              7.412115   \n",
        "192         73.828167                       4.278990              7.449715   \n",
        "193         71.323550                       4.526497              7.487315   \n",
        "194         71.908933                       4.649428              7.524916   \n",
        "195         65.504315                       4.391303              7.562516   \n",
        "196         71.339698                       4.268746              7.600116   \n",
        "197         69.767853                       4.421615              7.651142   \n",
        "1430       961.860808                      52.680302             87.002776   \n",
        "1431       962.310678                      51.837333             84.919839   \n",
        "1432       921.956391                      54.215020             82.836902   \n",
        "1433       913.488454                      54.592163             80.753965   \n",
        "1434       901.051336                      55.152506             78.671029   \n",
        "1435       898.230509                      54.558689             76.588092   \n",
        "1436       926.072973                      50.008721             76.738323   \n",
        "1437       894.411467                      48.543841             76.888555   \n",
        "1438       886.717341                      45.206658             77.038786   \n",
        "1439       855.872295                      41.191634             77.189018   \n",
        "1440       853.159689                      37.275539             77.339249   \n",
        "1441       870.599851                      36.515479             76.577768   \n",
        "1442       857.206014                      36.843627             75.816286   \n",
        "1443       849.401916                      38.593408             75.054805   \n",
        "1444       852.722459                      39.027812             74.293324   \n",
        "1445       823.977751                      39.487864             73.531842   \n",
        "1446       837.012320                      41.344575             71.007761   \n",
        "1447       810.448659                      41.768661             68.483679   \n",
        "1448       817.113968                      42.416251             65.959598   \n",
        "1449       759.576488                      41.400385             63.435516   \n",
        "1450       791.053957                      41.677912             60.911435   \n",
        "1451       769.594747                      42.752812             60.640635   \n",
        "\n",
        "      Waste (MtCO2e)  LUCF (MtCO2)  Bunker Fuels (MtCO2)  \\\n",
        "176         3.556211     -12.77809                  0.86   \n",
        "177         3.459241     -12.79612                  0.96   \n",
        "178         3.362271     -12.83217                  1.04   \n",
        "179         3.265301     -12.86823                  1.10   \n",
        "180         3.168330     -12.90428                  1.14   \n",
        "181         3.071360     -12.94033                  1.28   \n",
        "182         2.958649     -12.97639                  1.42   \n",
        "183         2.845937     -13.01246                  1.47   \n",
        "184         2.733225     -13.04851                  1.54   \n",
        "185         2.620513     -13.08456                  1.49   \n",
        "186         2.507801     -13.12062                  1.63   \n",
        "187         2.463037     -17.27952                  1.59   \n",
        "188         2.418272     -17.31901                  1.49   \n",
        "189         2.373508     -17.35805                  1.41   \n",
        "190         2.328744     -17.39736                  1.67   \n",
        "191         2.283979     -17.43743                  1.89   \n",
        "192         2.198834       4.60913                  1.98   \n",
        "193         2.113689       4.62574                  2.10   \n",
        "194         2.028544       4.64154                  2.11   \n",
        "195         1.943399       4.65771                  1.83   \n",
        "196         1.858254       4.67391                  1.98   \n",
        "197         1.858660       4.67391                  2.06   \n",
        "1430       43.111498     -63.21663                 21.13   \n",
        "1431       42.453248     -63.41781                 19.25   \n",
        "1432       41.794998     -63.82017                 19.08   \n",
        "1433       41.136747     -64.22252                 21.25   \n",
        "1434       40.478497     -64.62488                 22.09   \n",
        "1435       39.820247     -65.02723                 22.19   \n",
        "1436       37.272343     -65.43018                 22.49   \n",
        "1437       34.724440     -65.83274                 23.58   \n",
        "1438       32.176536     -66.23491                 23.87   \n",
        "1439       29.628632     -66.63727                 25.08   \n",
        "1440       27.080729     -67.03983                 26.35   \n",
        "1441       25.185046     -53.50029                 25.62   \n",
        "1442       23.289363     -53.50036                 26.11   \n",
        "1443       21.393680     -53.50034                 27.32   \n",
        "1444       19.497997     -53.49885                 29.26   \n",
        "1445       17.602314     -53.50032                 30.39   \n",
        "1446       16.150842     -76.96061                 31.80   \n",
        "1447       14.699371     -76.96702                 34.23   \n",
        "1448       13.247899     -76.90871                 34.27   \n",
        "1449       11.796427     -76.96658                 32.86   \n",
        "1450       10.344956     -76.96702                 32.70   \n",
        "1451        9.945956     -76.96702                 31.71   \n",
        "\n",
        "      Electricity/Heat (MtCO2)  Manufacturing/Construction (MtCO2)  \\\n",
        "176                      19.78                               10.08   \n",
        "177                      20.66                               10.59   \n",
        "178                      17.38                                9.67   \n",
        "179                      17.47                               10.08   \n",
        "180                      18.85                                9.84   \n",
        "181                      20.43                               10.12   \n",
        "182                      20.94                               10.36   \n",
        "183                      21.32                               11.68   \n",
        "184                      20.46                               10.90   \n",
        "185                      19.58                               10.21   \n",
        "186                      19.21                               11.30   \n",
        "187                      20.98                               11.05   \n",
        "188                      21.44                               10.96   \n",
        "189                      23.58                               11.70   \n",
        "190                      24.16                               12.38   \n",
        "191                      24.72                               12.62   \n",
        "192                      24.35                               12.61   \n",
        "193                      23.93                               12.11   \n",
        "194                      23.96                               13.41   \n",
        "195                      20.46                               12.28   \n",
        "196                      24.43                               12.25   \n",
        "197                      24.69                               12.16   \n",
        "1430                    402.63                              179.26   \n",
        "1431                    399.98                              153.93   \n",
        "1432                    383.75                              145.92   \n",
        "1433                    375.97                              137.48   \n",
        "1434                    376.24                              139.31   \n",
        "1435                    370.37                              140.07   \n",
        "1436                    381.12                              132.30   \n",
        "1437                    365.48                              131.08   \n",
        "1438                    365.47                              129.90   \n",
        "1439                    351.40                              124.34   \n",
        "1440                    356.29                              126.26   \n",
        "1441                    368.40                              120.29   \n",
        "1442                    370.17                              120.31   \n",
        "1443                    374.06                              117.61   \n",
        "1444                    382.16                              120.82   \n",
        "1445                    367.47                              120.26   \n",
        "1446                    373.75                              122.05   \n",
        "1447                    386.52                              123.57   \n",
        "1448                    366.85                              123.36   \n",
        "1449                    338.75                              106.06   \n",
        "1450                    353.46                              115.57   \n",
        "1451                    350.51                              114.15   \n",
        "\n",
        "      Transportation (MtCO2)  Other Fuel Combustion (MtCO2e)  \\\n",
        "176                    13.64                       13.946938   \n",
        "177                    15.03                       15.301357   \n",
        "178                    15.04                       14.615776   \n",
        "179                    15.18                       14.310195   \n",
        "180                    15.24                       13.314614   \n",
        "181                    15.45                       14.459033   \n",
        "182                    17.07                       15.850811   \n",
        "183                    16.15                       14.332590   \n",
        "184                    18.25                       14.374368   \n",
        "185                    17.76                       14.876146   \n",
        "186                    18.50                       13.737924   \n",
        "187                    19.97                       14.919769   \n",
        "188                    21.84                       14.231614   \n",
        "189                    23.40                       14.993459   \n",
        "190                    23.73                       14.535303   \n",
        "191                    24.45                       13.987148   \n",
        "192                    23.18                       13.454362   \n",
        "193                    23.37                       11.681576   \n",
        "194                    22.04                       12.268789   \n",
        "195                    21.47                       11.066003   \n",
        "196                    22.16                       12.273217   \n",
        "197                    21.62                       11.072787   \n",
        "1430                  157.59                      222.380808   \n",
        "1431                  160.28                      222.184333   \n",
        "1432                  162.79                      204.977857   \n",
        "1433                  167.36                      209.321382   \n",
        "1434                  164.81                      197.754907   \n",
        "1435                  166.68                      199.668432   \n",
        "1436                  167.78                      224.124015   \n",
        "1437                  168.43                      209.449598   \n",
        "1438                  171.33                      200.715181   \n",
        "1439                  176.11                      183.310764   \n",
        "1440                  171.89                      178.746347   \n",
        "1441                  167.96                      194.815112   \n",
        "1442                  165.55                      182.893877   \n",
        "1443                  160.62                      179.772642   \n",
        "1444                  162.64                      170.771408   \n",
        "1445                  154.89                      165.820173   \n",
        "1446                  152.48                      173.699382   \n",
        "1447                  148.23                      137.688592   \n",
        "1448                  147.02                      166.027801   \n",
        "1449                  147.16                      154.307011   \n",
        "1450                  147.01                      162.466221   \n",
        "1451                  148.74                      143.711204   \n",
        "\n",
        "      Fugitive Emissions (MtCO2e)  \n",
        "176                      0.208707  \n",
        "177                      0.212107  \n",
        "178                      0.215506  \n",
        "179                      0.218905  \n",
        "180                      0.222304  \n",
        "181                      0.225703  \n",
        "182                      0.223197  \n",
        "183                      0.220690  \n",
        "184                      0.218184  \n",
        "185                      0.215678  \n",
        "186                      0.213171  \n",
        "187                      0.217664  \n",
        "188                      0.222157  \n",
        "189                      0.226651  \n",
        "190                      0.231144  \n",
        "191                      0.235637  \n",
        "192                      0.233806  \n",
        "193                      0.231975  \n",
        "194                      0.230143  \n",
        "195                      0.228312  \n",
        "196                      0.226481  \n",
        "197                      0.225066  \n",
        "1430                          NaN  \n",
        "1431                    25.936346  \n",
        "1432                    24.518533  \n",
        "1433                    23.357071  \n",
        "1434                    22.936429  \n",
        "1435                    21.442077  \n",
        "1436                    20.748958  \n",
        "1437                    19.971869  \n",
        "1438                    19.302160  \n",
        "1439                    20.711531  \n",
        "1440                    19.973342  \n",
        "1441                    19.134739  \n",
        "1442                    18.282137  \n",
        "1443                    17.339274  \n",
        "1444                    16.331051  \n",
        "1445                    15.537578  \n",
        "1446                    15.032938  \n",
        "1447                    14.440068  \n",
        "1448                    13.856167  \n",
        "1449                    13.299477  \n",
        "1450                    12.547736  \n",
        "1451                    12.483543  "
       ]
      }
     ],
     "prompt_number": 44
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "scope1 = pd.read_pickle('data/scope1totals.pkl')"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 18
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "scope1.loc[\"Australia\", \"Energy\"]"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 52,
       "text": [
        "Scope 1    30550166\n",
        "Name: (Australia, Energy), dtype: float64"
       ]
      }
     ],
     "prompt_number": 52
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "import newf"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 53
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "newf.favcolumn(scope1, 4)"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        "hello\n"
       ]
      }
     ],
     "prompt_number": 54
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "reload(newf)"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 55,
       "text": [
        "<module 'newf' from 'newf.pyc'>"
       ]
      }
     ],
     "prompt_number": 55
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [],
     "language": "python",
     "metadata": {},
     "outputs": []
    }
   ],
   "metadata": {}
  }
 ]
}