使用 pandas-gbq 執行查詢
透過集合功能整理內容
你可以依據偏好儲存及分類內容。
使用 pandas-gbq 套件執行簡單查詢。
程式碼範例
除非另有註明,否則本頁面中的內容是採用創用 CC 姓名標示 4.0 授權,程式碼範例則為阿帕契 2.0 授權。詳情請參閱《Google Developers 網站政策》。Java 是 Oracle 和/或其關聯企業的註冊商標。
[[["容易理解","easyToUnderstand","thumb-up"],["確實解決了我的問題","solvedMyProblem","thumb-up"],["其他","otherUp","thumb-up"]],[["難以理解","hardToUnderstand","thumb-down"],["資訊或程式碼範例有誤","incorrectInformationOrSampleCode","thumb-down"],["缺少我需要的資訊/範例","missingTheInformationSamplesINeed","thumb-down"],["翻譯問題","translationIssue","thumb-down"],["其他","otherDown","thumb-down"]],[],[[["\u003cp\u003eThis page demonstrates how to use the pandas-gbq package to execute a query in BigQuery.\u003c/p\u003e\n"],["\u003cp\u003eAuthentication to BigQuery requires setting up Application Default Credentials.\u003c/p\u003e\n"],["\u003cp\u003eA code sample is provided that shows how to query country names and alpha-2 codes from a public BigQuery dataset.\u003c/p\u003e\n"],["\u003cp\u003eThe Google Cloud sample browser can be used to find code samples for other Google Cloud products.\u003c/p\u003e\n"]]],[],null,["# Run a query with pandas-gbq\n\nUse the pandas-gbq package to run a simple query.\n\nCode sample\n-----------\n\n### Python\n\n\nBefore trying this sample, follow the Python setup instructions in the\n[BigQuery quickstart using\nclient libraries](/bigquery/docs/quickstarts/quickstart-client-libraries).\n\n\nFor more information, see the\n[BigQuery Python API\nreference documentation](/python/docs/reference/bigquery/latest).\n\n\nTo authenticate to BigQuery, set up Application Default Credentials.\nFor more information, see\n\n[Set up authentication for client libraries](/bigquery/docs/authentication#client-libs).\n\n import pandas_gbq\n\n # TODO: Set project_id to your Google Cloud Platform project ID.\n # project_id = \"my-project\"\n\n sql = \"\"\"\n SELECT country_name, alpha_2_code\n FROM `bigquery-public-data.utility_us.country_code_iso`\n WHERE alpha_2_code LIKE 'A%'\n \"\"\"\n df = pandas_gbq.read_gbq(sql, project_id=project_id)\n\nWhat's next\n-----------\n\n\nTo search and filter code samples for other Google Cloud products, see the\n[Google Cloud sample browser](/docs/samples?product=bigquery)."]]