Import and Parse weather data

Parse Progress: [##################################################] 100%
Imported  /Users/anqi_fu/Documents/workspace/h2o-3/smalldata/chicago/chicagoAllWeather.csv . Parsed 5,162 rows and 7 cols
Rows: 5,162 Cols: 7

Chunk compression summary:

Frame distribution summary:

Column-by-Column Summary:

Import and Parse census data

Parse Progress: [##################################################] 100%
Imported  /Users/anqi_fu/Documents/workspace/h2o-3/smalldata/chicago/chicagoCensus.csv . Parsed 79 rows and 9 cols
Rows: 79 Cols: 9

Chunk compression summary:

Frame distribution summary:

Column-by-Column Summary:

Import and Parse crimes data

Parse Progress: [##################################################] 100%
Imported  /Users/anqi_fu/Documents/workspace/h2o-3/smalldata/chicago/chicagoCrimes10k.csv.zip . Parsed 9,999 rows and 22 cols
Rows: 9,999 Cols: 22

Chunk compression summary:

Frame distribution summary:

Column-by-Column Summary:

Rows: 9,999 Cols: 27

Chunk compression summary:

Frame distribution summary:

Column-by-Column Summary:

Rows: 9,999 Cols: 28

Chunk compression summary:

Frame distribution summary:

Column-by-Column Summary:

---------------------------------------------------------------------------
EnvironmentError                          Traceback (most recent call last)
<ipython-input-5-e946a6af6204> in <module>()
      4 weather["day"]  ._name = "Day"
      5 weather["year"] ._name = "Year"
----> 6 crimes.merge(census, allLeft=True, allRite=False)
      7 crimes.merge(weather, allLeft=True, allRite=False)

/Users/anqi_fu/Documents/workspace/h2o-3/h2o-py/h2o/frame.pyc in merge(self, other, allLeft, allRite)
   1022     expr2 = "(, "+expr+" (del %"+lkey+" #0) (del %"+rkey+" #0) )"
   1023 
-> 1024     h2o.rapids(expr2)       # merge in h2o
   1025     # Make backing H2OVecs for the remote h2o vecs
   1026     j = h2o.frame(tmp_key)  # Fetch the frame as JSON

/Users/anqi_fu/Documents/workspace/h2o-3/h2o-py/h2o/h2o.pyc in rapids(expr)
    487   :return: The JSON response of the Rapids execution
    488   """
--> 489   result = H2OConnection.post_json("Rapids", ast=urllib.quote(expr), _rest_version=99)
    490   if result['error'] is not None:
    491     raise EnvironmentError("rapids expression not evaluated: {0}".format(str(result['error'])))

/Users/anqi_fu/Documents/workspace/h2o-3/h2o-py/h2o/connection.pyc in post_json(url_suffix, file_upload_info, **kwargs)
    360     if __H2OCONN__ is None:
    361       raise ValueError("No h2o connection. Did you run `h2o.init()` ?")
--> 362     return __H2OCONN__._rest_json(url_suffix, "POST", file_upload_info, **kwargs)
    363 
    364   def _rest_json(self, url_suffix, method, file_upload_info, **kwargs):

/Users/anqi_fu/Documents/workspace/h2o-3/h2o-py/h2o/connection.pyc in _rest_json(self, url_suffix, method, file_upload_info, **kwargs)
    363 
    364   def _rest_json(self, url_suffix, method, file_upload_info, **kwargs):
--> 365     raw_txt = self._do_raw_rest(url_suffix, method, file_upload_info, **kwargs)
    366     return self._process_tables(raw_txt.json())
    367 

/Users/anqi_fu/Documents/workspace/h2o-3/h2o-py/h2o/connection.pyc in _do_raw_rest(self, url_suffix, method, file_upload_info, **kwargs)
    429       raise EnvironmentError(("h2o-py got an unexpected HTTP status code:\n {} {} (method = {}; url = {}). \n"+ \
    430                               "detailed error messages: {}")
--> 431                              .format(http_result.status_code,http_result.reason,method,url,detailed_error_msgs))
    432 
    433     # TODO: is.logging? -> write to logs

EnvironmentError: h2o-py got an unexpected HTTP status code:
 412 Precondition Failed (method = POST; url = http://localhost:54321/99/Rapids). 
detailed error messages: water.DException$DistributedException: from /172.16.2.17:54321; by class water.rapids.ASTMerge$MergeSet$MakeHash; class water.exceptions.H2OIllegalArgumentException: unimplemented

---------------------------------------------------------------------------
NameError                                 Traceback (most recent call last)
<ipython-input-12-347776b381b3> in <module>()
      1 # Create test/train split
----> 2 data_split = h2o.split_frame(data, ratios = [0.8,0.2])
      3 train = data_split[1]
      4 test  = data_split[2]
      5 

NameError: name 'data' is not defined

---------------------------------------------------------------------------
NameError                                 Traceback (most recent call last)
<ipython-input-2-f7c2ab3a3e26> in <module>()
      1 # GBM performance on train/test data
----> 2 train_auc_gbm = data_gbm.model_performance(train).auc()
      3 test_auc_gbm  = data_gbm.model_performance(test) .auc()
      4 
      5 # Deep Learning performance on train/test data

NameError: name 'data_gbm' is not defined

Parse Progress: [##################################################] 100%
Uploaded py634b18a9-7e84-40ca-b265-b2fe43e064aa into cluster with 2 rows and 10 cols
Rows: 2 Cols: 16

Chunk compression summary:

Frame distribution summary:

Column-by-Column Summary:

---------------------------------------------------------------------------
EnvironmentError                          Traceback (most recent call last)
<ipython-input-6-85bb7c75c897> in <module>()
     16 
     17 # Refine date column and merge with census data
---> 18 refine_date_col(crime_examples, "Date", "%m/%d/%Y %I:%M:%S %p")
     19 crime_examples.drop("Date")
     20 crime_examples.merge(census, allLeft=True, allRite=False)

<ipython-input-4-c2702228f9f1> in refine_date_col(data, col, pattern)
     15     # data["Weekend"] = h2o.ifelse(data["WeekDay"] in ("Sun", "Sat"), 1, 0)[0]
     16     data["Weekend"] = h2o.ifelse(data["WeekDay"] == "Sun" or data["WeekDay"] == "Sat", 1, 0)[0]
---> 17     data["Season"] = data["Month"].cut([0, 2, 5, 7, 10, 12], ["Winter", "Spring", "Summer", "Autumn", "Winter"])
     18 
     19 refine_date_col(crimes, "Date", "%m/%d/%Y %I:%M:%S %p")

/Users/anqi_fu/Documents/workspace/h2o-3/h2o-py/h2o/frame.pyc in cut(self, breaks, labels, include_lowest, right, dig_lab)
   1256 
   1257     expr = "(cut '{}' {} {} {} {} #{}".format(self.key(), breaks_list, labels_list, "%TRUE" if include_lowest else "%FALSE", "%TRUE" if right else "%FALSE", dig_lab)
-> 1258     res = h2o.rapids(expr)
   1259     return H2OVec(self._name, Expr(op=res["vec_ids"][0]["name"], length=res["num_rows"]))
   1260 

/Users/anqi_fu/Documents/workspace/h2o-3/h2o-py/h2o/h2o.pyc in rapids(expr)
    487   :return: The JSON response of the Rapids execution
    488   """
--> 489   result = H2OConnection.post_json("Rapids", ast=urllib.quote(expr), _rest_version=99)
    490   if result['error'] is not None:
    491     raise EnvironmentError("rapids expression not evaluated: {0}".format(str(result['error'])))

/Users/anqi_fu/Documents/workspace/h2o-3/h2o-py/h2o/connection.pyc in post_json(url_suffix, file_upload_info, **kwargs)
    360     if __H2OCONN__ is None:
    361       raise ValueError("No h2o connection. Did you run `h2o.init()` ?")
--> 362     return __H2OCONN__._rest_json(url_suffix, "POST", file_upload_info, **kwargs)
    363 
    364   def _rest_json(self, url_suffix, method, file_upload_info, **kwargs):

/Users/anqi_fu/Documents/workspace/h2o-3/h2o-py/h2o/connection.pyc in _rest_json(self, url_suffix, method, file_upload_info, **kwargs)
    363 
    364   def _rest_json(self, url_suffix, method, file_upload_info, **kwargs):
--> 365     raw_txt = self._do_raw_rest(url_suffix, method, file_upload_info, **kwargs)
    366     return self._process_tables(raw_txt.json())
    367 

/Users/anqi_fu/Documents/workspace/h2o-3/h2o-py/h2o/connection.pyc in _do_raw_rest(self, url_suffix, method, file_upload_info, **kwargs)
    429       raise EnvironmentError(("h2o-py got an unexpected HTTP status code:\n {} {} (method = {}; url = {}). \n"+ \
    430                               "detailed error messages: {}")
--> 431                              .format(http_result.status_code,http_result.reason,method,url,detailed_error_msgs))
    432 
    433     # TODO: is.logging? -> write to logs

EnvironmentError: h2o-py got an unexpected HTTP status code:
 412 Precondition Failed (method = POST; url = http://localhost:54321/99/Rapids). 
detailed error messages: Data vector is constant!