Guide de migration : pandas-gbq
Restez organisé à l'aide des collections
Enregistrez et classez les contenus selon vos préférences.
Exemples pour un guide de migration de pandas-gbq vers google-cloud-bigquery
En savoir plus
Pour obtenir une documentation détaillée incluant cet exemple de code, consultez les articles suivants :
Exemple de code
Sauf indication contraire, le contenu de cette page est régi par une licence Creative Commons Attribution 4.0, et les échantillons de code sont régis par une licence Apache 2.0. Pour en savoir plus, consultez les Règles du site Google Developers. Java est une marque déposée d'Oracle et/ou de ses sociétés affiliées.
[[["Facile à comprendre","easyToUnderstand","thumb-up"],["J'ai pu résoudre mon problème","solvedMyProblem","thumb-up"],["Autre","otherUp","thumb-up"]],[["Difficile à comprendre","hardToUnderstand","thumb-down"],["Informations ou exemple de code incorrects","incorrectInformationOrSampleCode","thumb-down"],["Il n'y a pas l'information/les exemples dont j'ai besoin","missingTheInformationSamplesINeed","thumb-down"],["Problème de traduction","translationIssue","thumb-down"],["Autre","otherDown","thumb-down"]],[],[[["\u003cp\u003eThis guide provides a code sample for interacting with BigQuery using Python.\u003c/p\u003e\n"],["\u003cp\u003eThe code sample utilizes \u003ccode\u003epandas\u003c/code\u003e to query data from a public BigQuery dataset.\u003c/p\u003e\n"],["\u003cp\u003eInstructions are provided for setting up Python and authenticating with BigQuery.\u003c/p\u003e\n"],["\u003cp\u003eThe full documentation for choosing and using Python libraries can be found at a linked resource.\u003c/p\u003e\n"],["\u003cp\u003eA link to explore other google cloud products sample is provided.\u003c/p\u003e\n"]]],[],null,["# Migration Guide: pandas-gbq\n\nSamples for a guide for migrating from pandas-gbq to google-cloud-bigquery\n\nExplore further\n---------------\n\n\nFor detailed documentation that includes this code sample, see the following:\n\n- [Choose a Python library](/bigquery/docs/python-libraries)\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\n\n sql = \"\"\"\n SELECT name\n FROM [bigquery-public-data:usa_names.usa_1910_current]\n WHERE state = 'TX'\n LIMIT 100\n \"\"\"\n\n df = pandas.read_gbq(sql, dialect=\"legacy\")\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)."]]
