我能够读取文件，但无法在Google Colab上看到结果

Question

df01 = pd.read_json('/content/drive/MyDrive/project/rio_bq_2019000000000000',lines=True)

这行没有错误。但下一行有错误，我不明白这里发生了什么。我在谷歌colab上读到的

df01

我得到了如下错误：

AttributeError                            Traceback (most recent call last)
/usr/local/lib/python3.7/dist-packages/IPython/core/formatters.py in __call__(self, obj)
    336             method = get_real_method(obj, self.print_method)
    337             if method is not None:
--> 338                 return method()
    339             return None
    340         else:

1 frames
/usr/local/lib/python3.7/dist-packages/pandas/io/formats/format.py in to_html(self, buf, encoding, classes, notebook, border)
    986         notebook : {True, False}, optional, default False
    987             Whether the generated HTML is for IPython Notebook.
--> 988         border : int
    989             A ``border=border`` attribute is included in the opening
    990             ``<table>`` tag. Default ``pd.options.display.html.border``.

AttributeError: 'NotebookFormatter' object has no attribute 'get_result'
        Building    Level  ...        lng                    localtime
0           TPS1  Level 2  ... -43.249902  2019-08-01 02:52:33.289 UTC
1           TPS1  Level 2  ... -43.250474  2019-08-01 02:52:35.488 UTC
2           TPS1  Level 2  ... -43.251573  2019-08-01 02:52:36.268 UTC
3           TPS1  Level 2  ... -43.249719  2019-08-01 02:52:41.537 UTC
4           TPS1  Level 2  ... -43.249737  2019-08-01 02:52:41.538 UTC
...          ...      ...  ...        ...                          ...
3372900     TPS1  Level 2  ... -43.250513  2019-08-25 10:21:01.483 UTC
3372901     TPS1  Level 2  ... -43.250169  2019-08-25 10:21:02.024 UTC
3372902     TPS1  Level 2  ... -43.250169  2019-08-25 10:21:02.026 UTC
3372903     TPS1  Level 2  ... -43.249944  2019-08-25 10:21:02.536 UTC
3372904     TPS1  Level 2  ... -43.249944  2019-08-25 10:21:02.536 UTC

我可以看到数据导入到df01中，如错误输出底部所示。但我不能用它。为什么？我怎样才能解决这个问题

如果您需要，这是我的示例数据文件

 {"Building":"TPS2","Level":"Level 3","ClientMacAddr":"8c:8e:f2:7d:2f:de","lat":-22.813377029213196,"lng":-43.247283256092494,"localtime":"2019-11-28 17:49:00.753 UTC"}
{"Building":"TPS2","Level":"Level 3","ClientMacAddr":"8c:8e:f2:7d:2f:de","lat":-22.813377029213196,"lng":-43.247283256092494,"localtime":"2019-11-28 17:49:00.753 UTC"}
{"Building":"TPS2","Level":"Level 3","ClientMacAddr":"00:27:15:00:10:1f","lat":-22.814628521677054,"lng":-43.24741506118599,"localtime":"2019-11-28 17:49:01.58 UTC"}
{"Building":"TPS2","Level":"Level 3","ClientMacAddr":"00:27:15:00:10:1f","lat":-22.814628521677054,"lng":-43.24741506118599,"localtime":"2019-11-28 17:49:01.58 UTC"}

在这之前我只有两行

import pandas as pd
drive.mount("/content/drive")

Answer 1

我还是不知道发生了什么。但我只是想明白我自己

在这种情况下，我只能使用print进行输出

像df01一样，它在jupyter中工作得很好，但在google实验室中，我只能打印（df01）

如果你遇到这个错误

AttributeError: 'NotebookFormatter' object has no attribute 'get_result'

请在正在进行输出的每一行中添加print（）

Answer 2

如果您正在使用colab，则此问题可能是因为安装了其他软件包。在我的例子中，安装pyLDAvis包会导致此错误

Answer 3

我和科拉布也有同样的问题 我所做的只是转到运行时并单击RestartRuntime