쿼리 결과를 DataFrame에 다운로드
컬렉션을 사용해 정리하기
내 환경설정을 기준으로 콘텐츠를 저장하고 분류하세요.
쿼리 결과를 Pandas DataFrame으로 가져옵니다.
코드 샘플
달리 명시되지 않는 한 이 페이지의 콘텐츠에는 Creative Commons Attribution 4.0 라이선스에 따라 라이선스가 부여되며, 코드 샘플에는 Apache 2.0 라이선스에 따라 라이선스가 부여됩니다. 자세한 내용은 Google Developers 사이트 정책을 참조하세요. 자바는 Oracle 및/또는 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 guide demonstrates how to retrieve query results from BigQuery and convert them into a Pandas DataFrame using the Python client library.\u003c/p\u003e\n"],["\u003cp\u003eThe sample code provided showcases a SQL query that aggregates and orders data from a public BigQuery dataset, limiting the results to the top 10 entries.\u003c/p\u003e\n"],["\u003cp\u003eAuthentication to BigQuery is achieved by setting up Application Default Credentials, as detailed in the provided authentication documentation link.\u003c/p\u003e\n"],["\u003cp\u003eUsers can explore more code samples for various Google Cloud products through the Google Cloud sample browser.\u003c/p\u003e\n"]]],[],null,["# Download query results to DataFrame\n\nGet query results as a Pandas DataFrame.\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 # from google.cloud import bigquery\n # client = bigquery.Client()\n\n sql = \"\"\"\n SELECT name, SUM(number) as count\n FROM `bigquery-public-data.usa_names.usa_1910_current`\n GROUP BY name\n ORDER BY count DESC\n LIMIT 10\n \"\"\"\n\n df = client.query_and_wait(sql).to_dataframe()\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)."]]