Guia de migração: pandas-gbq
Mantenha tudo organizado com as coleções
Salve e categorize o conteúdo com base nas suas preferências.
Amostras de um guia para migrar do pandas-gbq para o google-cloud-bigquery
Mais informações
Para ver a documentação detalhada que inclui este exemplo de código, consulte:
Exemplo de código
Exceto em caso de indicação contrária, o conteúdo desta página é licenciado de acordo com a Licença de atribuição 4.0 do Creative Commons, e as amostras de código são licenciadas de acordo com a Licença Apache 2.0. Para mais detalhes, consulte as políticas do site do Google Developers. Java é uma marca registrada da Oracle e/ou afiliadas.
[[["Fácil de entender","easyToUnderstand","thumb-up"],["Meu problema foi resolvido","solvedMyProblem","thumb-up"],["Outro","otherUp","thumb-up"]],[["Difícil de entender","hardToUnderstand","thumb-down"],["Informações incorretas ou exemplo de código","incorrectInformationOrSampleCode","thumb-down"],["Não contém as informações/amostras de que eu preciso","missingTheInformationSamplesINeed","thumb-down"],["Problema na tradução","translationIssue","thumb-down"],["Outro","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)."]]
