No name 'bigquery' in module 'google.cloud'

Question

I am using Anaconda Navigator 1.9.12, Python 3.6.4, and VS Code 1.48.2.

I have written the following code:

    import pandas as pd
    from google.cloud import bigquery
    QUERY = """
        SELECT provider_city, provider_state, drg_definition, average_total_payments, 
        average_medicare_payments
        FROM 'bigquery-public-data.cms_medicare.inpatient_charges_2015'
        WHERE provider_city = "GREAT FALLS" AND provider_state = "MT"
        ORDER BY provider_city ASC
        LIMIT 1000
        """
    client = bigquery.Client.from_service_account_json('MedicareProject-xxxxxxxxxxxx.json')
    query_job = client.query(QUERY)
    df = query_job.to_dataframe()
    print ("Records Returned: ", df.shape )
    print ()
    print ("First 3 Records")
    print (df.head(3))

The following code line gives an error: from google.cloud import bigquery

The error message is:

No name 'bigquery' in module 'google.cloud'

Can anyone suggest a solution please?

Answer 1

Please install BigQuery module:

pip install google-cloud-bigquery

Document Link: https://pypi.org/project/google-cloud-bigquery/