In [1]:

    

#----------------------------------------------------------------------
# Try to slice by using != factor_level
#----------------------------------------------------------------------


    

In [2]:

    

import h2o


    

In [3]:

    

h2o.init()


    

    





H2O cluster uptime: 
4 minutes 78 milliseconds 
H2O cluster version: 
3.1.0.99999
H2O cluster name: 
ece
H2O cluster total nodes: 
1
H2O cluster total memory: 
4.44 GB
H2O cluster total cores: 
8
H2O cluster allowed cores: 
8
H2O cluster healthy: 
True
H2O Connection ip: 
127.0.0.1
H2O Connection port: 
54321

In [4]:

    

air = h2o.import_frame(path=h2o.locate("smalldata/airlines/allyears2k_headers.zip"))


    

    




Parse Progress: [##################################################] 100%
Imported  /Users/ece/0xdata/h2o-dev/smalldata/airlines/allyears2k_headers.zip . Parsed 43,978 rows and 31 cols

In [5]:

    

rows, cols = air.dim()
print [rows, cols]


    

    




[43978, 31]

In [6]:

    

#
# Select all flights not departing from SFO
#
not_sfo = air[air["Origin"] != "SFO"]
sfo = air[air["Origin"] == "SFO"]
no_rows, no_cols = not_sfo.dim()
yes_rows, yes_cols = sfo.dim()
print "no_rows: {0}".format(no_rows)
print "yes_rows: {0}".format(yes_rows)
print "no_cols: {0}".format(no_cols)
print "yes_cols: {0}".format(yes_cols)


    

    




no_rows: 42434
yes_rows: 1544
no_cols: 31
yes_cols: 31