In [1]:
%load_ext sql
%sql sqlite:///to_insert.db
Out[1]:
u'Connected: None@to_insert.db'
In [3]:
%sql select * from data limit 5
Done.
Out[3]:
state
facility_name
orispl_code
unitid
op_date
op_hour
op_time
gload
SO2_MASS
NOX_MASS
CO2_MASS
HEAT_INPUT
WA
Fredonia Generating Station
607
CT3
01-01-2017
0
0.0
WA
Fredonia Generating Station
607
CT3
01-01-2017
1
0.0
WA
Fredonia Generating Station
607
CT3
01-01-2017
2
0.0
WA
Fredonia Generating Station
607
CT3
01-01-2017
3
0.0
WA
Fredonia Generating Station
607
CT3
01-01-2017
4
0.0
In [ ]:
Content source: maxoboe/CEMS_Project
Similar notebooks: