notebook.community

Edit and run



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 [ ]:

state	facility_name	orispl_code	unitid	op_date	op_hour
WA	Fredonia Generating Station	607	CT3	01-01-2017	0
WA	Fredonia Generating Station	607	CT3	01-01-2017	1
WA	Fredonia Generating Station	607	CT3	01-01-2017	2
WA	Fredonia Generating Station	607	CT3	01-01-2017	3
WA	Fredonia Generating Station	607	CT3	01-01-2017	4