Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

@zaneselvans

zaneselvans/ferc_plant_sklearn.ipynb

Created July 6, 2018 22:41
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save zaneselvans/f40c9e4ca6a68b8dcd2505e90ee9c9d6 to your computer and use it in GitHub Desktop.
Save zaneselvans/f40c9e4ca6a68b8dcd2505e90ee9c9d6 to your computer and use it in GitHub Desktop.
Download ZIP
FERC Plant Classifier
Display the source blob
Display the rendered blob
Raw
ferc_plant_sklearn.ipynb
{
"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",
" <td>0.0284</td>\n",
" <td>32401351.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9739</th>\n",
" <td>20137002</td>\n",
" <td>2013</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>18268</td>\n",
" <td>Steam</td>\n",
" <td>Conventional</td>\n",
" <td>1980</td>\n",
" <td>61.0</td>\n",
" <td>7254.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.280260e+08</td>\n",
" <td>106610.0</td>\n",
" <td>14291124.0</td>\n",
" <td>60881102.0</td>\n",
" <td>79354415.0</td>\n",
" <td>1236.0501</td>\n",
" <td>502428.0</td>\n",
" <td>6433944.0</td>\n",
" <td>0.0</td>\n",
" <td>637875.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>580476.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>58089.0</td>\n",
" <td>42751.0</td>\n",
" <td>237986.0</td>\n",
" <td>2009281.0</td>\n",
" <td>16636.0</td>\n",
" <td>10519466.0</td>\n",
" <td>0.0321</td>\n",
" <td>4075579.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10249</th>\n",
" <td>20147002</td>\n",
" <td>2014</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>19341</td>\n",
" <td>Steam</td>\n",
" <td>Conventional</td>\n",
" <td>1980</td>\n",
" <td>62.0</td>\n",
" <td>6585.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.693350e+08</td>\n",
" <td>106610.0</td>\n",
" <td>12408084.0</td>\n",
" <td>63479074.0</td>\n",
" <td>80341990.0</td>\n",
" <td>1251.4329</td>\n",
" <td>537592.0</td>\n",
" <td>6671067.0</td>\n",
" <td>0.0</td>\n",
" <td>777278.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1020470.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>198355.0</td>\n",
" <td>65928.0</td>\n",
" <td>262078.0</td>\n",
" <td>2123156.0</td>\n",
" <td>24292.0</td>\n",
" <td>11680216.0</td>\n",
" <td>0.0434</td>\n",
" <td>4348222.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>19480</td>\n",
" <td>Steam</td>\n",
" <td>Conventional</td>\n",
" <td>1980</td>\n",
" <td>602.0</td>\n",
" <td>6586.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.156002e+09</td>\n",
" <td>939463.0</td>\n",
" <td>153125738.0</td>\n",
" <td>573361223.0</td>\n",
" <td>769958411.0</td>\n",
" <td>1198.9387</td>\n",
" <td>2813003.0</td>\n",
" <td>80763450.0</td>\n",
" <td>0.0</td>\n",
" <td>5956318.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>10264791.0</td>\n",
" <td>0.0</td>\n",
" <td>113328.0</td>\n",
" <td>880559.0</td>\n",
" <td>647531.0</td>\n",
" <td>2531412.0</td>\n",
" <td>20999605.0</td>\n",
" <td>222308.0</td>\n",
" <td>125192305.0</td>\n",
" <td>0.0397</td>\n",
" <td>42531987.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>20910</td>\n",
" <td>Steam</td>\n",
" <td>Conventional</td>\n",
" <td>1980</td>\n",
" <td>599.0</td>\n",
" <td>4993.0</td>\n",
" <td>0.0</td>\n",
" <td>575.0</td>\n",
" <td>575.0</td>\n",
" <td>119.0</td>\n",
" <td>2.350188e+09</td>\n",
" <td>939463.0</td>\n",
" <td>153328063.0</td>\n",
" <td>575882623.0</td>\n",
" <td>782216600.0</td>\n",
" <td>1218.0265</td>\n",
" <td>2885072.0</td>\n",
" <td>62999916.0</td>\n",
" <td>0.0</td>\n",
" <td>5737718.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>6741084.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>748164.0</td>\n",
" <td>704930.0</td>\n",
" <td>1688797.0</td>\n",
" <td>16887198.0</td>\n",
" <td>442088.0</td>\n",
" <td>98834967.0</td>\n",
" <td>0.0421</td>\n",
" <td>52066451.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11449</th>\n",
" <td>20157002</td>\n",
" <td>2015</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>21801</td>\n",
" <td>Steam</td>\n",
" <td>Conventional</td>\n",
" <td>1980</td>\n",
" <td>64.0</td>\n",
" <td>5017.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.829410e+08</td>\n",
" <td>106610.0</td>\n",
" <td>12492016.0</td>\n",
" <td>63613298.0</td>\n",
" <td>80643355.0</td>\n",
" <td>1256.1270</td>\n",
" <td>397405.0</td>\n",
" <td>4737072.0</td>\n",
" <td>0.0</td>\n",
" <td>771734.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>393762.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>12840.0</td>\n",
" <td>87640.0</td>\n",
" <td>223505.0</td>\n",
" <td>1967645.0</td>\n",
" <td>46900.0</td>\n",
" <td>8638503.0</td>\n",
" <td>0.0472</td>\n",
" <td>4431431.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>22900</td>\n",
" <td>Steam</td>\n",
" <td>Conventional</td>\n",
" <td>1980</td>\n",
" <td>606.0</td>\n",
" <td>3952.0</td>\n",
" <td>0.0</td>\n",
" <td>575.0</td>\n",
" <td>575.0</td>\n",
" <td>94.0</td>\n",
" <td>1.732571e+09</td>\n",
" <td>939463.0</td>\n",
" <td>153519689.0</td>\n",
" <td>576836193.0</td>\n",
" <td>781448382.0</td>\n",
" <td>1216.8302</td>\n",
" <td>2996280.0</td>\n",
" <td>47178273.0</td>\n",
" <td>0.0</td>\n",
" <td>5598882.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>6547856.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>490934.0</td>\n",
" <td>371580.0</td>\n",
" <td>1714393.0</td>\n",
" <td>12039972.0</td>\n",
" <td>546793.0</td>\n",
" <td>77484963.0</td>\n",
" <td>0.0447</td>\n",
" <td>50153037.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12434</th>\n",
" <td>20167002</td>\n",
" <td>2016</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>23821</td>\n",
" <td>Steam</td>\n",
" <td>Conventional</td>\n",
" <td>1980</td>\n",
" <td>60.0</td>\n",
" <td>3952.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.342530e+08</td>\n",
" <td>106610.0</td>\n",
" <td>12627358.0</td>\n",
" <td>63694825.0</td>\n",
" <td>81809557.0</td>\n",
" <td>1274.2922</td>\n",
" <td>446094.0</td>\n",
" <td>3412551.0</td>\n",
" <td>0.0</td>\n",
" <td>687008.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>790829.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>73194.0</td>\n",
" <td>45008.0</td>\n",
" <td>165264.0</td>\n",
" <td>1373692.0</td>\n",
" <td>50491.0</td>\n",
" <td>7044131.0</td>\n",
" <td>0.0525</td>\n",
" <td>5380764.0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" record_id report_year spplmnt_num row_number respondent_id \\\n",
"475 200414101 2004 0 1 141 \n",
"476 200414102 2004 0 2 141 \n",
"876 20047002 2004 0 2 70 \n",
"980 200514101 2005 0 1 141 \n",
"981 200514102 2005 0 2 141 \n",
"1878 20057002 2005 0 2 70 \n",
"2017 200614101 2006 0 1 141 \n",
"2018 200614102 2006 0 2 141 \n",
"2851 20067002 2006 0 2 70 \n",
"3006 200714101 2007 0 1 141 \n",
"3007 200714102 2007 0 2 141 \n",
"3747 20077002 2007 0 2 70 \n",
"4011 200814101 2008 0 1 141 \n",
"4012 200814102 2008 0 2 141 \n",
"4779 20087002 2008 0 2 70 \n",
"4987 200914101 2009 0 1 141 \n",
"4988 200914102 2009 0 2 141 \n",
"5009 20097002 2009 0 2 70 \n",
"6277 20107002 2010 0 2 70 \n",
"6755 201014101 2010 0 1 141 \n",
"6756 201014102 2010 0 2 141 \n",
"7115 20117002 2011 0 2 70 \n",
"7738 201114101 2011 0 1 141 \n",
"7739 201114102 2011 0 2 141 \n",
"8060 201214101 2012 0 1 141 \n",
"8061 201214102 2012 0 2 141 \n",
"8853 20127002 2012 0 2 70 \n",
"9073 201314101 2013 0 1 141 \n",
"9074 201314102 2013 0 2 141 \n",
"9739 20137002 2013 0 2 70 \n",
"10249 20147002 2014 0 2 70 \n",
"10325 201414101 2014 0 1 141 \n",
"11059 201514101 2015 0 1 141 \n",
"11449 20157002 2015 0 2 70 \n",
"12011 201614101 2016 0 1 141 \n",
"12434 20167002 2016 0 2 70 \n",
"\n",
" plant_name plant_kind_cpi yr_const tot_capacity index plant_kind \\\n",
"475 boardman steam 1980 600.96 817 Steam \n",
"476 boardman steam 1980 390.62 818 Steam \n",
"876 boardman steam 1980 56.05 1671 Steam \n",
"980 boardman steam 1980 600.96 1891 Steam \n",
"981 boardman steam 1980 390.62 1892 Steam \n",
"1878 boardman steam 1980 56.05 3456 Steam \n",
"2017 boardman steam 1980 642.20 3715 Steam \n",
"2018 boardman steam 1980 417.43 3716 Steam \n",
"2851 boardman steam 1980 64.22 5226 Steam \n",
"3006 boardman steam 1980 642.20 5515 Steam \n",
"3007 boardman steam 1980 417.43 5516 Steam \n",
"3747 boardman steam 1980 64.22 6936 Steam \n",
"4011 boardman steam 1980 642.20 7410 Steam \n",
"4012 boardman steam 1980 417.43 7411 Steam \n",
"4779 boardman steam 1980 64.22 8916 Steam \n",
"4987 boardman steam 1980 642.20 9231 Steam \n",
"4988 boardman steam 1980 417.43 9232 Steam \n",
"5009 boardman steam 1980 64.20 9293 Steam \n",
"6277 boardman steam 1980 64.20 11607 Steam \n",
"6755 boardman steam 1980 642.20 12535 Steam \n",
"6756 boardman steam 1980 417.43 12536 Steam \n",
"7115 boardman steam 1980 64.20 13121 Steam \n",
"7738 boardman steam 1980 642.20 14360 Steam \n",
"7739 boardman steam 1980 417.43 14361 Steam \n",
"8060 boardman steam 1980 642.20 14890 Steam \n",
"8061 boardman steam 1980 417.43 14891 Steam \n",
"8853 boardman steam 1980 64.20 16491 Steam \n",
"9073 boardman steam 1980 642.20 16890 Steam \n",
"9074 boardman steam 1980 513.76 16891 Steam \n",
"9739 boardman steam 1980 64.20 18268 Steam \n",
"10249 boardman steam 1980 64.20 19341 Steam \n",
"10325 boardman steam 1980 642.20 19480 Steam \n",
"11059 boardman steam 1980 642.20 20910 Steam \n",
"11449 boardman steam 1980 64.20 21801 Steam \n",
"12011 boardman steam 1980 642.20 22900 Steam \n",
"12434 boardman steam 1980 64.20 23821 Steam \n",
"\n",
" type_const yr_installed peak_demand plant_hours plnt_capability \\\n",
"475 Conventional 1980 609.0 6449.0 0.0 \n",
"476 Conventional 1980 0.0 0.0 0.0 \n",
"876 Conventional 1980 60.0 6448.0 0.0 \n",
"980 Conventional 1980 592.0 6235.0 0.0 \n",
"981 Conventional 1980 0.0 0.0 0.0 \n",
"1878 Conventional 1980 60.0 6233.0 0.0 \n",
"2017 Conventional 1980 590.0 4357.0 0.0 \n",
"2018 Conventional 1980 0.0 0.0 0.0 \n",
"2851 Conventional 1980 59.0 4362.0 0.0 \n",
"3006 Conventional 1980 595.0 6686.0 0.0 \n",
"3007 Conventional 1980 0.0 0.0 0.0 \n",
"3747 Conventional 1980 60.0 7703.0 0.0 \n",
"4011 Conventional 1980 596.0 7201.0 0.0 \n",
"4012 Conventional 1980 0.0 0.0 0.0 \n",
"4779 Conventional 1980 60.0 7209.0 0.0 \n",
"4987 Conventional 1980 599.0 5695.0 0.0 \n",
"4988 Conventional 1980 0.0 0.0 0.0 \n",
"5009 Conventional 1980 60.0 5694.0 0.0 \n",
"6277 Conventional 1980 60.0 7538.0 0.0 \n",
"6755 Conventional 1980 584.0 7538.0 0.0 \n",
"6756 Conventional 1980 0.0 0.0 0.0 \n",
"7115 Conventional 1980 60.0 6927.0 0.0 \n",
"7738 Conventional 1980 598.0 6208.0 0.0 \n",
"7739 Conventional 1980 0.0 0.0 0.0 \n",
"8060 Conventional 1980 589.0 5562.0 0.0 \n",
"8061 Conventional 1980 0.0 0.0 0.0 \n",
"8853 Conventional 1980 60.0 5561.0 0.0 \n",
"9073 Conventional 1980 578.0 7253.0 0.0 \n",
"9074 Conventional 1980 0.0 0.0 0.0 \n",
"9739 Conventional 1980 61.0 7254.0 0.0 \n",
"10249 Conventional 1980 62.0 6585.0 0.0 \n",
"10325 Conventional 1980 602.0 6586.0 0.0 \n",
"11059 Conventional 1980 599.0 4993.0 0.0 \n",
"11449 Conventional 1980 64.0 5017.0 0.0 \n",
"12011 Conventional 1980 606.0 3952.0 0.0 \n",
"12434 Conventional 1980 60.0 3952.0 0.0 \n",
"\n",
" when_not_limited when_limited avg_num_of_emp net_generation \\\n",
"475 585.0 585.0 105.0 3.540098e+09 \n",
"476 0.0 0.0 0.0 2.305031e+09 \n",
"876 0.0 0.0 0.0 3.535430e+08 \n",
"980 585.0 585.0 106.0 3.561174e+09 \n",
"981 0.0 0.0 0.0 2.309497e+09 \n",
"1878 0.0 0.0 0.0 3.571800e+08 \n",
"2017 585.0 585.0 109.0 2.414553e+09 \n",
"2018 0.0 0.0 0.0 1.564573e+09 \n",
"2851 0.0 0.0 0.0 2.415570e+08 \n",
"3006 585.0 585.0 110.0 4.354531e+09 \n",
"3007 0.0 0.0 0.0 2.827461e+09 \n",
"3747 0.0 0.0 0.0 4.366160e+08 \n",
"4011 575.0 575.0 113.0 4.015022e+09 \n",
"4012 0.0 0.0 0.0 2.610551e+09 \n",
"4779 0.0 0.0 0.0 4.026360e+08 \n",
"4987 575.0 575.0 112.0 3.159247e+09 \n",
"4988 0.0 0.0 0.0 2.046588e+09 \n",
"5009 0.0 0.0 0.0 3.174000e+08 \n",
"6277 0.0 0.0 0.0 4.168740e+08 \n",
"6755 575.0 575.0 111.0 4.087303e+09 \n",
"6756 0.0 0.0 0.0 2.651352e+09 \n",
"7115 0.0 0.0 0.0 2.877660e+08 \n",
"7738 575.0 575.0 112.0 3.305796e+09 \n",
"7739 0.0 0.0 0.0 2.191433e+09 \n",
"8060 575.0 575.0 110.0 2.603796e+09 \n",
"8061 0.0 0.0 0.0 1.708157e+09 \n",
"8853 0.0 0.0 0.0 2.301760e+08 \n",
"9073 708.0 575.0 113.0 3.733393e+09 \n",
"9074 0.0 0.0 0.0 2.454997e+09 \n",
"9739 0.0 0.0 0.0 3.280260e+08 \n",
"10249 0.0 0.0 0.0 2.693350e+08 \n",
"10325 575.0 575.0 112.0 3.156002e+09 \n",
"11059 575.0 575.0 119.0 2.350188e+09 \n",
"11449 0.0 0.0 0.0 1.829410e+08 \n",
"12011 575.0 575.0 94.0 1.732571e+09 \n",
"12434 0.0 0.0 0.0 1.342530e+08 \n",
"\n",
" cost_land cost_structure cost_equipment cost_of_plant_to \\\n",
"475 1240068.0 149500146.0 452506392.0 604085247.0 \n",
"476 798844.0 98069397.0 289787875.0 389278233.0 \n",
"876 106610.0 13575473.0 51815464.0 65497547.0 \n",
"980 1240068.0 153565948.0 466586460.0 622231117.0 \n",
"981 798844.0 102118006.0 298819315.0 402358283.0 \n",
"1878 106610.0 13616489.0 54897896.0 68620995.0 \n",
"2017 1240068.0 150839967.0 468952624.0 621871300.0 \n",
"2018 798844.0 99277301.0 301165155.0 401863417.0 \n",
"2851 106610.0 13664764.0 54705143.0 68476517.0 \n",
"3006 1240068.0 151883454.0 474946319.0 628908482.0 \n",
"3007 798844.0 99959737.0 304980403.0 406361101.0 \n",
"3747 106610.0 13754891.0 55799812.0 69661313.0 \n",
"4011 1240068.0 153089559.0 478459697.0 633627965.0 \n",
"4012 798843.0 100809820.0 307130858.0 409361638.0 \n",
"4779 106610.0 13794057.0 56385936.0 70286603.0 \n",
"4987 1240068.0 152856712.0 489558594.0 648618993.0 \n",
"4988 798843.0 100927122.0 314437075.0 420356762.0 \n",
"5009 106610.0 13781170.0 57221112.0 71108892.0 \n",
"6277 106610.0 13810712.0 57625476.0 71542798.0 \n",
"6755 1240068.0 153062273.0 494483228.0 655613764.0 \n",
"6756 798843.0 101044056.0 317788376.0 424987086.0 \n",
"7115 106610.0 13839832.0 60888268.0 74834710.0 \n",
"7738 1274078.0 153132849.0 533895764.0 722281236.0 \n",
"7739 832853.0 101073073.0 346266930.0 473362124.0 \n",
"8060 1274078.0 155985238.0 545337678.0 736575539.0 \n",
"8061 832853.0 103163607.0 356558026.0 485743754.0 \n",
"8853 106610.0 13910931.0 60588342.0 74605883.0 \n",
"9073 1274078.0 158631187.0 579275460.0 780109406.0 \n",
"9074 832853.0 104930863.0 381770601.0 519935668.0 \n",
"9739 106610.0 14291124.0 60881102.0 79354415.0 \n",
"10249 106610.0 12408084.0 63479074.0 80341990.0 \n",
"10325 939463.0 153125738.0 573361223.0 769958411.0 \n",
"11059 939463.0 153328063.0 575882623.0 782216600.0 \n",
"11449 106610.0 12492016.0 63613298.0 80643355.0 \n",
"12011 939463.0 153519689.0 576836193.0 781448382.0 \n",
"12434 106610.0 12627358.0 63694825.0 81809557.0 \n",
"\n",
" cost_per_kw expns_operations expns_fuel expns_coolants expns_steam \\\n",
"475 1005.2004 6764874.0 44256851.0 0.0 0.0 \n",
"476 996.5650 4457560.0 29909037.0 0.0 0.0 \n",
"876 1168.5557 821222.0 4409531.0 0.0 0.0 \n",
"980 1035.3952 5974221.0 47834482.0 0.0 0.0 \n",
"981 1030.0504 3818762.0 31124332.0 0.0 0.0 \n",
"1878 1224.2818 753718.0 4612849.0 0.0 0.0 \n",
"2017 968.3452 5989289.0 35492843.0 0.0 0.0 \n",
"2018 962.7085 3742813.0 22218265.0 0.0 0.0 \n",
"2851 1066.2802 864657.0 3429448.0 0.0 0.0 \n",
"3006 979.3031 6763843.0 61041164.0 0.0 0.0 \n",
"3007 973.4832 4420104.0 39933425.0 0.0 0.0 \n",
"3747 1084.7293 833210.0 6291429.0 0.0 0.0 \n",
"4011 986.6521 7757870.0 60662131.0 0.0 0.0 \n",
"4012 980.6713 5145778.0 38989787.0 0.0 0.0 \n",
"4779 1094.4659 926650.0 6023661.0 0.0 0.0 \n",
"4987 1009.9953 7567507.0 53067361.0 0.0 0.0 \n",
"4988 1007.0114 4974219.0 34702584.0 0.0 0.0 \n",
"5009 1107.6151 884620.0 5437088.0 0.0 0.0 \n",
"6277 1114.3738 1129338.0 7273624.0 0.0 0.0 \n",
"6755 1020.8872 7143046.0 70282502.0 0.0 0.0 \n",
"6756 1018.1038 4343234.0 46512845.0 0.0 0.0 \n",
"7115 1165.6497 903348.0 5683939.0 0.0 83277.0 \n",
"7738 1124.6983 5378605.0 63468760.0 0.0 2386700.0 \n",
"7739 1133.9916 2799461.0 41507187.0 0.0 2209294.0 \n",
"8060 1146.9566 3435187.0 55938280.0 0.0 3350254.0 \n",
"8061 1163.6532 2096421.0 35435628.0 0.0 2113125.0 \n",
"8853 1162.0854 590272.0 4991249.0 0.0 424389.0 \n",
"9073 1214.7453 3195671.0 71128121.0 0.0 5162929.0 \n",
"9074 1012.0205 1945523.0 47744397.0 0.0 3268230.0 \n",
"9739 1236.0501 502428.0 6433944.0 0.0 637875.0 \n",
"10249 1251.4329 537592.0 6671067.0 0.0 777278.0 \n",
"10325 1198.9387 2813003.0 80763450.0 0.0 5956318.0 \n",
"11059 1218.0265 2885072.0 62999916.0 0.0 5737718.0 \n",
"11449 1256.1270 397405.0 4737072.0 0.0 771734.0 \n",
"12011 1216.8302 2996280.0 47178273.0 0.0 5598882.0 \n",
"12434 1274.2922 446094.0 3412551.0 0.0 687008.0 \n",
"\n",
" expns_steam_othr expns_transfer expns_electric expns_misc_power \\\n",
"475 0.0 0.0 0.0 1192631.0 \n",
"476 0.0 0.0 0.0 789729.0 \n",
"876 0.0 0.0 0.0 145173.0 \n",
"980 0.0 0.0 0.0 2169872.0 \n",
"981 0.0 0.0 0.0 1432334.0 \n",
"1878 0.0 0.0 0.0 217308.0 \n",
"2017 0.0 0.0 0.0 2066716.0 \n",
"2018 0.0 0.0 0.0 1341837.0 \n",
"2851 0.0 0.0 0.0 236070.0 \n",
"3006 0.0 0.0 0.0 2169128.0 \n",
"3007 0.0 0.0 0.0 1387631.0 \n",
"3747 0.0 0.0 0.0 253061.0 \n",
"4011 0.0 0.0 0.0 2519263.0 \n",
"4012 0.0 0.0 0.0 1627230.0 \n",
"4779 0.0 0.0 0.0 272497.0 \n",
"4987 0.0 0.0 0.0 1930679.0 \n",
"4988 0.0 0.0 0.0 1276587.0 \n",
"5009 0.0 0.0 0.0 175428.0 \n",
"6277 0.0 0.0 0.0 273881.0 \n",
"6755 0.0 0.0 0.0 2489341.0 \n",
"6756 0.0 0.0 0.0 1601514.0 \n",
"7115 0.0 0.0 0.0 594345.0 \n",
"7738 0.0 0.0 0.0 7176916.0 \n",
"7739 0.0 0.0 0.0 4662468.0 \n",
"8060 0.0 0.0 0.0 4997436.0 \n",
"8061 0.0 0.0 0.0 3271731.0 \n",
"8853 0.0 0.0 0.0 473728.0 \n",
"9073 0.0 0.0 0.0 5609481.0 \n",
"9074 0.0 0.0 0.0 3637867.0 \n",
"9739 0.0 0.0 0.0 580476.0 \n",
"10249 0.0 0.0 0.0 1020470.0 \n",
"10325 0.0 0.0 0.0 10264791.0 \n",
"11059 0.0 0.0 0.0 6741084.0 \n",
"11449 0.0 0.0 0.0 393762.0 \n",
"12011 0.0 0.0 0.0 6547856.0 \n",
"12434 0.0 0.0 0.0 790829.0 \n",
"\n",
" expns_rents expns_allowances expns_engnr expns_structures \\\n",
"475 3618051.0 -7770.0 23500625.0 0.0 \n",
"476 2688319.0 0.0 15116268.0 0.0 \n",
"876 431771.0 0.0 2670682.0 0.0 \n",
"980 1138860.0 -19387.0 19085827.0 0.0 \n",
"981 640712.0 0.0 12396430.0 0.0 \n",
"1878 149158.0 0.0 1952145.0 0.0 \n",
"2017 257963.0 0.0 18694086.0 0.0 \n",
"2018 0.0 0.0 11752427.0 0.0 \n",
"2851 8426.0 0.0 2439498.0 0.0 \n",
"3006 0.0 0.0 19406261.0 0.0 \n",
"3007 0.0 0.0 12370455.0 0.0 \n",
"3747 0.0 0.0 2288516.0 0.0 \n",
"4011 0.0 0.0 21183396.0 0.0 \n",
"4012 0.0 0.0 13494993.0 0.0 \n",
"4779 0.0 0.0 2515460.0 0.0 \n",
"4987 0.0 0.0 16619501.0 0.0 \n",
"4988 0.0 0.0 10068645.0 0.0 \n",
"5009 0.0 0.0 2048845.0 0.0 \n",
"6277 0.0 0.0 2144265.0 0.0 \n",
"6755 0.0 0.0 16705721.0 0.0 \n",
"6756 0.0 0.0 10520345.0 0.0 \n",
"7115 0.0 0.0 2028723.0 43886.0 \n",
"7738 0.0 0.0 5723519.0 369601.0 \n",
"7739 0.0 0.0 279135.0 285020.0 \n",
"8060 0.0 105984.0 589130.0 3804.0 \n",
"8061 0.0 105984.0 282934.0 2628.0 \n",
"8853 0.0 0.0 197376.0 166.0 \n",
"9073 0.0 0.0 448534.0 388537.0 \n",
"9074 0.0 0.0 282052.0 249734.0 \n",
"9739 0.0 0.0 58089.0 42751.0 \n",
"10249 0.0 0.0 198355.0 65928.0 \n",
"10325 0.0 113328.0 880559.0 647531.0 \n",
"11059 0.0 0.0 748164.0 704930.0 \n",
"11449 0.0 0.0 12840.0 87640.0 \n",
"12011 0.0 0.0 490934.0 371580.0 \n",
"12434 0.0 0.0 73194.0 45008.0 \n",
"\n",
" expns_boiler expns_plants expns_misc_steam tot_prdctn_expns \\\n",
"475 0.0 0.0 194192.0 79519454.0 \n",
"476 0.0 0.0 119863.0 53080776.0 \n",
"876 0.0 0.0 26742.0 8505121.0 \n",
"980 0.0 0.0 259476.0 76443351.0 \n",
"981 0.0 0.0 89610.0 49502180.0 \n",
"1878 0.0 0.0 15071.0 7700249.0 \n",
"2017 0.0 0.0 108473.0 62609370.0 \n",
"2018 0.0 0.0 67827.0 39123169.0 \n",
"2851 0.0 0.0 14663.0 6992762.0 \n",
"3006 0.0 0.0 163697.0 89544093.0 \n",
"3007 0.0 0.0 106530.0 58218145.0 \n",
"3747 0.0 0.0 16285.0 9682501.0 \n",
"4011 0.0 0.0 125384.0 92248044.0 \n",
"4012 0.0 0.0 80608.0 59338396.0 \n",
"4779 0.0 0.0 13876.0 9752144.0 \n",
"4987 0.0 0.0 96765.0 79281813.0 \n",
"4988 0.0 0.0 64643.0 51086678.0 \n",
"5009 0.0 0.0 7273.0 8553254.0 \n",
"6277 0.0 0.0 9475.0 10830583.0 \n",
"6755 0.0 0.0 49277.0 96669887.0 \n",
"6756 0.0 0.0 25007.0 63002945.0 \n",
"7115 1064.0 235224.0 421392.0 9995198.0 \n",
"7738 7725.0 10443437.0 4573460.0 99528723.0 \n",
"7739 5773.0 10244782.0 2485078.0 64478198.0 \n",
"8060 1309374.0 17943703.0 269205.0 87942357.0 \n",
"8061 852544.0 11648733.0 168233.0 55977961.0 \n",
"8853 128927.0 1817633.0 36324.0 8660064.0 \n",
"9073 2264007.0 17221525.0 179653.0 105598458.0 \n",
"9074 1463238.0 10991172.0 118113.0 69700326.0 \n",
"9739 237986.0 2009281.0 16636.0 10519466.0 \n",
"10249 262078.0 2123156.0 24292.0 11680216.0 \n",
"10325 2531412.0 20999605.0 222308.0 125192305.0 \n",
"11059 1688797.0 16887198.0 442088.0 98834967.0 \n",
"11449 223505.0 1967645.0 46900.0 8638503.0 \n",
"12011 1714393.0 12039972.0 546793.0 77484963.0 \n",
"12434 165264.0 1373692.0 50491.0 7044131.0 \n",
"\n",
" expns_kwh asset_retire_cost \n",
"475 0.0225 838641.0 \n",
"476 0.0230 622117.0 \n",
"876 0.0241 0.0 \n",
"980 0.0215 838641.0 \n",
"981 0.0214 622118.0 \n",
"1878 0.0216 0.0 \n",
"2017 0.0259 838641.0 \n",
"2018 0.0250 622117.0 \n",
"2851 0.0289 0.0 \n",
"3006 0.0206 838641.0 \n",
"3007 0.0206 622117.0 \n",
"3747 0.0222 0.0 \n",
"4011 0.0230 838641.0 \n",
"4012 0.0227 622117.0 \n",
"4779 0.0242 0.0 \n",
"4987 0.0251 4963619.0 \n",
"4988 0.0250 4193722.0 \n",
"5009 0.0269 0.0 \n",
"6277 0.0260 0.0 \n",
"6755 0.0237 6828195.0 \n",
"6756 0.0238 5355811.0 \n",
"7115 0.0347 0.0 \n",
"7738 0.0301 33978545.0 \n",
"7739 0.0294 25189268.0 \n",
"8060 0.0338 33978545.0 \n",
"8061 0.0328 25189268.0 \n",
"8853 0.0376 0.0 \n",
"9073 0.0283 40928681.0 \n",
"9074 0.0284 32401351.0 \n",
"9739 0.0321 4075579.0 \n",
"10249 0.0434 4348222.0 \n",
"10325 0.0397 42531987.0 \n",
"11059 0.0421 52066451.0 \n",
"11449 0.0472 4431431.0 \n",
"12011 0.0447 50153037.0 \n",
"12434 0.0525 5380764.0 "
]
},
"execution_count": 19,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"ferc1_steam_new[(ferc1_steam_new.plant_name=='boardman')]"
]
},
{
"cell_type": "code",
"execution_count": 17,
"metadata": {},
"outputs": [],
"source": [
"# output plants_to_check and ferc1_steam_new into the same spreadsheet.\n",
"#writer = pd.ExcelWriter('cpi_ferc_plants/test_data.xlsx', engine='xlsxwriter')\n",
"#ferc1_steam_new.to_excel(writer, sheet_name='FERC 1 Steam Plants', index=False)\n",
"#plants_to_check.to_excel(writer, sheet_name='Candidates for Labeling', index=False)\n",
"#writer.save()"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": []
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": []
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": []
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": []
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": []
}
],
"metadata": {
"anaconda-cloud": {},
"kernelspec": {
"display_name": "Python 3",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.6.5"
}
},
"nbformat": 4,
"nbformat_minor": 1
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment