pandas requires google-cloud-python for Google BigQuery support:

[netskink]

I used to do this in a datalab notebook

df = gbq.read_gbq('SELECT * FROM gsd_sample.blackman75', PROJECT)

Now, it says
ImportError: pandas requires google-cloud-python for Google BigQuery support: cannot import name make_exception

In the python notebook, I am doing:

import math
import shutil
import numpy as np
import pandas as pd
import tensorflow as tf
import re
import matplotlib.pyplot as plt
import IPython.display as ipd
import os
import io
import sys
import base64
import hashlib
from sklearn import preprocessing
import datetime
from pandas.io import gbq


import apache_beam as beam
print tf.__version__

And prior to that, I do this in the datalab notebook

!pip install librosa soundfile google-cloud-storage pandas-gbq google-cloud-bigquery pandas-gbq google-cloud -U

[tswast]

Duplicate of
#199

I don’t think there’s anything we can do to fix this in Datalab from this package.

[tswast]

Don’t install the plain google-cloud package. It’s deprecated.

[netskink]

Removed google-cloud from pip. Changed python interpreter from version 3 to version 2 and now it works.

[klekhraj]

Hi,
I have tried removing google-cloud from pip, still its not working.
Though it is working for python 3 but I need this in python 2.

[max-sixty]

@klekhraj what the error you're getting? What you get from pip list (or !pip list run from python)?

[klekhraj]

Hi @max-sixty,
Here is a snapshot of the error I am getting and the result I am getting from !pip list on Datalab
!pip list -> Pip list.txt

[max-sixty]

@klekhraj you're running a very old version of google-cloud-bigquery - upgrade that and it should work!

[klekhraj]

@max-sixty, I have upgraded google-cloud-bigquery, now error has been changed to ImportError: cannot import name _SCALAR_VALUE_TO_JSON_ROW

[max-sixty]

Ah: upgrade pandas_gbq

[klekhraj]

Thank you @max-sixty,
It worked after all your suggested updated.

[max-sixty]

Great!

[klekhraj]

Thanks @max-sixty,
It worked.
👍