{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ " # [EEP 147]: ESG Analysis" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "
TEAM | TEAM_ID | PORTFOLIO | PORTFOLIO_ID | PLANT | PLANT_ID | PERIOD | PRICE1 | PRICE2 | PRICE3 | PRICE4 | \n", "
---|---|---|---|---|---|---|---|---|---|---|
Coase | 3 | Bay_Views | 3 | MORRO_BAY_1-2 | 31 | 1 | 38.78 | 38.78 | 38.78 | 38.78 | \n", "
Coase | 3 | Bay_Views | 3 | MORRO_BAY_3-4 | 32 | 1 | 36.61 | 36.61 | 36.61 | 36.61 | \n", "
Coase | 3 | Bay_Views | 3 | MOSS_LANDING_6 | 33 | 1 | 32.56 | 32.56 | 32.56 | 32.56 | \n", "
Coase | 3 | Bay_Views | 3 | MOSS_LANDING_7 | 34 | 1 | 32.56 | 32.56 | 32.56 | 32.56 | \n", "
Coase | 3 | Bay_Views | 3 | OAKLAND | 35 | 1 | 61.17 | 61.17 | 61.17 | 61.17 | \n", "
Debreu | 4 | Beachfront | 4 | COOLWATER | 41 | 1 | 42.39 | 42.39 | 42.39 | 42.39 | \n", "
Debreu | 4 | Beachfront | 4 | ETIWANDA_1-4 | 42 | 1 | 42.67 | 42.67 | 42.67 | 42.67 | \n", "
Debreu | 4 | Beachfront | 4 | ETIWANDA_5 | 43 | 1 | 62.89 | 62.89 | 62.89 | 62.89 | \n", "
Debreu | 4 | Beachfront | 4 | ELLWOOD | 44 | 1 | 75.61 | 75.61 | 75.61 | 75.61 | \n", "
Debreu | 4 | Beachfront | 4 | MANDALAY_1-2 | 45 | 1 | 39.06 | 39.06 | 39.06 | 39.06 | \n", "
Debreu | 4 | Beachfront | 4 | MANDALAY_3 | 46 | 1 | 52.06 | 52.06 | 52.06 | 52.06 | \n", "
Debreu | 4 | Beachfront | 4 | ORMOND_BEACH_1 | 47 | 1 | 38.06 | 38.06 | 38.06 | 38.06 | \n", "
Debreu | 4 | Beachfront | 4 | ORMOND_BEACH_2 | 48 | 1 | 38.06 | 38.06 | 38.06 | 38.06 | \n", "
Arrow | 1 | Big_Coal | 1 | Four Corners | 11 | 1 | 36.5 | 36.5 | 36.5 | 36.5 | \n", "
Arrow | 1 | Big_Coal | 1 | ALAMITOS_7 | 12 | 1 | 73.72 | 73.72 | 73.72 | 73.72 | \n", "
Arrow | 1 | Big_Coal | 1 | HUNTINGTON_BEACH_1-2 | 13 | 1 | 40.5 | 40.5 | 40.5 | 40.5 | \n", "
Arrow | 1 | Big_Coal | 1 | HUNTINGTON_BEACH_5 | 14 | 1 | 66.5 | 66.5 | 66.5 | 66.5 | \n", "
Arrow | 1 | Big_Coal | 1 | REDONDO_5-6 | 15 | 1 | 41.94 | 41.94 | 41.94 | 41.94 | \n", "
Arrow | 1 | Big_Coal | 1 | REDONDO_7-8 | 16 | 1 | 41.94 | 41.94 | 41.94 | 41.94 | \n", "
Becker | 2 | Big_Gas | 2 | EL_SEGUNDO_1-2 | 21 | 1 | 44.83 | 44.83 | 44.83 | 44.83 | \n", "
Becker | 2 | Big_Gas | 2 | EL_SEGUNDO_3-4 | 22 | 1 | 41.22 | 41.22 | 41.22 | 41.22 | \n", "
Becker | 2 | Big_Gas | 2 | LONG_BEACH | 23 | 1 | 52.5 | 52.5 | 52.5 | 52.5 | \n", "
Becker | 2 | Big_Gas | 2 | NORTH_ISLAND | 24 | 1 | 65.5 | 65.5 | 65.5 | 65.5 | \n", "
Becker | 2 | Big_Gas | 2 | ENCINA | 25 | 1 | 41.67 | 41.67 | 41.67 | 41.67 | \n", "
Becker | 2 | Big_Gas | 2 | KEARNY | 26 | 1 | 90.06 | 90.06 | 90.06 | 90.06 | \n", "
Becker | 2 | Big_Gas | 2 | SOUTH_BAY | 27 | 1 | 43.83 | 43.83 | 43.83 | 43.83 | \n", "
Friedman | 5 | East_Bay | 5 | PITTSBURGH_1-4 | 51 | 1 | 40.94 | 40.94 | 40.94 | 40.94 | \n", "
Friedman | 5 | East_Bay | 5 | PITTSBURGH_5-6 | 52 | 1 | 36.61 | 36.61 | 36.61 | 36.61 | \n", "
Friedman | 5 | East_Bay | 5 | PITTSBURG_7 | 53 | 1 | 59.72 | 59.72 | 59.72 | 59.72 | \n", "
Friedman | 5 | East_Bay | 5 | CONTRA_COSTA_4-5 | 54 | 1 | 58.28 | 58.28 | 58.28 | 58.28 | \n", "
Friedman | 5 | East_Bay | 5 | CONTRA_COSTA_6-7 | 55 | 1 | 39.5 | 39.5 | 39.5 | 39.5 | \n", "
Friedman | 5 | East_Bay | 5 | POTRERO_HILL | 56 | 1 | 69.83 | 69.83 | 69.83 | 69.83 | \n", "
Krugman | 7 | Low_Fossil | 7 | HUMBOLDT | 71 | 1 | 47.44 | 47.44 | 47.44 | 47.44 | \n", "
Krugman | 7 | Low_Fossil | 7 | HELMS | 72 | 1 | 0.5 | 0.5 | 0.5 | 0.5 | \n", "
Krugman | 7 | Low_Fossil | 7 | HUNTERS_POINT_1-2 | 73 | 1 | 49.17 | 49.17 | 49.17 | 49.17 | \n", "
Krugman | 7 | Low_Fossil | 7 | HUNTERS_POINT_4 | 74 | 1 | 75.89 | 75.89 | 75.89 | 75.89 | \n", "
Krugman | 7 | Low_Fossil | 7 | DIABLO_CANYON_1 | 75 | 1 | 11.5 | 11.5 | 11.5 | 11.5 | \n", "
Heckman | 6 | Old_Timers | 6 | BIG_CREEK | 61 | 1 | 0 | 0 | 0 | 0 | \n", "
Heckman | 6 | Old_Timers | 6 | MOHAVE_1 | 62 | 1 | 34.5 | 34.5 | 34.5 | 34.5 | \n", "
Heckman | 6 | Old_Timers | 6 | MOHAVE_2 | 63 | 1 | 34.5 | 34.5 | 34.5 | 34.5 | \n", "
Heckman | 6 | Old_Timers | 6 | HIGHGROVE | 64 | 1 | 49.61 | 49.61 | 49.61 | 49.61 | \n", "
Heckman | 6 | Old_Timers | 6 | SAN_BERNARDINO | 65 | 1 | 53.94 | 53.94 | 53.94 | 53.94 | \n", "
Group | Group_num | UNIT NAME | Capacity_MW | Heat_Rate_MMBTUperMWh | Fuel_Price_USDperMMBTU | Fuel_Cost_USDperMWH | Var_OandM_USDperMWH | Total_Var_Cost_USDperMWH | Carbon_tonsperMWH | FixedCst_OandM_perDay | Plant_ID | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|
Big Coal | 1 | FOUR CORNERS | 1900 | 11.67 | 3 | 35 | 1.5 | 36.5 | 1.1 | $8,000 | 11 | \n", "
Big Coal | 1 | ALAMITOS 7 | 250 | 16.05 | 4.5 | 72.22 | 1.5 | 73.72 | 0.85 | $0 | 12 | \n", "
Big Coal | 1 | HUNTINGTON BEACH 1&2 | 300 | 8.67 | 4.5 | 39 | 1.5 | 40.5 | 0.46 | $2,000 | 13 | \n", "
Big Coal | 1 | HUNTINGTON BEACH 5 | 150 | 14.44 | 4.5 | 65 | 1.5 | 66.5 | 0.77 | $2,000 | 14 | \n", "
Big Coal | 1 | REDONDO 5&6 | 350 | 8.99 | 4.5 | 40.44 | 1.5 | 41.94 | 0.48 | $3,000 | 15 | \n", "
... (37 rows omitted)
" ], "text/plain": [ "PLANT_ID | TEAM | TEAM_ID | PORTFOLIO | PORTFOLIO_ID | PLANT | PERIOD | PRICE1 | PRICE2 | PRICE3 | PRICE4 | Group | Group_num | UNIT NAME | Capacity_MW | Heat_Rate_MMBTUperMWh | Fuel_Price_USDperMMBTU | Fuel_Cost_USDperMWH | Var_OandM_USDperMWH | Total_Var_Cost_USDperMWH | Carbon_tonsperMWH | FixedCst_OandM_perDay | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
61 | Heckman | 6 | Old_Timers | 6 | BIG_CREEK | 1 | 0 | 0 | 0 | 0 | Old Timers | 7 | BIG CREEK | 1000 | nan | 0 | 0 | 0 | 0 | 0 | $15,000 | \n", "
72 | Krugman | 7 | Low_Fossil | 7 | HELMS | 1 | 0.5 | 0.5 | 0.5 | 0.5 | Fossil Light | 8 | HELMS | 800 | nan | 0 | 0 | 0.5 | 0.5 | 0 | $15,000 | \n", "
75 | Krugman | 7 | Low_Fossil | 7 | DIABLO_CANYON_1 | 1 | 11.5 | 11.5 | 11.5 | 11.5 | Fossil Light | 8 | DIABLO CANYON 1 | 1000 | 1 | 7.5 | 7.5 | 4 | 11.5 | 0 | $20,000 | \n", "
33 | Coase | 3 | Bay_Views | 3 | MOSS_LANDING_6 | 1 | 32.56 | 32.56 | 32.56 | 32.56 | Bay Views | 4 | MOSS LANDING 6 | 750 | 6.9 | 4.5 | 31.06 | 1.5 | 32.56 | 0.37 | $8,000 | \n", "
34 | Coase | 3 | Bay_Views | 3 | MOSS_LANDING_7 | 1 | 32.56 | 32.56 | 32.56 | 32.56 | Bay Views | 4 | MOSS LANDING 7 | 750 | 6.9 | 4.5 | 31.06 | 1.5 | 32.56 | 0.37 | $8,000 | \n", "
... (37 rows omitted)
" ], "text/plain": [ "