In [1]:

    

%load_ext sql


    

In [19]:

    

%sql sqlite:///tx.db


    

    
Out[19]:





u'Connected: None@tx.db'

In [20]:

    

%sql select distinct name from data limit 5


    

    




Done.






    
Out[20]:





    

        
name
    
    

        
Newman
    
    

        
Copper Station
    

In [14]:

    

%sql select * from data where state is 'TX' and county is not 'El Paso' limit 5


    

    




Done.






    
Out[14]:





    

        
state
        
name
        
orispl_code
        
unitid
        
op_date
        
op_hour
        
op_time
        
gload
        
SO2_MASS
        
NOX_MASS
        
CO2_MASS
        
heat_input
        
county
        
latitude
        
longitude
        
fuel_type
    

In [2]:

    

%sql sqlite:///smaller.db


    

    
Out[2]:





u'Connected: None@smaller.db'

In [ ]:

    

%sql delete from data where state is 'TX' and (county is not 'El Paso' or facility_name is 'Montana Power Station')
%sql vacuum


    

In [29]:

    

%sql sqlite:///smaller.db
%sql select distinct(fuel_actual), count(DISTINCT(orispl_code)) from data group by fuel_actual


    

    




Done.






    
Out[29]:





    

        
fuel_actual
        
count(DISTINCT(orispl_code))
    
    

        

        
1
    
    

        
Coal
        
41
    
    

        
Diesel Oil, Pipeline Natural Gas
        
1
    
    

        
NG
        
142
    
    

        
Other Gas
        
1
    
    

        
Residual Oil
        
1
    

In [ ]: