Exploratory Data Analysis Using Python and BigQuery Reviews

17614 reviews

venu m. · Reviewed over 3 years ago

Rishi G. · Reviewed over 3 years ago

Akshay R. · Reviewed over 3 years ago

Milan Z. · Reviewed over 3 years ago

Lokesh J. · Reviewed over 3 years ago

Baek D. · Reviewed over 3 years ago

The background required to complete the ToDo tasks was not taught in the prep materials, and no generic examples were given that could be used to extrapolate how to complete the tasks. I had to look at the solution notebook. Also, the SQL query returns an error: _blocking_poll() got an unexpected keyword argument 'retry' which others have also reported in the discussion group starting over a week ago, but no solution has been provided.

John I. · Reviewed over 3 years ago

Anil P. · Reviewed over 3 years ago

Mira B. · Reviewed over 3 years ago

DENI S. · Reviewed over 3 years ago

kalpana c. · Reviewed over 3 years ago

Alyson A. · Reviewed over 3 years ago

Using !pip install --user google-cloud-bigquery==1.25 im getting this error: ERROR: _blocking_poll() got an unexpected keyword argument 'retry' using latest version Using !pip install --user google-cloud-bigquery==1.28 i get more info, but i cant go forward. ERROR: _blocking_poll() got an unexpected keyword argument 'retry' --------------------------------------------------------------------------- AttributeError Traceback (most recent call last) /tmp/ipykernel_28035/1341999427.py in <module> ----> 1 get_ipython().run_cell_magic('bigquery', '', '# SQL query to get a fields from dataset which prints the 10 records\nSELECT\n FORMAT_TIMESTAMP(\n "%Y-%m-%d %H:%M:%S %Z", pickup_datetime) AS pickup_datetime,\n pickup_longitude, pickup_latitude, dropoff_longitude,\n dropoff_latitude, passenger_count, trip_distance, tolls_amount, \n fare_amount, total_amount \n# TODO 3\nFROM\n `nyc-tlc.yellow.trips`\nLIMIT 10\n') /opt/conda/lib/python3.7/site-packages/IPython/core/interactiveshell.py in run_cell_magic(self, magic_name, line, cell) 2471 with self.builtin_trap: 2472 args = (magic_arg_s, cell) -> 2473 result = fn(*args, **kwargs) 2474 return result 2475 ~/.local/lib/python3.7/site-packages/google/cloud/bigquery/magics/magics.py in _cell_magic(line, query) 611 return result 612 finally: --> 613 close_transports() 614 615 ~/.local/lib/python3.7/site-packages/google/cloud/bigquery/magics/magics.py in _close_transports(client, bqstorage_client) 677 client.close() 678 if bqstorage_client is not None: --> 679 bqstorage_client.transport.channel.close() AttributeError: 'BigQueryReadGrpcTransport' object has no attribute 'channel'.

Félix G. · Reviewed over 3 years ago

Ben E. · Reviewed over 3 years ago

Franco S. · Reviewed over 3 years ago

volkan m. · Reviewed over 3 years ago

Kalyan N. · Reviewed over 3 years ago

Using !pip install --user google-cloud-bigquery==1.25 im getting this error: ERROR: _blocking_poll() got an unexpected keyword argument 'retry' using latest version Using !pip install --user google-cloud-bigquery==1.28 i get more info, but i cant go forward. ERROR: _blocking_poll() got an unexpected keyword argument 'retry' --------------------------------------------------------------------------- AttributeError Traceback (most recent call last) /tmp/ipykernel_28035/1341999427.py in <module> ----> 1 get_ipython().run_cell_magic('bigquery', '', '# SQL query to get a fields from dataset which prints the 10 records\nSELECT\n FORMAT_TIMESTAMP(\n "%Y-%m-%d %H:%M:%S %Z", pickup_datetime) AS pickup_datetime,\n pickup_longitude, pickup_latitude, dropoff_longitude,\n dropoff_latitude, passenger_count, trip_distance, tolls_amount, \n fare_amount, total_amount \n# TODO 3\nFROM\n `nyc-tlc.yellow.trips`\nLIMIT 10\n') /opt/conda/lib/python3.7/site-packages/IPython/core/interactiveshell.py in run_cell_magic(self, magic_name, line, cell) 2471 with self.builtin_trap: 2472 args = (magic_arg_s, cell) -> 2473 result = fn(*args, **kwargs) 2474 return result 2475 ~/.local/lib/python3.7/site-packages/google/cloud/bigquery/magics/magics.py in _cell_magic(line, query) 611 return result 612 finally: --> 613 close_transports() 614 615 ~/.local/lib/python3.7/site-packages/google/cloud/bigquery/magics/magics.py in _close_transports(client, bqstorage_client) 677 client.close() 678 if bqstorage_client is not None: --> 679 bqstorage_client.transport.channel.close() AttributeError: 'BigQueryReadGrpcTransport' object has no attribute 'channel'

Félix G. · Reviewed over 3 years ago

Tuany D. · Reviewed over 3 years ago

Pratik S. · Reviewed over 3 years ago

Ganesh A. · Reviewed over 3 years ago

Ganesh M. · Reviewed over 3 years ago

Olanlesi B. · Reviewed over 3 years ago

Olanlesi B. · Reviewed over 3 years ago

There were problems with google cloud components versions, because the TensorFlow Enterprice 2.6 is not the latest version I suppose, but I've managed to fix this. Some people could find it hard to do

Arsenii H. · Reviewed over 3 years ago

We do not ensure the published reviews originate from consumers who have purchased or used the products. Reviews are not verified by Google.