Skip to content

Instantly share code, notes, and snippets.

@zaneselvans
Created July 6, 2018 22:41
Show Gist options
  • Save zaneselvans/f40c9e4ca6a68b8dcd2505e90ee9c9d6 to your computer and use it in GitHub Desktop.
Save zaneselvans/f40c9e4ca6a68b8dcd2505e90ee9c9d6 to your computer and use it in GitHub Desktop.
FERC Plant Classifier
Display the source blob
Display the rendered blob
Raw
{
"cells": [
{
"cell_type": "code",
"execution_count": 1,
"metadata": {},
"outputs": [],
"source": [
"%load_ext autoreload\n",
"%autoreload 2"
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {},
"outputs": [],
"source": [
"import sys\n",
"import os\n",
"import numpy as np\n",
"import scipy\n",
"import pandas as pd\n",
"import sqlalchemy as sa\n",
"sys.path.append(os.path.abspath(os.path.join('..','..','..')))\n",
"from pudl import init, mcoe, analysis, settings, outputs\n",
"import pudl.constants as pc\n",
"import pudl.extract.ferc1\n",
"from sklearn.metrics.pairwise import cosine_similarity\n",
"from sklearn.feature_extraction.text import TfidfVectorizer\n",
"from sklearn.preprocessing import LabelBinarizer\n",
"from sklearn.preprocessing import normalize\n",
"from sklearn.preprocessing import MinMaxScaler\n",
"from sklearn.preprocessing import scale\n",
"\n",
"import matplotlib.pyplot as plt\n",
"import matplotlib as mpl\n",
"%matplotlib inline\n",
"plt.style.use('ggplot')\n",
"mpl.rcParams['figure.figsize'] = (10,6)\n",
"mpl.rcParams['figure.dpi'] = 150\n",
"pd.options.display.max_columns = 56"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Pull in the large FERC plants data and simplify it"
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {
"scrolled": false
},
"outputs": [],
"source": [
"ferc1_engine = pudl.extract.ferc1.connect_db()\n",
"ferc1_steam = pd.read_sql('SELECT * FROM f1_steam;', ferc1_engine)\n",
"ferc1_steam = ferc1_steam.drop(['row_seq', 'row_prvlg','report_prd'], axis=1)"
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {},
"outputs": [],
"source": [
"diesel_strings = [\n",
" 'DIESEL',\n",
" 'Diesel Engine',\n",
" 'Diesel Turbine',\n",
"]\n",
"\n",
"geothermal_strings = [\n",
" 'Steam - Geothermal',\n",
"]\n",
"natural_gas_strings = [\n",
" 'Combined Cycle',\n",
" 'Combustion Turbine',\n",
" 'GT',\n",
" 'GAS TURBINE',\n",
" 'Comb. Turbine',\n",
" 'Gas Turbine #1',\n",
" 'Combine Cycle Oper',\n",
" 'Combustion',\n",
" 'Combined',\n",
" 'Gas Turbine/Steam',\n",
" 'Gas Turbine Peaker',\n",
" 'Gas Turbine - Note 1',\n",
" 'Resp Share Gas Note3',\n",
" 'Gas Turbines',\n",
" 'Simple Cycle',\n",
" 'Gas / Steam',\n",
" 'GasTurbine',\n",
" 'Combine Cycle',\n",
" 'CTG/Steam-Gas',\n",
" 'GTG/Gas',\n",
" 'CTG/Steam -Gas',\n",
" 'Steam/Gas Turbine',\n",
" 'CombustionTurbine',\n",
" 'Gas Turbine-Simple',\n",
" 'STEAM & GAS TURBINE',\n",
" 'Gas & Steam Turbine',\n",
" 'Gas',\n",
" 'Gas Turbine (2)',\n",
" 'COMBUSTION AND GAS',\n",
" 'Com Turbine Peaking',\n",
" 'Gas Turbine Peaking',\n",
" 'Comb Turb Peaking',\n",
" 'JET ENGINE',\n",
" 'Comb. Cyc',\n",
" 'Com. Cyc',\n",
" 'Com. Cycle',\n",
" 'GAS TURB-COMBINED CY',\n",
" 'Gas Turb',\n",
" 'Combined Cycle - 40%',\n",
" 'IGCC/Gas Turbine',\n",
" 'CC',\n",
" 'Combined Cycle Oper',\n",
" 'Simple Cycle Turbine',\n",
" 'Steam and CC',\n",
" 'Com Cycle Gas Turb',\n",
" 'I.C.E/ Gas Turbine',\n",
" 'Combined Cycle CTG',\n",
" 'GAS-TURBINE',\n",
" 'Gas Expander Turbine',\n",
" 'Gas Turbine (Leased)',\n",
" 'Gas Turbine # 1',\n",
" 'Gas Turbine (Note 1)',\n",
" 'COMBUSTINE TURBINE',\n",
" 'Gas Turb, Int. Comb.',\n",
" 'Combined Turbine',\n",
" 'Comb Turb Peak Units',\n",
" 'Combustion Tubine',\n",
" 'Comb. Cycle',\n",
" 'COMB.TURB.PEAK.UNITS',\n",
" 'Steam and CC',\n",
" 'I.C.E. /Gas Turbine',\n",
" 'Conbustion Turbine',\n",
" 'Gas Turbine/Int Comb',\n",
" 'Steam & CC',\n",
" 'GAS TURB. & HEAT REC',\n",
" 'Gas Turb/Comb. Cyc',\n",
" 'Comb. Turine',\n",
"]\n",
"nuclear_strings = [\n",
" 'Nuclear',\n",
" 'Nuclear (3)',\n",
"]\n",
"other_strings = [\n",
" 'IC',\n",
" 'Internal Combustion',\n",
" 'Int Combust - Note 1',\n",
" 'Resp. Share - Note 2',\n",
" 'Int. Combust - Note1',\n",
" 'Resp. Share - Note 4',\n",
" 'Resp Share - Note 5',\n",
" 'Resp. Share - Note 7',\n",
" 'Internal Comb Recip',\n",
" 'Reciprocating Engine',\n",
" 'Internal Comb',\n",
" 'Resp. Share - Note 8',\n",
" 'Resp. Share - Note 9',\n",
" 'Resp Share - Note 11',\n",
" 'Resp. Share - Note 6',\n",
" 'INT.COMBUSTINE',\n",
" 'Steam (Incl I.C.)',\n",
" 'Other',\n",
" 'Int Combust (Note 1)',\n",
" 'Resp. Share (Note 2)',\n",
" 'Int. Combust (Note1)',\n",
" 'Resp. Share (Note 8)',\n",
" 'Resp. Share (Note 9)',\n",
" 'Resp Share (Note 11)',\n",
" 'Resp. Share (Note 4)',\n",
" 'Resp. Share (Note 6)',\n",
" 'Plant retired- 2013',\n",
" 'Retired - 2013',\n",
"]\n",
"steam_strings = [\n",
" 'Steam',\n",
" 'Steam Units 1, 2, 3',\n",
" 'Resp Share St Note 3',\n",
" 'Steam Turbine',\n",
" 'Steam-Internal Comb',\n",
" 'IGCC',\n",
" 'Steam- 72%',\n",
" 'Steam (1)',\n",
" '\u0002Steam (1)',\n",
" 'Steam Units 1,2,3',\n",
" 'Steam/Fossil',\n",
" 'Steams',\n",
" 'Steam - 72%',\n",
" 'Steam - 100%',\n",
" 'Stream',\n",
" 'Steam Units 4, 5',\n",
" 'Steam - 64%',\n",
" 'Common',\n",
" 'Steam (A)',\n",
" 'Coal',\n",
" 'Steam;Retired - 2013',\n",
" 'Steam Units 4 & 6',\n",
"]\n",
"wind_strings = [\n",
" 'Wind',\n",
" 'Wind Turbine',\n",
" 'Wind - Turbine',\n",
" 'Wind Energy',\n",
"]\n",
"solar_strings = [\n",
" 'Solar Photovoltaic',\n",
" 'Solar Thermal',\n",
" 'SOLAR PROJECT',\n",
" 'Solar',\n",
" 'Photovoltaic',\n",
"]\n",
"cpi_plant_kind_map = {\n",
" 'natural_gas': natural_gas_strings,\n",
" 'diesel': diesel_strings,\n",
" 'geothermal': geothermal_strings,\n",
" 'nuclear': nuclear_strings,\n",
" 'steam': steam_strings,\n",
" 'wind': wind_strings,\n",
" 'solar': solar_strings,\n",
" 'other': other_strings,\n",
"}\n",
"\n",
"ferc1_steam['plant_kind_cpi'] = pudl.transform.pudl.cleanstrings(ferc1_steam.plant_kind,\n",
" cpi_plant_kind_map,\n",
" unmapped='')\n"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Create a unique record ID"
]
},
{
"cell_type": "code",
"execution_count": 5,
"metadata": {},
"outputs": [],
"source": [
"ferc1_steam['record_id'] = \\\n",
" ferc1_steam.report_year.astype(str) + \\\n",
" ferc1_steam.respondent_id.astype(str) + \\\n",
" ferc1_steam.spplmnt_num.astype(str) + \\\n",
" ferc1_steam.row_number.astype(str)\n",
"ferc1_steam['record_id'] = ferc1_steam.record_id.astype(int)"
]
},
{
"cell_type": "code",
"execution_count": 6,
"metadata": {},
"outputs": [],
"source": [
"# If there's no generation, no fuel expenses, and no total expenses... probably this is bunk.\n",
"mask_one = ((ferc1_steam.net_generation==0) | (ferc1_steam.net_generation.isnull())) & \\\n",
" ((ferc1_steam.expns_fuel==0) | (ferc1_steam.expns_fuel.isnull())) & \\\n",
" ((ferc1_steam.tot_prdctn_expns==0) | (ferc1_steam.tot_prdctn_expns.isnull()))\n",
"ferc1_steam = ferc1_steam[~mask_one].reset_index()\n",
"ferc1_steam['plant_name'] = ferc1_steam.plant_name.str.strip().str.lower().str.replace('\\s+',' ')\n",
"\n",
"matching_cols = [\n",
" 'record_id',\n",
" 'report_year',\n",
" 'spplmnt_num',\n",
" 'row_number',\n",
" 'respondent_id',\n",
" 'plant_name',\n",
" 'plant_kind_cpi',\n",
" 'yr_const',\n",
" 'tot_capacity'\n",
"]\n",
"\n",
"ferc1_tomatch = ferc1_steam[matching_cols]\n",
"ferc1_steam_new = ferc1_steam.drop(matching_cols, axis=1)\n",
"ferc1_steam_new = pd.merge(ferc1_tomatch, ferc1_steam_new, left_index=True, right_index=True)"
]
},
{
"cell_type": "code",
"execution_count": 7,
"metadata": {},
"outputs": [],
"source": [
"def vectorize_plants(plants,\n",
" ngram_range=(2,5),\n",
" sup_num_wt=1.0,\n",
" row_num_wt=1.0,\n",
" plant_name_wt=1.0,\n",
" yr_const_wt=1.0,\n",
" respondent_wt=1.0,\n",
" plant_kind_wt=1.0,\n",
" capacity_wt=1.0):\n",
" \"\"\"\n",
" Given a set of FERC Form 1 Plant records, vectorize and weight them for clustering.\n",
" \n",
" Uses TF-IDF w/ character based n-grams to vectorize plant names, and categorical\n",
" binary weights for the construction year, respondent ID, and plant type. Normalizes\n",
" the vectorized plant features before returning them.\n",
" \"\"\"\n",
" \n",
" plant_name_vectorizer = TfidfVectorizer(analyzer='char', ngram_range=ngram_range)\n",
" plant_name_vectors = plant_name_vectorizer.fit_transform(plants.plant_name)\n",
" \n",
" scaler = MinMaxScaler()\n",
" capacity_vectors = scaler.fit_transform(plants.tot_capacity.values.reshape(-1,1))\n",
" \n",
" lb_yr_const = LabelBinarizer()\n",
" yr_const_vectors = scipy.sparse.csr_matrix(lb_yr_const.fit_transform(plants.yr_const))\n",
" \n",
" lb_sup_num = LabelBinarizer()\n",
" sup_num_vectors = scipy.sparse.csr_matrix(lb_sup_num.fit_transform(plants.spplmnt_num))\n",
" \n",
" lb_row_num = LabelBinarizer()\n",
" row_num_vectors = scipy.sparse.csr_matrix(lb_row_num.fit_transform(plants.row_number))\n",
" \n",
" lb_respondent = LabelBinarizer()\n",
" respondent_vectors = scipy.sparse.csr_matrix(lb_respondent.fit_transform(plants.respondent_id))\n",
" \n",
" lb_plantkind = LabelBinarizer()\n",
" plant_kind_vectors = scipy.sparse.csr_matrix(lb_plantkind.fit_transform(plants.plant_kind_cpi))\n",
" \n",
" plant_vectors = normalize(scipy.sparse.hstack([\n",
" plant_name_vectors*plant_name_wt,\n",
" yr_const_vectors*yr_const_wt,\n",
" respondent_vectors*respondent_wt,\n",
" plant_kind_vectors*plant_kind_wt,\n",
" capacity_vectors*capacity_wt,\n",
" sup_num_vectors*sup_num_wt,\n",
" row_num_vectors*row_num_wt\n",
" ]))\n",
" return(plant_vectors)"
]
},
{
"cell_type": "code",
"execution_count": 8,
"metadata": {},
"outputs": [],
"source": [
"def best_by_year(plants_df, sim_df, min_sim=0.8):\n",
" out_df = plants_df.copy()\n",
" sim_df = sim_df[sim_df>=min_sim]\n",
" # make a copy of the similarity matrix and mask out fits below a threshold\n",
" years = plants_df.report_year.unique()\n",
" for yr in years:\n",
" newcol = yr\n",
" out_df[newcol]=-1\n",
" \n",
" # seed_yr is the year we are matching *from*\n",
" for seed_yr in years:\n",
" seed_idx = plants_df.index[plants_df.report_year==seed_yr]\n",
" # match_yr is all the other years, in which we are finding the best match\n",
" for match_yr in years:\n",
" bestof_yr = match_yr\n",
" match_idx = plants_df.index[plants_df.report_year==match_yr]\n",
" # For each record specified by seed_idx, obtain the index of\n",
" # the record within match_idx that that is the most similar.\n",
" best_idx = sim_df.iloc[seed_idx, match_idx].idxmax(axis=1)\n",
" out_df[bestof_yr].iloc[seed_idx]=best_idx\n",
" \n",
" #out_df = pd.merge(out_df, sim_df.iloc[yr_idx, y_idx].idxmax(axis=1).to_frame(), left_index=True, right_index=True)\n",
" return(out_df)"
]
},
{
"cell_type": "code",
"execution_count": 9,
"metadata": {},
"outputs": [],
"source": [
"def where_matches(match_idx, bestof_df):\n",
" years = bestof_df.report_year.unique()\n",
" out_idx = bestof[years][bestof[years]==match_idx].dropna(how='all').index.values\n",
" return(out_idx)"
]
},
{
"cell_type": "code",
"execution_count": 10,
"metadata": {},
"outputs": [],
"source": [
"def best_matches(match_idx, bestof_df):\n",
" years = bestof_df.report_year.unique()\n",
" out_idx = bestof_df.loc[match_idx,years].dropna().astype(int).values\n",
" return(out_idx)"
]
},
{
"cell_type": "code",
"execution_count": 11,
"metadata": {},
"outputs": [
{
"name": "stderr",
"output_type": "stream",
"text": [
"/Users/zaneselvans/anaconda/lib/python3.6/site-packages/pandas/core/indexing.py:194: SettingWithCopyWarning: \n",
"A value is trying to be set on a copy of a slice from a DataFrame\n",
"\n",
"See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n",
" self._setitem_with_indexer(indexer, value)\n"
]
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"0\n",
"bad record: 33\n",
"bad record: 34\n",
"bad record: 44\n",
"bad record: 45\n",
"bad record: 388\n",
"bad record: 476\n",
"bad record: 590\n",
"bad record: 739\n",
"bad record: 981\n",
"1000\n",
"bad record: 1236\n",
"bad record: 1611\n",
"bad record: 1612\n",
"bad record: 1659\n",
"bad record: 1703\n",
"bad record: 1704\n",
"bad record: 1714\n",
"bad record: 1715\n",
"2000\n",
"bad record: 2018\n",
"bad record: 2344\n",
"bad record: 2532\n",
"bad record: 2672\n",
"bad record: 2759\n",
"bad record: 2760\n",
"bad record: 2769\n",
"3000\n",
"bad record: 3007\n",
"bad record: 3437\n",
"bad record: 3451\n",
"bad record: 3455\n",
"bad record: 3474\n",
"bad record: 3476\n",
"bad record: 3481\n",
"bad record: 3482\n",
"bad record: 3592\n",
"bad record: 3907\n",
"4000\n",
"bad record: 4012\n",
"bad record: 4172\n",
"bad record: 4176\n",
"bad record: 4198\n",
"bad record: 4199\n",
"bad record: 4204\n",
"bad record: 4205\n",
"bad record: 4391\n",
"bad record: 4675\n",
"bad record: 4871\n",
"bad record: 4988\n",
"5000\n",
"bad record: 5110\n",
"bad record: 5376\n",
"bad record: 5510\n",
"bad record: 5514\n",
"bad record: 5536\n",
"bad record: 5537\n",
"bad record: 5542\n",
"bad record: 5543\n",
"bad record: 5594\n",
"6000\n",
"bad record: 6053\n",
"bad record: 6057\n",
"bad record: 6079\n",
"bad record: 6080\n",
"bad record: 6085\n",
"bad record: 6086\n",
"bad record: 6148\n",
"bad record: 6445\n",
"bad record: 6756\n",
"7000\n",
"bad record: 7253\n",
"bad record: 7630\n",
"bad record: 7664\n",
"bad record: 7668\n",
"bad record: 7690\n",
"bad record: 7691\n",
"bad record: 7696\n",
"bad record: 7697\n",
"bad record: 7739\n",
"8000\n",
"bad record: 8061\n",
"bad record: 8094\n",
"bad record: 8392\n",
"bad record: 8898\n",
"bad record: 8902\n",
"bad record: 8924\n",
"bad record: 8925\n",
"bad record: 8930\n",
"bad record: 8931\n",
"9000\n",
"bad record: 9074\n",
"bad record: 9084\n",
"bad record: 9531\n",
"bad record: 9883\n",
"bad record: 9887\n",
"bad record: 9909\n",
"bad record: 9910\n",
"bad record: 9915\n",
"bad record: 9916\n",
"10000\n",
"bad record: 10325\n",
"bad record: 10529\n",
"bad record: 10805\n",
"bad record: 10809\n",
"bad record: 10831\n",
"bad record: 10832\n",
"bad record: 10837\n",
"bad record: 10838\n",
"11000\n",
"bad record: 11024\n",
"bad record: 11028\n",
"bad record: 11050\n",
"bad record: 11051\n",
"bad record: 11056\n",
"bad record: 11057\n",
"bad record: 11059\n",
"bad record: 11165\n",
"12000\n",
"bad record: 12011\n",
"bad record: 12052\n",
"bad record: 12073\n",
"bad record: 12074\n",
"bad record: 12080\n",
"bad record: 12161\n"
]
}
],
"source": [
"fpv = vectorize_plants(ferc1_tomatch, plant_name_wt=2.0, sup_num_wt=0.25, row_num_wt=0.25)\n",
"sim_df = pd.DataFrame(cosine_similarity(fpv))\n",
"bestof = best_by_year(ferc1_tomatch, sim_df, min_sim=0.9)\n",
"bad_idx = []\n",
"for idx in bestof.index:\n",
" if idx%1000 == 0:\n",
" print(idx)\n",
" if not np.array_equiv(where_matches(idx, bestof), best_matches(idx, bestof)):\n",
" bad_idx = bad_idx + [idx,]\n",
" print('bad record: {}'.format(idx))"
]
},
{
"cell_type": "code",
"execution_count": 12,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"array([ 33, 34, 44, 45, 388, 476, 590, 739, 981,\n",
" 1236, 1611, 1612, 1659, 1703, 1704, 1714, 1715, 2018,\n",
" 2344, 2532, 2672, 2759, 2760, 2769, 3007, 3437, 3451,\n",
" 3455, 3474, 3476, 3481, 3482, 3592, 3907, 4012, 4172,\n",
" 4176, 4198, 4199, 4204, 4205, 4391, 4675, 4871, 4988,\n",
" 5110, 5376, 5510, 5514, 5536, 5537, 5542, 5543, 5594,\n",
" 6053, 6057, 6079, 6080, 6085, 6086, 6148, 6445, 6756,\n",
" 7253, 7630, 7664, 7668, 7690, 7691, 7696, 7697, 7739,\n",
" 8061, 8094, 8392, 8898, 8902, 8924, 8925, 8930, 8931,\n",
" 9074, 9084, 9531, 9883, 9887, 9909, 9910, 9915, 9916,\n",
" 10325, 10529, 10805, 10809, 10831, 10832, 10837, 10838, 11024,\n",
" 11028, 11050, 11051, 11056, 11057, 11059, 11165, 12011, 12052,\n",
" 12073, 12074, 12080, 12161])"
]
},
"execution_count": 12,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"np.array(bad_idx)"
]
},
{
"cell_type": "code",
"execution_count": 13,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"112"
]
},
"execution_count": 13,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"len(bad_idx)"
]
},
{
"cell_type": "code",
"execution_count": 14,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>record_id</th>\n",
" <th>report_year</th>\n",
" <th>spplmnt_num</th>\n",
" <th>row_number</th>\n",
" <th>respondent_id</th>\n",
" <th>plant_name</th>\n",
" <th>plant_kind_cpi</th>\n",
" <th>yr_const</th>\n",
" <th>tot_capacity</th>\n",
" <th>2004</th>\n",
" <th>2005</th>\n",
" <th>2006</th>\n",
" <th>2007</th>\n",
" <th>2008</th>\n",
" <th>2009</th>\n",
" <th>2010</th>\n",
" <th>2011</th>\n",
" <th>2012</th>\n",
" <th>2013</th>\n",
" <th>2014</th>\n",
" <th>2015</th>\n",
" <th>2016</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>476</th>\n",
" <td>200414102</td>\n",
" <td>2004</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>141</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>390.62</td>\n",
" <td>476.0</td>\n",
" <td>981.0</td>\n",
" <td>2018.0</td>\n",
" <td>3007.0</td>\n",
" <td>4012.0</td>\n",
" <td>4988.0</td>\n",
" <td>6756.0</td>\n",
" <td>7739.0</td>\n",
" <td>8061.0</td>\n",
" <td>9074.0</td>\n",
" <td>10325.0</td>\n",
" <td>11059.0</td>\n",
" <td>12011.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>981</th>\n",
" <td>200514102</td>\n",
" <td>2005</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>141</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>390.62</td>\n",
" <td>476.0</td>\n",
" <td>981.0</td>\n",
" <td>2018.0</td>\n",
" <td>3007.0</td>\n",
" <td>4012.0</td>\n",
" <td>4988.0</td>\n",
" <td>6756.0</td>\n",
" <td>7739.0</td>\n",
" <td>8061.0</td>\n",
" <td>9074.0</td>\n",
" <td>10325.0</td>\n",
" <td>11059.0</td>\n",
" <td>12011.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2018</th>\n",
" <td>200614102</td>\n",
" <td>2006</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>141</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>417.43</td>\n",
" <td>476.0</td>\n",
" <td>981.0</td>\n",
" <td>2018.0</td>\n",
" <td>3007.0</td>\n",
" <td>4012.0</td>\n",
" <td>4988.0</td>\n",
" <td>6756.0</td>\n",
" <td>7739.0</td>\n",
" <td>8061.0</td>\n",
" <td>9074.0</td>\n",
" <td>10325.0</td>\n",
" <td>11059.0</td>\n",
" <td>12011.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3007</th>\n",
" <td>200714102</td>\n",
" <td>2007</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>141</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>417.43</td>\n",
" <td>476.0</td>\n",
" <td>981.0</td>\n",
" <td>2018.0</td>\n",
" <td>3007.0</td>\n",
" <td>4012.0</td>\n",
" <td>4988.0</td>\n",
" <td>6756.0</td>\n",
" <td>7739.0</td>\n",
" <td>8061.0</td>\n",
" <td>9074.0</td>\n",
" <td>10325.0</td>\n",
" <td>11059.0</td>\n",
" <td>12011.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4012</th>\n",
" <td>200814102</td>\n",
" <td>2008</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>141</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>417.43</td>\n",
" <td>476.0</td>\n",
" <td>981.0</td>\n",
" <td>2018.0</td>\n",
" <td>3007.0</td>\n",
" <td>4012.0</td>\n",
" <td>4988.0</td>\n",
" <td>6756.0</td>\n",
" <td>7739.0</td>\n",
" <td>8061.0</td>\n",
" <td>9074.0</td>\n",
" <td>10325.0</td>\n",
" <td>11059.0</td>\n",
" <td>12011.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4988</th>\n",
" <td>200914102</td>\n",
" <td>2009</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>141</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>417.43</td>\n",
" <td>476.0</td>\n",
" <td>981.0</td>\n",
" <td>2018.0</td>\n",
" <td>3007.0</td>\n",
" <td>4012.0</td>\n",
" <td>4988.0</td>\n",
" <td>6756.0</td>\n",
" <td>7739.0</td>\n",
" <td>8061.0</td>\n",
" <td>9074.0</td>\n",
" <td>10325.0</td>\n",
" <td>11059.0</td>\n",
" <td>12011.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6756</th>\n",
" <td>201014102</td>\n",
" <td>2010</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>141</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>417.43</td>\n",
" <td>476.0</td>\n",
" <td>981.0</td>\n",
" <td>2018.0</td>\n",
" <td>3007.0</td>\n",
" <td>4012.0</td>\n",
" <td>4988.0</td>\n",
" <td>6756.0</td>\n",
" <td>7739.0</td>\n",
" <td>8061.0</td>\n",
" <td>9074.0</td>\n",
" <td>10325.0</td>\n",
" <td>11059.0</td>\n",
" <td>12011.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7739</th>\n",
" <td>201114102</td>\n",
" <td>2011</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>141</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>417.43</td>\n",
" <td>476.0</td>\n",
" <td>981.0</td>\n",
" <td>2018.0</td>\n",
" <td>3007.0</td>\n",
" <td>4012.0</td>\n",
" <td>4988.0</td>\n",
" <td>6756.0</td>\n",
" <td>7739.0</td>\n",
" <td>8061.0</td>\n",
" <td>9074.0</td>\n",
" <td>10325.0</td>\n",
" <td>11059.0</td>\n",
" <td>12011.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8061</th>\n",
" <td>201214102</td>\n",
" <td>2012</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>141</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>417.43</td>\n",
" <td>476.0</td>\n",
" <td>981.0</td>\n",
" <td>2018.0</td>\n",
" <td>3007.0</td>\n",
" <td>4012.0</td>\n",
" <td>4988.0</td>\n",
" <td>6756.0</td>\n",
" <td>7739.0</td>\n",
" <td>8061.0</td>\n",
" <td>9074.0</td>\n",
" <td>10325.0</td>\n",
" <td>11059.0</td>\n",
" <td>12011.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9074</th>\n",
" <td>201314102</td>\n",
" <td>2013</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>141</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>513.76</td>\n",
" <td>476.0</td>\n",
" <td>981.0</td>\n",
" <td>2018.0</td>\n",
" <td>3007.0</td>\n",
" <td>4012.0</td>\n",
" <td>4988.0</td>\n",
" <td>6756.0</td>\n",
" <td>7739.0</td>\n",
" <td>8061.0</td>\n",
" <td>9074.0</td>\n",
" <td>10325.0</td>\n",
" <td>11059.0</td>\n",
" <td>12011.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10325</th>\n",
" <td>201414101</td>\n",
" <td>2014</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>141</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>642.20</td>\n",
" <td>475.0</td>\n",
" <td>980.0</td>\n",
" <td>2017.0</td>\n",
" <td>3006.0</td>\n",
" <td>4011.0</td>\n",
" <td>4987.0</td>\n",
" <td>6755.0</td>\n",
" <td>7738.0</td>\n",
" <td>8060.0</td>\n",
" <td>9073.0</td>\n",
" <td>10325.0</td>\n",
" <td>11059.0</td>\n",
" <td>12011.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11059</th>\n",
" <td>201514101</td>\n",
" <td>2015</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>141</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>642.20</td>\n",
" <td>475.0</td>\n",
" <td>980.0</td>\n",
" <td>2017.0</td>\n",
" <td>3006.0</td>\n",
" <td>4011.0</td>\n",
" <td>4987.0</td>\n",
" <td>6755.0</td>\n",
" <td>7738.0</td>\n",
" <td>8060.0</td>\n",
" <td>9073.0</td>\n",
" <td>10325.0</td>\n",
" <td>11059.0</td>\n",
" <td>12011.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12011</th>\n",
" <td>201614101</td>\n",
" <td>2016</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>141</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>642.20</td>\n",
" <td>475.0</td>\n",
" <td>980.0</td>\n",
" <td>2017.0</td>\n",
" <td>3006.0</td>\n",
" <td>4011.0</td>\n",
" <td>4987.0</td>\n",
" <td>6755.0</td>\n",
" <td>7738.0</td>\n",
" <td>8060.0</td>\n",
" <td>9073.0</td>\n",
" <td>10325.0</td>\n",
" <td>11059.0</td>\n",
" <td>12011.0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" record_id report_year spplmnt_num row_number respondent_id \\\n",
"476 200414102 2004 0 2 141 \n",
"981 200514102 2005 0 2 141 \n",
"2018 200614102 2006 0 2 141 \n",
"3007 200714102 2007 0 2 141 \n",
"4012 200814102 2008 0 2 141 \n",
"4988 200914102 2009 0 2 141 \n",
"6756 201014102 2010 0 2 141 \n",
"7739 201114102 2011 0 2 141 \n",
"8061 201214102 2012 0 2 141 \n",
"9074 201314102 2013 0 2 141 \n",
"10325 201414101 2014 0 1 141 \n",
"11059 201514101 2015 0 1 141 \n",
"12011 201614101 2016 0 1 141 \n",
"\n",
" plant_name plant_kind_cpi yr_const tot_capacity 2004 2005 2006 \\\n",
"476 boardman steam 1980 390.62 476.0 981.0 2018.0 \n",
"981 boardman steam 1980 390.62 476.0 981.0 2018.0 \n",
"2018 boardman steam 1980 417.43 476.0 981.0 2018.0 \n",
"3007 boardman steam 1980 417.43 476.0 981.0 2018.0 \n",
"4012 boardman steam 1980 417.43 476.0 981.0 2018.0 \n",
"4988 boardman steam 1980 417.43 476.0 981.0 2018.0 \n",
"6756 boardman steam 1980 417.43 476.0 981.0 2018.0 \n",
"7739 boardman steam 1980 417.43 476.0 981.0 2018.0 \n",
"8061 boardman steam 1980 417.43 476.0 981.0 2018.0 \n",
"9074 boardman steam 1980 513.76 476.0 981.0 2018.0 \n",
"10325 boardman steam 1980 642.20 475.0 980.0 2017.0 \n",
"11059 boardman steam 1980 642.20 475.0 980.0 2017.0 \n",
"12011 boardman steam 1980 642.20 475.0 980.0 2017.0 \n",
"\n",
" 2007 2008 2009 2010 2011 2012 2013 2014 \\\n",
"476 3007.0 4012.0 4988.0 6756.0 7739.0 8061.0 9074.0 10325.0 \n",
"981 3007.0 4012.0 4988.0 6756.0 7739.0 8061.0 9074.0 10325.0 \n",
"2018 3007.0 4012.0 4988.0 6756.0 7739.0 8061.0 9074.0 10325.0 \n",
"3007 3007.0 4012.0 4988.0 6756.0 7739.0 8061.0 9074.0 10325.0 \n",
"4012 3007.0 4012.0 4988.0 6756.0 7739.0 8061.0 9074.0 10325.0 \n",
"4988 3007.0 4012.0 4988.0 6756.0 7739.0 8061.0 9074.0 10325.0 \n",
"6756 3007.0 4012.0 4988.0 6756.0 7739.0 8061.0 9074.0 10325.0 \n",
"7739 3007.0 4012.0 4988.0 6756.0 7739.0 8061.0 9074.0 10325.0 \n",
"8061 3007.0 4012.0 4988.0 6756.0 7739.0 8061.0 9074.0 10325.0 \n",
"9074 3007.0 4012.0 4988.0 6756.0 7739.0 8061.0 9074.0 10325.0 \n",
"10325 3006.0 4011.0 4987.0 6755.0 7738.0 8060.0 9073.0 10325.0 \n",
"11059 3006.0 4011.0 4987.0 6755.0 7738.0 8060.0 9073.0 10325.0 \n",
"12011 3006.0 4011.0 4987.0 6755.0 7738.0 8060.0 9073.0 10325.0 \n",
"\n",
" 2015 2016 \n",
"476 11059.0 12011.0 \n",
"981 11059.0 12011.0 \n",
"2018 11059.0 12011.0 \n",
"3007 11059.0 12011.0 \n",
"4012 11059.0 12011.0 \n",
"4988 11059.0 12011.0 \n",
"6756 11059.0 12011.0 \n",
"7739 11059.0 12011.0 \n",
"8061 11059.0 12011.0 \n",
"9074 11059.0 12011.0 \n",
"10325 11059.0 12011.0 \n",
"11059 11059.0 12011.0 \n",
"12011 11059.0 12011.0 "
]
},
"execution_count": 14,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"n=476\n",
"bestof.loc[best_matches(n, bestof)]"
]
},
{
"cell_type": "code",
"execution_count": 18,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>record_id</th>\n",
" <th>report_year</th>\n",
" <th>spplmnt_num</th>\n",
" <th>row_number</th>\n",
" <th>respondent_id</th>\n",
" <th>plant_name</th>\n",
" <th>plant_kind_cpi</th>\n",
" <th>yr_const</th>\n",
" <th>tot_capacity</th>\n",
" <th>2004</th>\n",
" <th>2005</th>\n",
" <th>2006</th>\n",
" <th>2007</th>\n",
" <th>2008</th>\n",
" <th>2009</th>\n",
" <th>2010</th>\n",
" <th>2011</th>\n",
" <th>2012</th>\n",
" <th>2013</th>\n",
" <th>2014</th>\n",
" <th>2015</th>\n",
" <th>2016</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>476</th>\n",
" <td>200414102</td>\n",
" <td>2004</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>141</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>390.62</td>\n",
" <td>476.0</td>\n",
" <td>981.0</td>\n",
" <td>2018.0</td>\n",
" <td>3007.0</td>\n",
" <td>4012.0</td>\n",
" <td>4988.0</td>\n",
" <td>6756.0</td>\n",
" <td>7739.0</td>\n",
" <td>8061.0</td>\n",
" <td>9074.0</td>\n",
" <td>10325.0</td>\n",
" <td>11059.0</td>\n",
" <td>12011.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>981</th>\n",
" <td>200514102</td>\n",
" <td>2005</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>141</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>390.62</td>\n",
" <td>476.0</td>\n",
" <td>981.0</td>\n",
" <td>2018.0</td>\n",
" <td>3007.0</td>\n",
" <td>4012.0</td>\n",
" <td>4988.0</td>\n",
" <td>6756.0</td>\n",
" <td>7739.0</td>\n",
" <td>8061.0</td>\n",
" <td>9074.0</td>\n",
" <td>10325.0</td>\n",
" <td>11059.0</td>\n",
" <td>12011.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2018</th>\n",
" <td>200614102</td>\n",
" <td>2006</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>141</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>417.43</td>\n",
" <td>476.0</td>\n",
" <td>981.0</td>\n",
" <td>2018.0</td>\n",
" <td>3007.0</td>\n",
" <td>4012.0</td>\n",
" <td>4988.0</td>\n",
" <td>6756.0</td>\n",
" <td>7739.0</td>\n",
" <td>8061.0</td>\n",
" <td>9074.0</td>\n",
" <td>10325.0</td>\n",
" <td>11059.0</td>\n",
" <td>12011.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3007</th>\n",
" <td>200714102</td>\n",
" <td>2007</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>141</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>417.43</td>\n",
" <td>476.0</td>\n",
" <td>981.0</td>\n",
" <td>2018.0</td>\n",
" <td>3007.0</td>\n",
" <td>4012.0</td>\n",
" <td>4988.0</td>\n",
" <td>6756.0</td>\n",
" <td>7739.0</td>\n",
" <td>8061.0</td>\n",
" <td>9074.0</td>\n",
" <td>10325.0</td>\n",
" <td>11059.0</td>\n",
" <td>12011.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4012</th>\n",
" <td>200814102</td>\n",
" <td>2008</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>141</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>417.43</td>\n",
" <td>476.0</td>\n",
" <td>981.0</td>\n",
" <td>2018.0</td>\n",
" <td>3007.0</td>\n",
" <td>4012.0</td>\n",
" <td>4988.0</td>\n",
" <td>6756.0</td>\n",
" <td>7739.0</td>\n",
" <td>8061.0</td>\n",
" <td>9074.0</td>\n",
" <td>10325.0</td>\n",
" <td>11059.0</td>\n",
" <td>12011.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4988</th>\n",
" <td>200914102</td>\n",
" <td>2009</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>141</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>417.43</td>\n",
" <td>476.0</td>\n",
" <td>981.0</td>\n",
" <td>2018.0</td>\n",
" <td>3007.0</td>\n",
" <td>4012.0</td>\n",
" <td>4988.0</td>\n",
" <td>6756.0</td>\n",
" <td>7739.0</td>\n",
" <td>8061.0</td>\n",
" <td>9074.0</td>\n",
" <td>10325.0</td>\n",
" <td>11059.0</td>\n",
" <td>12011.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6756</th>\n",
" <td>201014102</td>\n",
" <td>2010</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>141</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>417.43</td>\n",
" <td>476.0</td>\n",
" <td>981.0</td>\n",
" <td>2018.0</td>\n",
" <td>3007.0</td>\n",
" <td>4012.0</td>\n",
" <td>4988.0</td>\n",
" <td>6756.0</td>\n",
" <td>7739.0</td>\n",
" <td>8061.0</td>\n",
" <td>9074.0</td>\n",
" <td>10325.0</td>\n",
" <td>11059.0</td>\n",
" <td>12011.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7739</th>\n",
" <td>201114102</td>\n",
" <td>2011</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>141</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>417.43</td>\n",
" <td>476.0</td>\n",
" <td>981.0</td>\n",
" <td>2018.0</td>\n",
" <td>3007.0</td>\n",
" <td>4012.0</td>\n",
" <td>4988.0</td>\n",
" <td>6756.0</td>\n",
" <td>7739.0</td>\n",
" <td>8061.0</td>\n",
" <td>9074.0</td>\n",
" <td>10325.0</td>\n",
" <td>11059.0</td>\n",
" <td>12011.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8061</th>\n",
" <td>201214102</td>\n",
" <td>2012</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>141</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>417.43</td>\n",
" <td>476.0</td>\n",
" <td>981.0</td>\n",
" <td>2018.0</td>\n",
" <td>3007.0</td>\n",
" <td>4012.0</td>\n",
" <td>4988.0</td>\n",
" <td>6756.0</td>\n",
" <td>7739.0</td>\n",
" <td>8061.0</td>\n",
" <td>9074.0</td>\n",
" <td>10325.0</td>\n",
" <td>11059.0</td>\n",
" <td>12011.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9074</th>\n",
" <td>201314102</td>\n",
" <td>2013</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>141</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>513.76</td>\n",
" <td>476.0</td>\n",
" <td>981.0</td>\n",
" <td>2018.0</td>\n",
" <td>3007.0</td>\n",
" <td>4012.0</td>\n",
" <td>4988.0</td>\n",
" <td>6756.0</td>\n",
" <td>7739.0</td>\n",
" <td>8061.0</td>\n",
" <td>9074.0</td>\n",
" <td>10325.0</td>\n",
" <td>11059.0</td>\n",
" <td>12011.0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" record_id report_year spplmnt_num row_number respondent_id \\\n",
"476 200414102 2004 0 2 141 \n",
"981 200514102 2005 0 2 141 \n",
"2018 200614102 2006 0 2 141 \n",
"3007 200714102 2007 0 2 141 \n",
"4012 200814102 2008 0 2 141 \n",
"4988 200914102 2009 0 2 141 \n",
"6756 201014102 2010 0 2 141 \n",
"7739 201114102 2011 0 2 141 \n",
"8061 201214102 2012 0 2 141 \n",
"9074 201314102 2013 0 2 141 \n",
"\n",
" plant_name plant_kind_cpi yr_const tot_capacity 2004 2005 2006 \\\n",
"476 boardman steam 1980 390.62 476.0 981.0 2018.0 \n",
"981 boardman steam 1980 390.62 476.0 981.0 2018.0 \n",
"2018 boardman steam 1980 417.43 476.0 981.0 2018.0 \n",
"3007 boardman steam 1980 417.43 476.0 981.0 2018.0 \n",
"4012 boardman steam 1980 417.43 476.0 981.0 2018.0 \n",
"4988 boardman steam 1980 417.43 476.0 981.0 2018.0 \n",
"6756 boardman steam 1980 417.43 476.0 981.0 2018.0 \n",
"7739 boardman steam 1980 417.43 476.0 981.0 2018.0 \n",
"8061 boardman steam 1980 417.43 476.0 981.0 2018.0 \n",
"9074 boardman steam 1980 513.76 476.0 981.0 2018.0 \n",
"\n",
" 2007 2008 2009 2010 2011 2012 2013 2014 \\\n",
"476 3007.0 4012.0 4988.0 6756.0 7739.0 8061.0 9074.0 10325.0 \n",
"981 3007.0 4012.0 4988.0 6756.0 7739.0 8061.0 9074.0 10325.0 \n",
"2018 3007.0 4012.0 4988.0 6756.0 7739.0 8061.0 9074.0 10325.0 \n",
"3007 3007.0 4012.0 4988.0 6756.0 7739.0 8061.0 9074.0 10325.0 \n",
"4012 3007.0 4012.0 4988.0 6756.0 7739.0 8061.0 9074.0 10325.0 \n",
"4988 3007.0 4012.0 4988.0 6756.0 7739.0 8061.0 9074.0 10325.0 \n",
"6756 3007.0 4012.0 4988.0 6756.0 7739.0 8061.0 9074.0 10325.0 \n",
"7739 3007.0 4012.0 4988.0 6756.0 7739.0 8061.0 9074.0 10325.0 \n",
"8061 3007.0 4012.0 4988.0 6756.0 7739.0 8061.0 9074.0 10325.0 \n",
"9074 3007.0 4012.0 4988.0 6756.0 7739.0 8061.0 9074.0 10325.0 \n",
"\n",
" 2015 2016 \n",
"476 11059.0 12011.0 \n",
"981 11059.0 12011.0 \n",
"2018 11059.0 12011.0 \n",
"3007 11059.0 12011.0 \n",
"4012 11059.0 12011.0 \n",
"4988 11059.0 12011.0 \n",
"6756 11059.0 12011.0 \n",
"7739 11059.0 12011.0 \n",
"8061 11059.0 12011.0 \n",
"9074 11059.0 12011.0 "
]
},
"execution_count": 18,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"bestof.loc[where_matches(n, bestof)]"
]
},
{
"cell_type": "code",
"execution_count": 19,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>record_id</th>\n",
" <th>report_year</th>\n",
" <th>spplmnt_num</th>\n",
" <th>row_number</th>\n",
" <th>respondent_id</th>\n",
" <th>plant_name</th>\n",
" <th>plant_kind_cpi</th>\n",
" <th>yr_const</th>\n",
" <th>tot_capacity</th>\n",
" <th>index</th>\n",
" <th>plant_kind</th>\n",
" <th>type_const</th>\n",
" <th>yr_installed</th>\n",
" <th>peak_demand</th>\n",
" <th>plant_hours</th>\n",
" <th>plnt_capability</th>\n",
" <th>when_not_limited</th>\n",
" <th>when_limited</th>\n",
" <th>avg_num_of_emp</th>\n",
" <th>net_generation</th>\n",
" <th>cost_land</th>\n",
" <th>cost_structure</th>\n",
" <th>cost_equipment</th>\n",
" <th>cost_of_plant_to</th>\n",
" <th>cost_per_kw</th>\n",
" <th>expns_operations</th>\n",
" <th>expns_fuel</th>\n",
" <th>expns_coolants</th>\n",
" <th>expns_steam</th>\n",
" <th>expns_steam_othr</th>\n",
" <th>expns_transfer</th>\n",
" <th>expns_electric</th>\n",
" <th>expns_misc_power</th>\n",
" <th>expns_rents</th>\n",
" <th>expns_allowances</th>\n",
" <th>expns_engnr</th>\n",
" <th>expns_structures</th>\n",
" <th>expns_boiler</th>\n",
" <th>expns_plants</th>\n",
" <th>expns_misc_steam</th>\n",
" <th>tot_prdctn_expns</th>\n",
" <th>expns_kwh</th>\n",
" <th>asset_retire_cost</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>475</th>\n",
" <td>200414101</td>\n",
" <td>2004</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>141</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>600.96</td>\n",
" <td>817</td>\n",
" <td>Steam</td>\n",
" <td>Conventional</td>\n",
" <td>1980</td>\n",
" <td>609.0</td>\n",
" <td>6449.0</td>\n",
" <td>0.0</td>\n",
" <td>585.0</td>\n",
" <td>585.0</td>\n",
" <td>105.0</td>\n",
" <td>3.540098e+09</td>\n",
" <td>1240068.0</td>\n",
" <td>149500146.0</td>\n",
" <td>452506392.0</td>\n",
" <td>604085247.0</td>\n",
" <td>1005.2004</td>\n",
" <td>6764874.0</td>\n",
" <td>44256851.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1192631.0</td>\n",
" <td>3618051.0</td>\n",
" <td>-7770.0</td>\n",
" <td>23500625.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>194192.0</td>\n",
" <td>79519454.0</td>\n",
" <td>0.0225</td>\n",
" <td>838641.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>476</th>\n",
" <td>200414102</td>\n",
" <td>2004</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>141</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>390.62</td>\n",
" <td>818</td>\n",
" <td>Steam</td>\n",
" <td>Conventional</td>\n",
" <td>1980</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>2.305031e+09</td>\n",
" <td>798844.0</td>\n",
" <td>98069397.0</td>\n",
" <td>289787875.0</td>\n",
" <td>389278233.0</td>\n",
" <td>996.5650</td>\n",
" <td>4457560.0</td>\n",
" <td>29909037.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>789729.0</td>\n",
" <td>2688319.0</td>\n",
" <td>0.0</td>\n",
" <td>15116268.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>119863.0</td>\n",
" <td>53080776.0</td>\n",
" <td>0.0230</td>\n",
" <td>622117.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>876</th>\n",
" <td>20047002</td>\n",
" <td>2004</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>70</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>56.05</td>\n",
" <td>1671</td>\n",
" <td>Steam</td>\n",
" <td>Conventional</td>\n",
" <td>1980</td>\n",
" <td>60.0</td>\n",
" <td>6448.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>3.535430e+08</td>\n",
" <td>106610.0</td>\n",
" <td>13575473.0</td>\n",
" <td>51815464.0</td>\n",
" <td>65497547.0</td>\n",
" <td>1168.5557</td>\n",
" <td>821222.0</td>\n",
" <td>4409531.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>145173.0</td>\n",
" <td>431771.0</td>\n",
" <td>0.0</td>\n",
" <td>2670682.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>26742.0</td>\n",
" <td>8505121.0</td>\n",
" <td>0.0241</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>980</th>\n",
" <td>200514101</td>\n",
" <td>2005</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>141</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>600.96</td>\n",
" <td>1891</td>\n",
" <td>Steam</td>\n",
" <td>Conventional</td>\n",
" <td>1980</td>\n",
" <td>592.0</td>\n",
" <td>6235.0</td>\n",
" <td>0.0</td>\n",
" <td>585.0</td>\n",
" <td>585.0</td>\n",
" <td>106.0</td>\n",
" <td>3.561174e+09</td>\n",
" <td>1240068.0</td>\n",
" <td>153565948.0</td>\n",
" <td>466586460.0</td>\n",
" <td>622231117.0</td>\n",
" <td>1035.3952</td>\n",
" <td>5974221.0</td>\n",
" <td>47834482.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>2169872.0</td>\n",
" <td>1138860.0</td>\n",
" <td>-19387.0</td>\n",
" <td>19085827.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>259476.0</td>\n",
" <td>76443351.0</td>\n",
" <td>0.0215</td>\n",
" <td>838641.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>981</th>\n",
" <td>200514102</td>\n",
" <td>2005</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>141</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>390.62</td>\n",
" <td>1892</td>\n",
" <td>Steam</td>\n",
" <td>Conventional</td>\n",
" <td>1980</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>2.309497e+09</td>\n",
" <td>798844.0</td>\n",
" <td>102118006.0</td>\n",
" <td>298819315.0</td>\n",
" <td>402358283.0</td>\n",
" <td>1030.0504</td>\n",
" <td>3818762.0</td>\n",
" <td>31124332.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1432334.0</td>\n",
" <td>640712.0</td>\n",
" <td>0.0</td>\n",
" <td>12396430.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>89610.0</td>\n",
" <td>49502180.0</td>\n",
" <td>0.0214</td>\n",
" <td>622118.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1878</th>\n",
" <td>20057002</td>\n",
" <td>2005</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>70</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>56.05</td>\n",
" <td>3456</td>\n",
" <td>Steam</td>\n",
" <td>Conventional</td>\n",
" <td>1980</td>\n",
" <td>60.0</td>\n",
" <td>6233.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>3.571800e+08</td>\n",
" <td>106610.0</td>\n",
" <td>13616489.0</td>\n",
" <td>54897896.0</td>\n",
" <td>68620995.0</td>\n",
" <td>1224.2818</td>\n",
" <td>753718.0</td>\n",
" <td>4612849.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>217308.0</td>\n",
" <td>149158.0</td>\n",
" <td>0.0</td>\n",
" <td>1952145.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>15071.0</td>\n",
" <td>7700249.0</td>\n",
" <td>0.0216</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2017</th>\n",
" <td>200614101</td>\n",
" <td>2006</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>141</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>642.20</td>\n",
" <td>3715</td>\n",
" <td>Steam</td>\n",
" <td>Conventional</td>\n",
" <td>1980</td>\n",
" <td>590.0</td>\n",
" <td>4357.0</td>\n",
" <td>0.0</td>\n",
" <td>585.0</td>\n",
" <td>585.0</td>\n",
" <td>109.0</td>\n",
" <td>2.414553e+09</td>\n",
" <td>1240068.0</td>\n",
" <td>150839967.0</td>\n",
" <td>468952624.0</td>\n",
" <td>621871300.0</td>\n",
" <td>968.3452</td>\n",
" <td>5989289.0</td>\n",
" <td>35492843.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>2066716.0</td>\n",
" <td>257963.0</td>\n",
" <td>0.0</td>\n",
" <td>18694086.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>108473.0</td>\n",
" <td>62609370.0</td>\n",
" <td>0.0259</td>\n",
" <td>838641.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2018</th>\n",
" <td>200614102</td>\n",
" <td>2006</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>141</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>417.43</td>\n",
" <td>3716</td>\n",
" <td>Steam</td>\n",
" <td>Conventional</td>\n",
" <td>1980</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.564573e+09</td>\n",
" <td>798844.0</td>\n",
" <td>99277301.0</td>\n",
" <td>301165155.0</td>\n",
" <td>401863417.0</td>\n",
" <td>962.7085</td>\n",
" <td>3742813.0</td>\n",
" <td>22218265.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1341837.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>11752427.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>67827.0</td>\n",
" <td>39123169.0</td>\n",
" <td>0.0250</td>\n",
" <td>622117.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2851</th>\n",
" <td>20067002</td>\n",
" <td>2006</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>70</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>64.22</td>\n",
" <td>5226</td>\n",
" <td>Steam</td>\n",
" <td>Conventional</td>\n",
" <td>1980</td>\n",
" <td>59.0</td>\n",
" <td>4362.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>2.415570e+08</td>\n",
" <td>106610.0</td>\n",
" <td>13664764.0</td>\n",
" <td>54705143.0</td>\n",
" <td>68476517.0</td>\n",
" <td>1066.2802</td>\n",
" <td>864657.0</td>\n",
" <td>3429448.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>236070.0</td>\n",
" <td>8426.0</td>\n",
" <td>0.0</td>\n",
" <td>2439498.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>14663.0</td>\n",
" <td>6992762.0</td>\n",
" <td>0.0289</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3006</th>\n",
" <td>200714101</td>\n",
" <td>2007</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>141</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>642.20</td>\n",
" <td>5515</td>\n",
" <td>Steam</td>\n",
" <td>Conventional</td>\n",
" <td>1980</td>\n",
" <td>595.0</td>\n",
" <td>6686.0</td>\n",
" <td>0.0</td>\n",
" <td>585.0</td>\n",
" <td>585.0</td>\n",
" <td>110.0</td>\n",
" <td>4.354531e+09</td>\n",
" <td>1240068.0</td>\n",
" <td>151883454.0</td>\n",
" <td>474946319.0</td>\n",
" <td>628908482.0</td>\n",
" <td>979.3031</td>\n",
" <td>6763843.0</td>\n",
" <td>61041164.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>2169128.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>19406261.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>163697.0</td>\n",
" <td>89544093.0</td>\n",
" <td>0.0206</td>\n",
" <td>838641.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3007</th>\n",
" <td>200714102</td>\n",
" <td>2007</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>141</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>417.43</td>\n",
" <td>5516</td>\n",
" <td>Steam</td>\n",
" <td>Conventional</td>\n",
" <td>1980</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>2.827461e+09</td>\n",
" <td>798844.0</td>\n",
" <td>99959737.0</td>\n",
" <td>304980403.0</td>\n",
" <td>406361101.0</td>\n",
" <td>973.4832</td>\n",
" <td>4420104.0</td>\n",
" <td>39933425.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1387631.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>12370455.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>106530.0</td>\n",
" <td>58218145.0</td>\n",
" <td>0.0206</td>\n",
" <td>622117.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3747</th>\n",
" <td>20077002</td>\n",
" <td>2007</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>70</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>64.22</td>\n",
" <td>6936</td>\n",
" <td>Steam</td>\n",
" <td>Conventional</td>\n",
" <td>1980</td>\n",
" <td>60.0</td>\n",
" <td>7703.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>4.366160e+08</td>\n",
" <td>106610.0</td>\n",
" <td>13754891.0</td>\n",
" <td>55799812.0</td>\n",
" <td>69661313.0</td>\n",
" <td>1084.7293</td>\n",
" <td>833210.0</td>\n",
" <td>6291429.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>253061.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>2288516.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>16285.0</td>\n",
" <td>9682501.0</td>\n",
" <td>0.0222</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4011</th>\n",
" <td>200814101</td>\n",
" <td>2008</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>141</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>642.20</td>\n",
" <td>7410</td>\n",
" <td>Steam</td>\n",
" <td>Conventional</td>\n",
" <td>1980</td>\n",
" <td>596.0</td>\n",
" <td>7201.0</td>\n",
" <td>0.0</td>\n",
" <td>575.0</td>\n",
" <td>575.0</td>\n",
" <td>113.0</td>\n",
" <td>4.015022e+09</td>\n",
" <td>1240068.0</td>\n",
" <td>153089559.0</td>\n",
" <td>478459697.0</td>\n",
" <td>633627965.0</td>\n",
" <td>986.6521</td>\n",
" <td>7757870.0</td>\n",
" <td>60662131.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>2519263.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>21183396.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>125384.0</td>\n",
" <td>92248044.0</td>\n",
" <td>0.0230</td>\n",
" <td>838641.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4012</th>\n",
" <td>200814102</td>\n",
" <td>2008</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>141</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>417.43</td>\n",
" <td>7411</td>\n",
" <td>Steam</td>\n",
" <td>Conventional</td>\n",
" <td>1980</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>2.610551e+09</td>\n",
" <td>798843.0</td>\n",
" <td>100809820.0</td>\n",
" <td>307130858.0</td>\n",
" <td>409361638.0</td>\n",
" <td>980.6713</td>\n",
" <td>5145778.0</td>\n",
" <td>38989787.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1627230.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>13494993.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>80608.0</td>\n",
" <td>59338396.0</td>\n",
" <td>0.0227</td>\n",
" <td>622117.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4779</th>\n",
" <td>20087002</td>\n",
" <td>2008</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>70</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>64.22</td>\n",
" <td>8916</td>\n",
" <td>Steam</td>\n",
" <td>Conventional</td>\n",
" <td>1980</td>\n",
" <td>60.0</td>\n",
" <td>7209.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>4.026360e+08</td>\n",
" <td>106610.0</td>\n",
" <td>13794057.0</td>\n",
" <td>56385936.0</td>\n",
" <td>70286603.0</td>\n",
" <td>1094.4659</td>\n",
" <td>926650.0</td>\n",
" <td>6023661.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>272497.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>2515460.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>13876.0</td>\n",
" <td>9752144.0</td>\n",
" <td>0.0242</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4987</th>\n",
" <td>200914101</td>\n",
" <td>2009</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>141</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>642.20</td>\n",
" <td>9231</td>\n",
" <td>Steam</td>\n",
" <td>Conventional</td>\n",
" <td>1980</td>\n",
" <td>599.0</td>\n",
" <td>5695.0</td>\n",
" <td>0.0</td>\n",
" <td>575.0</td>\n",
" <td>575.0</td>\n",
" <td>112.0</td>\n",
" <td>3.159247e+09</td>\n",
" <td>1240068.0</td>\n",
" <td>152856712.0</td>\n",
" <td>489558594.0</td>\n",
" <td>648618993.0</td>\n",
" <td>1009.9953</td>\n",
" <td>7567507.0</td>\n",
" <td>53067361.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1930679.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>16619501.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>96765.0</td>\n",
" <td>79281813.0</td>\n",
" <td>0.0251</td>\n",
" <td>4963619.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4988</th>\n",
" <td>200914102</td>\n",
" <td>2009</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>141</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>417.43</td>\n",
" <td>9232</td>\n",
" <td>Steam</td>\n",
" <td>Conventional</td>\n",
" <td>1980</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>2.046588e+09</td>\n",
" <td>798843.0</td>\n",
" <td>100927122.0</td>\n",
" <td>314437075.0</td>\n",
" <td>420356762.0</td>\n",
" <td>1007.0114</td>\n",
" <td>4974219.0</td>\n",
" <td>34702584.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1276587.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>10068645.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>64643.0</td>\n",
" <td>51086678.0</td>\n",
" <td>0.0250</td>\n",
" <td>4193722.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5009</th>\n",
" <td>20097002</td>\n",
" <td>2009</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>70</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>64.20</td>\n",
" <td>9293</td>\n",
" <td>Steam</td>\n",
" <td>Conventional</td>\n",
" <td>1980</td>\n",
" <td>60.0</td>\n",
" <td>5694.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>3.174000e+08</td>\n",
" <td>106610.0</td>\n",
" <td>13781170.0</td>\n",
" <td>57221112.0</td>\n",
" <td>71108892.0</td>\n",
" <td>1107.6151</td>\n",
" <td>884620.0</td>\n",
" <td>5437088.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>175428.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>2048845.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>7273.0</td>\n",
" <td>8553254.0</td>\n",
" <td>0.0269</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6277</th>\n",
" <td>20107002</td>\n",
" <td>2010</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>70</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>64.20</td>\n",
" <td>11607</td>\n",
" <td>Steam</td>\n",
" <td>Conventional</td>\n",
" <td>1980</td>\n",
" <td>60.0</td>\n",
" <td>7538.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>4.168740e+08</td>\n",
" <td>106610.0</td>\n",
" <td>13810712.0</td>\n",
" <td>57625476.0</td>\n",
" <td>71542798.0</td>\n",
" <td>1114.3738</td>\n",
" <td>1129338.0</td>\n",
" <td>7273624.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>273881.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>2144265.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>9475.0</td>\n",
" <td>10830583.0</td>\n",
" <td>0.0260</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6755</th>\n",
" <td>201014101</td>\n",
" <td>2010</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>141</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>642.20</td>\n",
" <td>12535</td>\n",
" <td>Steam</td>\n",
" <td>Conventional</td>\n",
" <td>1980</td>\n",
" <td>584.0</td>\n",
" <td>7538.0</td>\n",
" <td>0.0</td>\n",
" <td>575.0</td>\n",
" <td>575.0</td>\n",
" <td>111.0</td>\n",
" <td>4.087303e+09</td>\n",
" <td>1240068.0</td>\n",
" <td>153062273.0</td>\n",
" <td>494483228.0</td>\n",
" <td>655613764.0</td>\n",
" <td>1020.8872</td>\n",
" <td>7143046.0</td>\n",
" <td>70282502.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>2489341.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>16705721.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>49277.0</td>\n",
" <td>96669887.0</td>\n",
" <td>0.0237</td>\n",
" <td>6828195.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6756</th>\n",
" <td>201014102</td>\n",
" <td>2010</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>141</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>417.43</td>\n",
" <td>12536</td>\n",
" <td>Steam</td>\n",
" <td>Conventional</td>\n",
" <td>1980</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>2.651352e+09</td>\n",
" <td>798843.0</td>\n",
" <td>101044056.0</td>\n",
" <td>317788376.0</td>\n",
" <td>424987086.0</td>\n",
" <td>1018.1038</td>\n",
" <td>4343234.0</td>\n",
" <td>46512845.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1601514.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>10520345.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>25007.0</td>\n",
" <td>63002945.0</td>\n",
" <td>0.0238</td>\n",
" <td>5355811.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7115</th>\n",
" <td>20117002</td>\n",
" <td>2011</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>70</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>64.20</td>\n",
" <td>13121</td>\n",
" <td>Steam</td>\n",
" <td>Conventional</td>\n",
" <td>1980</td>\n",
" <td>60.0</td>\n",
" <td>6927.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>2.877660e+08</td>\n",
" <td>106610.0</td>\n",
" <td>13839832.0</td>\n",
" <td>60888268.0</td>\n",
" <td>74834710.0</td>\n",
" <td>1165.6497</td>\n",
" <td>903348.0</td>\n",
" <td>5683939.0</td>\n",
" <td>0.0</td>\n",
" <td>83277.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>594345.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>2028723.0</td>\n",
" <td>43886.0</td>\n",
" <td>1064.0</td>\n",
" <td>235224.0</td>\n",
" <td>421392.0</td>\n",
" <td>9995198.0</td>\n",
" <td>0.0347</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7738</th>\n",
" <td>201114101</td>\n",
" <td>2011</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>141</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>642.20</td>\n",
" <td>14360</td>\n",
" <td>Steam</td>\n",
" <td>Conventional</td>\n",
" <td>1980</td>\n",
" <td>598.0</td>\n",
" <td>6208.0</td>\n",
" <td>0.0</td>\n",
" <td>575.0</td>\n",
" <td>575.0</td>\n",
" <td>112.0</td>\n",
" <td>3.305796e+09</td>\n",
" <td>1274078.0</td>\n",
" <td>153132849.0</td>\n",
" <td>533895764.0</td>\n",
" <td>722281236.0</td>\n",
" <td>1124.6983</td>\n",
" <td>5378605.0</td>\n",
" <td>63468760.0</td>\n",
" <td>0.0</td>\n",
" <td>2386700.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>7176916.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>5723519.0</td>\n",
" <td>369601.0</td>\n",
" <td>7725.0</td>\n",
" <td>10443437.0</td>\n",
" <td>4573460.0</td>\n",
" <td>99528723.0</td>\n",
" <td>0.0301</td>\n",
" <td>33978545.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7739</th>\n",
" <td>201114102</td>\n",
" <td>2011</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>141</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>417.43</td>\n",
" <td>14361</td>\n",
" <td>Steam</td>\n",
" <td>Conventional</td>\n",
" <td>1980</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>2.191433e+09</td>\n",
" <td>832853.0</td>\n",
" <td>101073073.0</td>\n",
" <td>346266930.0</td>\n",
" <td>473362124.0</td>\n",
" <td>1133.9916</td>\n",
" <td>2799461.0</td>\n",
" <td>41507187.0</td>\n",
" <td>0.0</td>\n",
" <td>2209294.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>4662468.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>279135.0</td>\n",
" <td>285020.0</td>\n",
" <td>5773.0</td>\n",
" <td>10244782.0</td>\n",
" <td>2485078.0</td>\n",
" <td>64478198.0</td>\n",
" <td>0.0294</td>\n",
" <td>25189268.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8060</th>\n",
" <td>201214101</td>\n",
" <td>2012</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>141</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>642.20</td>\n",
" <td>14890</td>\n",
" <td>Steam</td>\n",
" <td>Conventional</td>\n",
" <td>1980</td>\n",
" <td>589.0</td>\n",
" <td>5562.0</td>\n",
" <td>0.0</td>\n",
" <td>575.0</td>\n",
" <td>575.0</td>\n",
" <td>110.0</td>\n",
" <td>2.603796e+09</td>\n",
" <td>1274078.0</td>\n",
" <td>155985238.0</td>\n",
" <td>545337678.0</td>\n",
" <td>736575539.0</td>\n",
" <td>1146.9566</td>\n",
" <td>3435187.0</td>\n",
" <td>55938280.0</td>\n",
" <td>0.0</td>\n",
" <td>3350254.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>4997436.0</td>\n",
" <td>0.0</td>\n",
" <td>105984.0</td>\n",
" <td>589130.0</td>\n",
" <td>3804.0</td>\n",
" <td>1309374.0</td>\n",
" <td>17943703.0</td>\n",
" <td>269205.0</td>\n",
" <td>87942357.0</td>\n",
" <td>0.0338</td>\n",
" <td>33978545.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8061</th>\n",
" <td>201214102</td>\n",
" <td>2012</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>141</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>417.43</td>\n",
" <td>14891</td>\n",
" <td>Steam</td>\n",
" <td>Conventional</td>\n",
" <td>1980</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.708157e+09</td>\n",
" <td>832853.0</td>\n",
" <td>103163607.0</td>\n",
" <td>356558026.0</td>\n",
" <td>485743754.0</td>\n",
" <td>1163.6532</td>\n",
" <td>2096421.0</td>\n",
" <td>35435628.0</td>\n",
" <td>0.0</td>\n",
" <td>2113125.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>3271731.0</td>\n",
" <td>0.0</td>\n",
" <td>105984.0</td>\n",
" <td>282934.0</td>\n",
" <td>2628.0</td>\n",
" <td>852544.0</td>\n",
" <td>11648733.0</td>\n",
" <td>168233.0</td>\n",
" <td>55977961.0</td>\n",
" <td>0.0328</td>\n",
" <td>25189268.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8853</th>\n",
" <td>20127002</td>\n",
" <td>2012</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>70</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>64.20</td>\n",
" <td>16491</td>\n",
" <td>Steam</td>\n",
" <td>Conventional</td>\n",
" <td>1980</td>\n",
" <td>60.0</td>\n",
" <td>5561.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>2.301760e+08</td>\n",
" <td>106610.0</td>\n",
" <td>13910931.0</td>\n",
" <td>60588342.0</td>\n",
" <td>74605883.0</td>\n",
" <td>1162.0854</td>\n",
" <td>590272.0</td>\n",
" <td>4991249.0</td>\n",
" <td>0.0</td>\n",
" <td>424389.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>473728.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>197376.0</td>\n",
" <td>166.0</td>\n",
" <td>128927.0</td>\n",
" <td>1817633.0</td>\n",
" <td>36324.0</td>\n",
" <td>8660064.0</td>\n",
" <td>0.0376</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9073</th>\n",
" <td>201314101</td>\n",
" <td>2013</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" <td>141</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>642.20</td>\n",
" <td>16890</td>\n",
" <td>Steam</td>\n",
" <td>Conventional</td>\n",
" <td>1980</td>\n",
" <td>578.0</td>\n",
" <td>7253.0</td>\n",
" <td>0.0</td>\n",
" <td>708.0</td>\n",
" <td>575.0</td>\n",
" <td>113.0</td>\n",
" <td>3.733393e+09</td>\n",
" <td>1274078.0</td>\n",
" <td>158631187.0</td>\n",
" <td>579275460.0</td>\n",
" <td>780109406.0</td>\n",
" <td>1214.7453</td>\n",
" <td>3195671.0</td>\n",
" <td>71128121.0</td>\n",
" <td>0.0</td>\n",
" <td>5162929.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>5609481.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>448534.0</td>\n",
" <td>388537.0</td>\n",
" <td>2264007.0</td>\n",
" <td>17221525.0</td>\n",
" <td>179653.0</td>\n",
" <td>105598458.0</td>\n",
" <td>0.0283</td>\n",
" <td>40928681.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9074</th>\n",
" <td>201314102</td>\n",
" <td>2013</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" <td>141</td>\n",
" <td>boardman</td>\n",
" <td>steam</td>\n",
" <td>1980</td>\n",
" <td>513.76</td>\n",
" <td>16891</td>\n",
" <td>Steam</td>\n",
" <td>Conventional</td>\n",
" <td>1980</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>2.454997e+09</td>\n",
" <td>832853.0</td>\n",
" <td>104930863.0</td>\n",
" <td>381770601.0</td>\n",
" <td>519935668.0</td>\n",
" <td>1012.0205</td>\n",
" <td>1945523.0</td>\n",
" <td>47744397.0</td>\n",
" <td>0.0</td>\n",
" <td>3268230.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>3637867.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>282052.0</td>\n",
" <td>249734.0</td>\n",
" <td>1463238.0</td>\n",
" <td>10991172.0</td>\n",
" <td>118113.0</td>\n",
" <td>69700326.0</td>\n",