Parse Progress: [##################################################] 100%
Uploaded py634b18a9-7e84-40ca-b265-b2fe43e064aa into cluster with 2 rows and 10 cols
Rows: 2 Cols: 16
Chunk compression summary:
| chunk_type |
chunk_name |
count |
count_percentage |
size |
size_percentage |
| C0L |
Constant Integers |
7 |
43.75 |
560 B |
43.818466 |
| C1N |
1-Byte Integers (w/o NAs) |
4 |
25.0 |
280 B |
21.909233 |
| C2 |
2-Byte Integers |
2 |
12.5 |
144 B |
11.267606 |
| C2S |
2-Byte Fractions |
1 |
6.25 |
88 B |
6.885759 |
| CStr |
String |
2 |
12.5 |
206 B |
16.118937 |
Frame distribution summary:
|
size |
number_of_rows |
number_of_chunks_per_column |
number_of_chunks |
| 172.16.2.17:54321 |
1.2 KB |
2.0 |
1.0 |
16.0 |
| mean |
1.2 KB |
2.0 |
1.0 |
16.0 |
| min |
1.2 KB |
2.0 |
1.0 |
16.0 |
| max |
1.2 KB |
2.0 |
1.0 |
16.0 |
| stddev |
0 B |
0.0 |
0.0 |
0.0 |
| total |
1.2 KB |
2.0 |
1.0 |
16.0 |
Column-by-Column Summary:
|
Location.Description |
FBI.Code |
Primary.Type |
Community.Area |
District |
Beat |
Domestic |
IUCR |
Date |
Ward |
Day |
Month |
Year |
WeekNum |
WeekDay |
HourOfDay |
| type |
string |
int |
string |
int |
int |
int |
enum |
int |
int |
int |
int |
int |
int |
int |
enum |
int |
| mins |
NaN |
11.0 |
NaN |
46.0 |
4.0 |
422.0 |
0.0 |
1150.0 |
1.423465239e+12 |
7.0 |
8.0 |
3.0 |
3915.0 |
6.0 |
6.0 |
23.0 |
| maxs |
NaN |
18.0 |
NaN |
63.0 |
9.0 |
923.0 |
0.0 |
1811.0 |
1.423467838e+12 |
14.0 |
8.0 |
3.0 |
3915.0 |
6.0 |
6.0 |
23.0 |
| sigma |
NaN |
4.94974746831 |
NaN |
12.0208152802 |
3.53553390593 |
354.260497374 |
0.0 |
467.397582364 |
1837770.5243 |
4.94974746831 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
0.0 |
| zero_count |
0 |
0 |
0 |
0 |
0 |
0 |
2 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
| missing_count |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
---------------------------------------------------------------------------
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!