{"action":"created","issue":{"url":"https://api.github.com/repos/googlecolab/colabtools/issues/78","repository_url":"https://api.github.com/repos/googlecolab/colabtools","labels_url":"https://api.github.com/repos/googlecolab/colabtools/issues/78/labels{/name}","comments_url":"https://api.github.com/repos/googlecolab/colabtools/issues/78/comments","events_url":"https://api.github.com/repos/googlecolab/colabtools/issues/78/events","html_url":"https://github.com/googlecolab/colabtools/issues/78","id":302975258,"number":78,"title":"Normal tables can't be loaded.","user":{"login":"luochonghai","id":22375420,"avatar_url":"https://avatars0.githubusercontent.com/u/22375420?v=4","gravatar_id":"","url":"https://api.github.com/users/luochonghai","html_url":"https://github.com/luochonghai","followers_url":"https://api.github.com/users/luochonghai/followers","following_url":"https://api.github.com/users/luochonghai/following{/other_user}","gists_url":"https://api.github.com/users/luochonghai/gists{/gist_id}","starred_url":"https://api.github.com/users/luochonghai/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/luochonghai/subscriptions","organizations_url":"https://api.github.com/users/luochonghai/orgs","repos_url":"https://api.github.com/users/luochonghai/repos","events_url":"https://api.github.com/users/luochonghai/events{/privacy}","received_events_url":"https://api.github.com/users/luochonghai/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-03-07T06:04:46Z","updated_at":"2018-03-07T06:08:48Z","closed_at":"2018-03-07T06:08:48Z","author_association":"NONE","body":" I run the following codes:\r\n#########################\r\nimport math  \r\nimport pandas as pd\r\nimport numpy as np\r\nimport tensorflow as tf\r\n\r\nfrom IPython import display  \r\nfrom matplotlib import cm  \r\nfrom matplotlib import gridspec\r\nfrom matplotlib import pyplot as plt\r\nfrom sklearn import metrics\r\nfrom tensorflow.python.data import Dataset\r\n\r\ntf.logging.set_verbosity(tf.logging.ERROR)\r\npd.options.display.max_rows = 10\r\npd.options.display.float_format = '{:.lf}'.format\r\n\r\nchds = pd.read_csv(\"https://storage.googleapis.com/mledu-datasets/california_housing_train.csv\", sep=\",\")\r\nchds.describe()\r\n######################################\r\nand got error:\r\nValueError                                Traceback (most recent call last)\r\n/usr/local/lib/python3.6/dist-packages/IPython/core/formatters.py in __call__(self, obj)\r\n    697                 type_pprinters=self.type_printers,\r\n    698                 deferred_pprinters=self.deferred_printers)\r\n--> 699             printer.pretty(obj)\r\n    700             printer.flush()\r\n    701             return stream.getvalue()\r\n\r\n/usr/local/lib/python3.6/dist-packages/IPython/lib/pretty.py in pretty(self, obj)\r\n    396                             if callable(meth):\r\n    397                                 return meth(obj, self, cycle)\r\n--> 398             return _default_pprint(obj, self, cycle)\r\n    399         finally:\r\n    400             self.end_group()\r\n\r\n/usr/local/lib/python3.6/dist-packages/IPython/lib/pretty.py in _default_pprint(obj, p, cycle)\r\n    516     if _safe_getattr(klass, '__repr__', None) not in _baseclass_reprs:\r\n    517         # A user-provided repr. Find newlines and replace them with p.break_()\r\n--> 518         _repr_pprint(obj, p, cycle)\r\n    519         return\r\n    520     p.begin_group(1, '<')\r\n\r\n/usr/local/lib/python3.6/dist-packages/IPython/lib/pretty.py in _repr_pprint(obj, p, cycle)\r\n    707     \"\"\"A pprint that just redirects to the normal repr function.\"\"\"\r\n    708     # Find newlines and replace them with p.break_()\r\n--> 709     output = repr(obj)\r\n    710     for idx,output_line in enumerate(output.splitlines()):\r\n    711         if idx:\r\n\r\n/usr/local/lib/python3.6/dist-packages/pandas/core/base.py in __repr__(self)\r\n     78         Yields Bytestring in Py2, Unicode String in py3.\r\n     79         \"\"\"\r\n---> 80         return str(self)\r\n     81 \r\n     82 \r\n\r\n/usr/local/lib/python3.6/dist-packages/pandas/core/base.py in __str__(self)\r\n     57 \r\n     58         if compat.PY3:\r\n---> 59             return self.__unicode__()\r\n     60         return self.__bytes__()\r\n     61 \r\n\r\n/usr/local/lib/python3.6/dist-packages/pandas/core/frame.py in __unicode__(self)\r\n    634             width = None\r\n    635         self.to_string(buf=buf, max_rows=max_rows, max_cols=max_cols,\r\n--> 636                        line_width=width, show_dimensions=show_dimensions)\r\n    637 \r\n    638         return buf.getvalue()\r\n\r\n/usr/local/lib/python3.6/dist-packages/pandas/core/frame.py in to_string(self, buf, columns, col_space, header, index, na_rep, formatters, float_format, sparsify, index_names, justify, line_width, max_rows, max_cols, show_dimensions)\r\n   1673                                            max_cols=max_cols,\r\n   1674                                            show_dimensions=show_dimensions)\r\n-> 1675         formatter.to_string()\r\n   1676 \r\n   1677         if buf is None:\r\n\r\n/usr/local/lib/python3.6/dist-packages/pandas/io/formats/format.py in to_string(self)\r\n    595         else:\r\n    596 \r\n--> 597             strcols = self._to_str_columns()\r\n    598             if self.line_width is None:  # no need to wrap around just print\r\n    599                 # the whole frame\r\n\r\n/usr/local/lib/python3.6/dist-packages/pandas/io/formats/format.py in _to_str_columns(self)\r\n    530                 header_colwidth = max(self.col_space or 0,\r\n    531                                       *(self.adj.len(x) for x in cheader))\r\n--> 532                 fmt_values = self._format_col(i)\r\n    533                 fmt_values = _make_fixed_width(fmt_values, self.justify,\r\n    534                                                minimum=header_colwidth,\r\n\r\n/usr/local/lib/python3.6/dist-packages/pandas/io/formats/format.py in _format_col(self, i)\r\n    706         return format_array(values_to_format, formatter,\r\n    707                             float_format=self.float_format, na_rep=self.na_rep,\r\n--> 708                             space=self.col_space, decimal=self.decimal)\r\n    709 \r\n    710     def to_html(self, classes=None, notebook=False, border=None):\r\n\r\n/usr/local/lib/python3.6/dist-packages/pandas/io/formats/format.py in format_array(values, formatter, float_format, na_rep, digits, space, justify, decimal)\r\n   1820                         space=space, justify=justify, decimal=decimal)\r\n   1821 \r\n-> 1822     return fmt_obj.get_result()\r\n   1823 \r\n   1824 \r\n\r\n/usr/local/lib/python3.6/dist-packages/pandas/io/formats/format.py in get_result(self)\r\n   1840 \r\n   1841     def get_result(self):\r\n-> 1842         fmt_values = self._format_strings()\r\n   1843         return _make_fixed_width(fmt_values, self.justify)\r\n   1844 \r\n\r\n/usr/local/lib/python3.6/dist-packages/pandas/io/formats/format.py in _format_strings(self)\r\n   2026         # shortcut\r\n   2027         if self.formatter is not None:\r\n-> 2028             return [self.formatter(x) for x in self.values]\r\n   2029 \r\n   2030         return list(self.get_result_as_array())\r\n\r\n/usr/local/lib/python3.6/dist-packages/pandas/io/formats/format.py in <listcomp>(.0)\r\n   2026         # shortcut\r\n   2027         if self.formatter is not None:\r\n-> 2028             return [self.formatter(x) for x in self.values]\r\n   2029 \r\n   2030         return list(self.get_result_as_array())\r\n\r\nValueError: Format specifier missing precision\r\n---------------------------------------------------------------------------\r\nValueError                                Traceback (most recent call last)\r\n/usr/local/lib/python3.6/dist-packages/IPython/core/formatters.py in __call__(self, obj)\r\n    336             method = get_real_method(obj, self.print_method)\r\n    337             if method is not None:\r\n--> 338                 return method()\r\n    339             return None\r\n    340         else:\r\n\r\n/usr/local/lib/python3.6/dist-packages/pandas/core/frame.py in _repr_html_(self)\r\n    667 \r\n    668             return self.to_html(max_rows=max_rows, max_cols=max_cols,\r\n--> 669                                 show_dimensions=show_dimensions, notebook=True)\r\n    670         else:\r\n    671             return None\r\n\r\n/usr/local/lib/python3.6/dist-packages/pandas/core/frame.py in to_html(self, buf, columns, col_space, header, index, na_rep, formatters, float_format, sparsify, index_names, justify, bold_rows, classes, escape, max_rows, max_cols, show_dimensions, notebook, decimal, border)\r\n   1732                                            decimal=decimal)\r\n   1733         # TODO: a generic formatter wld b in DataFrameFormatter\r\n-> 1734         formatter.to_html(classes=classes, notebook=notebook, border=border)\r\n   1735 \r\n   1736         if buf is None:\r\n\r\n/usr/local/lib/python3.6/dist-packages/pandas/io/formats/format.py in to_html(self, classes, notebook, border)\r\n    731                                       border=border)\r\n    732         if hasattr(self.buf, 'write'):\r\n--> 733             html_renderer.write_result(self.buf)\r\n    734         elif isinstance(self.buf, compat.string_types):\r\n    735             with open(self.buf, 'w') as f:\r\n\r\n/usr/local/lib/python3.6/dist-packages/pandas/io/formats/format.py in write_result(self, buf)\r\n   1214         indent += self.indent_delta\r\n   1215         indent = self._write_header(indent)\r\n-> 1216         indent = self._write_body(indent)\r\n   1217 \r\n   1218         self.write('</table>', indent)\r\n\r\n/usr/local/lib/python3.6/dist-packages/pandas/io/formats/format.py in _write_body(self, indent)\r\n   1370         fmt_values = {}\r\n   1371         for i in range(min(len(self.columns), self.max_cols)):\r\n-> 1372             fmt_values[i] = self.fmt._format_col(i)\r\n   1373 \r\n   1374         # write values\r\n\r\n/usr/local/lib/python3.6/dist-packages/pandas/io/formats/format.py in _format_col(self, i)\r\n    706         return format_array(values_to_format, formatter,\r\n    707                             float_format=self.float_format, na_rep=self.na_rep,\r\n--> 708                             space=self.col_space, decimal=self.decimal)\r\n    709 \r\n    710     def to_html(self, classes=None, notebook=False, border=None):\r\n\r\n/usr/local/lib/python3.6/dist-packages/pandas/io/formats/format.py in format_array(values, formatter, float_format, na_rep, digits, space, justify, decimal)\r\n   1820                         space=space, justify=justify, decimal=decimal)\r\n   1821 \r\n-> 1822     return fmt_obj.get_result()\r\n   1823 \r\n   1824 \r\n\r\n/usr/local/lib/python3.6/dist-packages/pandas/io/formats/format.py in get_result(self)\r\n   1840 \r\n   1841     def get_result(self):\r\n-> 1842         fmt_values = self._format_strings()\r\n   1843         return _make_fixed_width(fmt_values, self.justify)\r\n   1844 \r\n\r\n/usr/local/lib/python3.6/dist-packages/pandas/io/formats/format.py in _format_strings(self)\r\n   2026         # shortcut\r\n   2027         if self.formatter is not None:\r\n-> 2028             return [self.formatter(x) for x in self.values]\r\n   2029 \r\n   2030         return list(self.get_result_as_array())\r\n\r\n/usr/local/lib/python3.6/dist-packages/pandas/io/formats/format.py in <listcomp>(.0)\r\n   2026         # shortcut\r\n   2027         if self.formatter is not None:\r\n-> 2028             return [self.formatter(x) for x in self.values]\r\n   2029 \r\n   2030         return list(self.get_result_as_array())\r\n\r\nValueError: Format specifier missing precision"},"comment":{"url":"https://api.github.com/repos/googlecolab/colabtools/issues/comments/371033867","html_url":"https://github.com/googlecolab/colabtools/issues/78#issuecomment-371033867","issue_url":"https://api.github.com/repos/googlecolab/colabtools/issues/78","id":371033867,"user":{"login":"craigcitro","id":468559,"avatar_url":"https://avatars3.githubusercontent.com/u/468559?v=4","gravatar_id":"","url":"https://api.github.com/users/craigcitro","html_url":"https://github.com/craigcitro","followers_url":"https://api.github.com/users/craigcitro/followers","following_url":"https://api.github.com/users/craigcitro/following{/other_user}","gists_url":"https://api.github.com/users/craigcitro/gists{/gist_id}","starred_url":"https://api.github.com/users/craigcitro/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/craigcitro/subscriptions","organizations_url":"https://api.github.com/users/craigcitro/orgs","repos_url":"https://api.github.com/users/craigcitro/repos","events_url":"https://api.github.com/users/craigcitro/events{/privacy}","received_events_url":"https://api.github.com/users/craigcitro/received_events","type":"User","site_admin":false},"created_at":"2018-03-07T06:08:48Z","updated_at":"2018-03-07T06:08:48Z","author_association":"OWNER","body":"You've got a typo in your format specifier: you should have `1` instead of `l`, so \r\n\r\n    pd.options.display.float_format = '{:.1f}'.format\r\n"}}
{"actor":{"display_login":"craigcitro"}}