CODEWITHSUNDEEP
pythonjupyter-notebookgoogle-colaboratory
AlexWithYou
AlexWithYou

Reputation: 429

I am able to read a file, but not able to see the result on Google Colab

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

No error for this line. But it has error on next line, I don't understand what happens here. I read it on google colab

df01

I got an error as following:

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

I can see the data is imported in df01 as shown in the bottom of error output. But I can't use it. Why? how can I fix this?

In case you need, this is my sample data file

 {"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"}

I only have two lines before this

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

Upvotes: 8

Views: 10898

Answers (6)

Vikas Kumar
Vikas Kumar

Reputation: 71

I had the same problem with colab what I did was simply go to the Runtime and click on Restart Runtime

Upvotes: 7

Fares Sayah
Fares Sayah

Reputation: 131

If you are working on colab, this problem may be because of installing other packages. In my case, installing pyLDAvis package cause this error.

Upvotes: 2

Ibrahim kassoum Habibou
Ibrahim kassoum Habibou

Reputation: 41

I got the same issue with one of my project. You simply have to restart your session.

Upvotes: 4

faraday
faraday

Reputation: 53

I had the same problem with colab, this fixed:

!pip install -U pandas-profiling

Upvotes: -1

Jacques75
Jacques75

Reputation: 81

When you have this type of error it's highly probable that the json file has format typo. Try to copy past your json file on a Online JSON parser (s.t. : http://json.parser.online.fr/) and see if there is a typo error.

Upvotes: 0

AlexWithYou
AlexWithYou

Reputation: 429

I still don't know what happened. But I just figure out myself

I can only make output in this case with print

Like df01 works well in jupyter, but in google lab I can only write in print(df01)

If you meet with this error

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

Please add print() in each line you are making an output

Upvotes: 7

Related Questions