In [4]:
import pandas as pd
import matplotlib.pyplot as plt
In [3]:
df=pd.read_csv('generation_data.csv')
df
Out[3]:
Unnamed: 0
state
name
lat
lon
type
capacity_MW
production_GWh
0
0
AK
Agrium Kenai Nitrogen Operations
60.673200
-151.378400
Gas
21.6
0.000000
1
1
AK
Alakanuk
62.683300
-164.654400
Oil
2.6
2.244000
2
2
AK
Allison Creek Hydro
61.084444
-146.353333
Hydro
6.5
0.000000
3
3
AK
Anchorage 1
61.222100
-149.866100
Gas
121.4
33.642000
4
4
AK
Angoon
57.447778
-134.492778
Oil
1.9
1.693000
5
5
AK
Aniak
61.587500
-159.531700
Oil
2.0
2.630000
6
6
AK
Annex Creek
58.317600
-134.101000
Hydro
4.0
27.380000
7
7
AK
Auke Bay
58.387500
-134.644600
Oil
36.2
0.000000
8
8
AK
Aurora Energy LLC Chena
64.847743
-147.735063
Coal
31.3
191.062000
9
9
AK
Barrow
71.292000
-156.778600
Gas
20.3
49.637000
10
10
AK
Battery Energy Storage System
64.816700
-147.725000
Other
27.0
0.000000
11
11
AK
Beaver Falls
55.379750
-131.470269
Hydro
5.4
45.508000
12
12
AK
Beluga
61.186100
-151.035600
Gas
374.4
1216.481000
13
13
AK
Bernice Lake
60.693500
-151.387400
Gas
76.7
17.447000
14
14
AK
Bethel
60.789700
-161.787778
Oil
12.6
41.963000
15
15
AK
Black Bear Lake
55.476472
-133.147720
Hydro
4.5
21.145000
16
16
AK
Bradley Lake
59.778620
-150.940150
Hydro
126.0
432.575000
17
17
AK
Centennial
55.113900
-131.548100
Oil
3.3
-0.039000
18
18
AK
Chester Lake
55.116879
-131.545879
Hydro
1.0
5.966000
19
19
AK
Chevak
61.479444
-165.499444
Oil
1.0
0.000000
20
20
AK
Cooper Lake
60.392331
-149.665603
Hydro
19.4
32.050000
21
21
AK
Craig (AK)
55.476400
-133.148300
Oil
4.4
0.306000
22
22
AK
Delta Power
64.028056
-145.719444
Oil
23.1
-0.121000
23
23
AK
Delta Wind Farm
64.013889
-145.596667
Wind
1.9
4.500000
24
24
AK
Dillingham
59.670800
-157.890000
Oil
10.7
18.459000
25
25
AK
Dutch Harbor
53.976100
-166.536100
Oil
26.0
46.622000
26
26
AK
Eielson AFB Central Heat & Power Plant
64.671410
-147.075988
Coal
33.5
68.264000
27
27
AK
Eklutna Generation Station
61.457778
-149.351389
Gas
171.0
0.000000
28
28
AK
Eklutna Hydro Project
61.475211
-149.150090
Hydro
44.4
83.110000
29
29
AK
Elim
64.620600
-162.277200
Oil
1.6
1.198000
...
...
...
...
...
...
...
...
...
8432
8473
WY
Mountain Wind Power LLC
41.288056
-110.480741
Wind
61.0
191.636000
8433
8474
WY
Mountain Wind Power II LLC
41.263889
-110.544444
Wind
80.0
255.792000
8434
8475
WY
Naughton
41.758100
-110.598300
Coal
832.0
4958.588961
8435
8476
WY
Neil Simpson
44.287200
-105.387800
Coal
21.7
25.430000
8436
8477
WY
Neil Simpson II
44.285600
-105.383300
Coal
120.0
578.930001
8437
8478
WY
Neil Simpson II (CT2)
44.285000
-105.378600
Gas
40.0
4.478000
8438
8479
WY
Old Faithful
44.453300
-110.834700
Oil
2.0
0.124000
8439
8480
WY
Osage (WY)
43.970300
-104.410600
Coal
34.5
0.000000
8440
8481
WY
Pilot Butte
43.219017
-108.787681
Hydro
1.6
0.000000
8441
8482
WY
Rock River I LLC
41.717200
-106.107700
Wind
50.0
151.233000
8442
8483
WY
Rolling Hills
43.057200
-105.854300
Wind
103.3
271.147000
8443
8484
WY
Seminoe
42.156127
-106.908483
Hydro
51.6
119.627000
8444
8485
WY
Seven Mile Hill
41.920300
-106.375800
Wind
123.6
408.639000
8445
8486
WY
Shoshone (WY)
44.502897
-109.181228
Hydro
3.0
19.748000
8446
8487
WY
Shute Creek Facility
41.880500
-110.090400
Gas
108.0
682.326960
8447
8488
WY
Silver Sage Windpower
41.129680
-105.024000
Wind
42.0
132.239000
8448
8489
WY
Simplot Phosphates
41.541700
-109.132800
Other
11.5
78.501130
8449
8490
WY
Simpson Ridge Wind Farm LLC
41.879444
-106.369722
Wind
50.0
0.000000
8450
8491
WY
Sinclair Oil Refinery
41.779520
-107.109720
Gas
8.4
40.696750
8451
8492
WY
Spirit Mountain
44.512699
-109.129878
Hydro
4.5
16.315000
8452
8493
WY
Strawberry Creek
42.905142
-110.893422
Hydro
1.5
10.122000
8453
8494
WY
Swift Creek
42.728439
-110.916592
Hydro
2.5
7.479000
8454
8495
WY
Top of the World Windpower Project
42.925800
-105.787200
Wind
200.0
641.297000
8455
8496
WY
TransAlta Wyoming Wind
41.287400
-110.555600
Wind
144.0
402.876000
8456
8497
WY
Two Elk Generating Station
43.717500
-105.497500
Coal
320.0
0.000000
8457
8498
WY
Western Sugar Coop - Torrington
42.046900
-104.186300
Coal
2.0
5.595000
8458
8499
WY
Wygen I
44.285800
-105.383300
Coal
88.0
705.405997
8459
8500
WY
Wygen II
44.291900
-105.381100
Coal
95.0
697.290002
8460
8501
WY
Wygen III
44.291900
-105.380600
Coal
116.2
838.977000
8461
8502
WY
Wyodak
44.290128
-105.381482
Coal
402.3
2622.574952
8462 rows × 8 columns
In [7]:
plt.scatter(df['capacity_MW'],df['production_GWh'])
plt.show()
In [10]:
df1=pd.read_csv('storage_data.csv')
df1
Out[10]:
Unnamed: 0
name
lat
lon
type2
type
power_kW
duration
status
usecase
city
state
0
0
PG&E Advanced Underground Compressed Air Energ...
37.917594
-121.171039
Compressed Air Storage
Electro-mechanical
300000
10
Announced
Electric Energy Time Shift
San Joaquin County
CA
1
1
Next Gen CAES using Steel Piping - NYPA
40.728224
-73.794852
Compressed Air Storage
Electro-mechanical
9000
4.5
Announced
Black Start
Queens
NY
2
2
Lake Elsinore Advanced Pumped Storage
33.668077
-117.327262
Closed-loop Pumped Hydro Storage
Pumped Hydro Storage
500000
12
Announced
Frequency Regulation
Lake Elsinore
CA
3
3
NYSEG Seneca/Watkins Glen CAES Project
42.415934
-76.896832
Compressed Air Storage
Electro-mechanical
0
n/a
Announced
Frequency Regulation
Reading
NY
4
4
Con Edison/Eos Energy Storage Distributed Ener...
40.714353
-74.005973
Metal Air Battery
Electro-chemical
1000
6
Announced
Stationary Transmission/Distribution Upgrade D...
New York
NY
5
5
Apex Bethel Energy Center
31.835445
-95.838850
Compressed Air Storage
Electro-mechanical
317000
96
Announced
Black Start
Tennessee Colony
TX
6
6
Eldorado Pumped Storage
36.079561
-115.094045
Closed-loop Pumped Hydro Storage
Pumped Hydro Storage
1000000
10.33
Announced
Electric Supply Capacity
Clark County
NV
7
7
Prineville Pumped Storage
44.097813
-120.096365
Open-loop Pumped Hydro Storage
Pumped Hydro Storage
150000
8.2
Announced
Electric Supply Capacity
Crook County
OR
8
8
Advanced Rail Energy Storage Nevada
36.208294
-115.983915
Gravitational Storage
Electro-mechanical
50000
0.25
Announced
Electric Supply Reserve Capacity - Spinning
Pahrump
NV
9
9
SolarCity / Tesla / Princeton Power Grid Servi...
37.548270
-121.988572
Lithium-ion Battery
Electro-chemical
200
1
Announced
Electric Bill Management
Fremont
CA
10
10
SolarCity / Tesla / Princeton Power EV Chargin...
37.548270
-121.988572
Lithium-ion Battery
Electro-chemical
30
1
Announced
Electric Bill Management
Fremont
CA
11
11
Silver Creek Pumped Storage Project
40.756454
-76.128371
Closed-loop Pumped Hydro Storage
Pumped Hydro Storage
300000
8
Announced
Renewables Energy Time Shift
Blythe Township
PA
12
12
Green Charge Networks GreenStation Announced 1
36.817759
-119.808444
Lithium-ion Battery
Electro-chemical
120
1
Announced
Electric Bill Management
Fresno
CA
13
13
Green Charge Networks GreenStation Announced 2
36.721382
-119.805963
Lithium-ion Battery
Electro-chemical
60
1
Announced
Electric Bill Management
Fresno
CA
14
14
Green Charge Networks GreenStation Announced 3
36.767092
-119.804147
Lithium-ion Battery
Electro-chemical
60
1
Announced
Electric Bill Management
Fresno
CA
15
15
Green Charge Networks GreenStation Announced 4
36.817820
-119.772190
Lithium-ion Battery
Electro-chemical
60
1
Announced
Electric Bill Management
Fresno
CA
16
16
Green Charge Networks GreenStation Announced 5
36.803759
-119.862511
Lithium-ion Battery
Electro-chemical
180
1
Announced
Electric Bill Management
Fresno
CA
17
17
Green Charge Networks GreenStation Announced 6
36.854763
-119.714756
Lithium-ion Battery
Electro-chemical
200
2
Announced
Electric Bill Management
Clovis
CA
18
18
Green Charge Networks GreenStation Announced 7
36.823936
-119.697720
Lithium-ion Battery
Electro-chemical
60
1
Announced
Electric Bill Management
Clovis
CA
19
19
Green Charge Networks GreenStation Announced 8
36.799512
-119.642463
Lithium-ion Battery
Electro-chemical
60
1
Announced
Electric Bill Management
Clovis
CA
20
20
Green Charge Networks GreenStation Announced 9
36.817110
-119.681621
Lithium-ion Battery
Electro-chemical
200
2
Announced
Electric Bill Management
Clovis
CA
21
21
Green Charge Networks GreenStation Announced 10
36.890116
-119.736675
Lithium-ion Battery
Electro-chemical
200
2
Announced
Electric Bill Management
Fresno
CA
22
22
Green Charge Networks GreenStation Announced 11
36.862976
-119.765634
Lithium-ion Battery
Electro-chemical
60
1
Announced
Electric Bill Management
Fresno
CA
23
23
Green Charge Networks GreenStation Announced 13
37.724850
-122.398679
Lithium-ion Battery
Electro-chemical
1000
2
Announced
Electric Bill Management
San Francisco
CA
24
24
Green Charge Networks GreenStation Announced 14
33.975122
-118.034601
Lithium-ion Battery
Electro-chemical
60
2
Announced
Electric Bill Management
Whittier
CA
25
25
Green Charge Networks GreenStation Announced 15
34.277384
-119.230684
Lithium-ion Battery
Electro-chemical
200
2
Announced
Electric Bill Management
Ventura
CA
26
26
Green Charge Networks GreenStation Announced 16
34.163169
-119.159133
Lithium-ion Battery
Electro-chemical
200
2
Announced
Electric Bill Management
Oxnard
CA
27
27
Green Charge Networks GreenStation Announced 17
34.285558
-118.882041
Lithium-ion Battery
Electro-chemical
400
2
Announced
Electric Bill Management
Moorpark
CA
28
28
Green Charge Networks GreenStation Announced 18
32.715637
-117.169265
Lithium-ion Battery
Electro-chemical
90
2
Announced
Electric Bill Management
San Diego
CA
29
29
Green Charge Networks GreenStation Announced 19
32.753413
-117.129548
Lithium-ion Battery
Electro-chemical
60
2
Announced
Electric Bill Management
San Diego
CA
...
...
...
...
...
...
...
...
...
...
...
...
...
648
652
Con Edison Virtual Power Plant - SunPower / Su...
40.678178
-73.944158
Electro-chemical
Electro-chemical
1800
2.22
Operational
Electric Energy Time Shift
Brooklyn
NY
649
653
Franchise Services - JLM Energy
33.565121
-117.664134
Electro-chemical
Electro-chemical
60
2
Operational
Electric Bill Management
Mission Viejo
CA
650
654
NEC 4 MW / 1 MWh GSS
33.751342
-117.993992
Lithium-ion Battery
Electro-chemical
4000
0.42
Operational
Frequency Regulation
Westminster
CA
651
655
Park Place LBA Realty - Stem
33.674252
-117.844696
Electro-chemical
Electro-chemical
1300
2
Operational
Demand Response
Irvine
CA
652
656
California State University Long Beach Campus ...
33.783061
-118.114891
Electro-chemical
Electro-chemical
1000
6
Operational
Electric Bill Management
Long Beach
CA
653
657
California State University Chancellor's Offic...
33.764135
-118.201321
Electro-chemical
Electro-chemical
250
6
Operational
Electric Bill Management
Long Beach
CA
654
658
One Maritime Plaza - AMS
37.795453
-122.399213
Electro-chemical
Electro-chemical
500
2
Operational
Electric Bill Management
San Francisco
CA
655
659
Shedd Aquarium-1MW lithium-ion battery
41.867622
-87.613662
Lithium-ion Battery
Electro-chemical
1000
n/a
Operational
Electric Bill Management
Chicago
IL
656
660
Walgreens - Green Charge Network
40.965186
-73.872413
Lithium-ion Battery
Electro-chemical
27
2.37
Operational
Electric Bill Management
Yonkers
NY
657
661
Pueblo Air Cooled Run Test Facility - Calmac
38.282107
-104.517448
Ice Thermal Storage
Thermal Storage
3517
4
Operational
Electric Bill Management
Pueblo
CO
658
662
Pueblo West Factory Building - Calmac
38.282107
-104.517448
Ice Thermal Storage
Thermal Storage
3517
4
Operational
Electric Energy Time Shift
Pueblo
CO
659
663
Wawona Frozen Foods
36.843833
-119.713350
Electro-chemical
Electro-chemical
250
2
Operational
Electric Bill Management
Clovis
CA
660
664
Rocky Mountain Institute Innovation Center
39.368517
-107.038524
Electro-chemical
Electro-chemical
30
1.5
Operational
Electric Bill Management
Basalt
CO
661
665
AEP Gahanna NaS Battery Energy Storage System
40.019231
-82.879345
Sodium-sulfur Battery
Electro-chemical
2000
n/a
Operational
Electric Energy Time Shift
Gahanna
OH
662
666
Hartley Nature Center
46.838557
-92.082973
Electro-chemical
Electro-chemical
6
2.37
Operational
Microgrid Capability
Duluth
MN
663
667
Moakley Courthouse - Calmac
42.354174
-71.047162
Ice Thermal Storage
Thermal Storage
0
n/a
Operational
Electric Bill Management
Boston
MA
664
668
AltaGas Pomona Energy - SCE / Greensmith Energy
34.058936
-117.775403
Electro-chemical
Electro-chemical
20000
4
Operational
Electric Supply Capacity
Pomona
CA
665
669
Western Grid Development - SCE
34.356780
-119.055045
Electro-chemical
Electro-chemical
5000
4
Operational
Electric Supply Capacity
Santa Paula
CA
666
670
San Diego Repertory - Stem
32.714535
-117.161891
Electro-chemical
Electro-chemical
36
4
Operational
Demand Response
San Diego
CA
667
671
Entergy 500 kW
30.073372
-89.862862
Electro-chemical
Electro-chemical
500
1
Operational
Onsite Renewable Generation Shifting
New Orleans
LA
668
672
OATI South Campus Microgrid
44.840798
-93.298280
Electro-chemical
Electro-chemical
0
n/a
Operational
Demand Response
Bloomington
MN
669
673
NRECA/CRN - Distributed Energy Storage Researc...
45.095479
-93.437367
Heat Thermal Storage
Thermal Storage
15
8
Operational
Frequency Regulation
Maple Grove
MN
670
674
Wholefood Signage System
38.647953
-121.120770
Lithium-ion Battery
Electro-chemical
1
25
Operational
Microgrid Capability
Folsom
CA
671
675
Airbnb and kitHAUS Microgrid Pop Up House
34.248377
-118.386017
Lithium-ion Battery
Electro-chemical
5
1
Operational
Microgrid Capability
Sun Valley
CA
672
676
Net Zero Plus Electric Training Institute (NZP...
34.000569
-118.159793
Lithium-ion Battery
Electro-chemical
500
0.5
Operational
Black Start
City of Commerce
CA
673
677
Redding Electric Utilities (Phase 2) - Ice Ene...
40.586540
-122.391675
Ice Thermal Storage
Thermal Storage
6000
2
Under Construction
Electric Energy Time Shift
Redding
CA
674
678
University of St Thomas Renewable Energy Facility
44.944122
-93.189714
Lithium-ion Battery
Electro-chemical
250
8
Under Construction
Grid-Connected Commercial (Reliability & Quali...
St. Paul
MN
675
679
Green Omni Terminal Demonstration Project
33.738009
-118.260246
Electro-chemical
Electro-chemical
2600
1
Under Construction
Electric Bill Management
Los Angeles
CA
676
680
Whole Foods Kailua- Hawaii
21.402222
-157.739444
Electro-chemical
Electro-chemical
0
n/a
Under Construction
Electric Bill Management
Kailua
HI
677
681
Marengo Project
42.248633
-88.608427
Lithium-ion Battery
Electro-chemical
20000
0.25
Under Construction
Frequency Regulation
Marengo
IL
678 rows × 12 columns
In [ ]:
_
Content source: DIRECT-Energy-Storage/Final-Project
Similar notebooks: