preview pypi versions

pandas-gbq is a package providing an interface to the Google BigQuery API from pandas.

Installation

Install latest release version via pip

$ pip install pandas-gbq

Install latest development version

$ pip install git+https://github.com/googleapis/google-cloud-python.git

Usage

Perform a query

import pandas_gbq

# If running in your local environment or Colab, use the code below and specify your GCP project ID
# result_dataframe = pandas_gbq.read_gbq("SELECT * FROM bigquery-public-data.usa_names.usa_1910_2013 LIMIT 10", project_id="your-project-id")

result_dataframe = pandas_gbq.read_gbq("SELECT column FROM dataset.table WHERE value = 'something'")

Upload a dataframe

import pandas_gbq

pandas_gbq.to_gbq(dataframe, "dataset.table")

More samples

See the pandas-gbq documentation for more details.

Project links

Key dates

PyPI data
Data sourced directly from PyPI's database.
  • Released:
Latest release

4 maintainers

PyPI data
Data sourced directly from PyPI's database.
Avatar for BigFrames from gravatar.com BigFrames Avatar for gcloudpypi from gravatar.com gcloudpypi Avatar for google_opensource from gravatar.com google_opensource
+1 more Avatar for TimSwast from gravatar.com TimSwast

Credits

Author: pandas-gbq authors

License

BSD License (BSD-3-Clause)

Requires

Python >=3.10

Provides Extra

bqstorage tqdm geopandas

Classifiers

Report project as malware

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

pandas_gbq-0.35.2.tar.gz (81.9 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

pandas_gbq-0.35.2-py3-none-any.whl (51.9 kB view details)

Uploaded Python 3

File details

Details for the file pandas_gbq-0.35.2.tar.gz.

File metadata

  • Download URL: pandas_gbq-0.35.2.tar.gz
  • Upload date:
  • Size: 81.9 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/6.2.0 CPython/3.11.2

File hashes

Hashes for pandas_gbq-0.35.2.tar.gz
Algorithm Hash digest
SHA256 3613f203e0ad9cbe38709fcb9b4c2c9af1fdb46bed333219b34a639142850806
MD5 41849377faee7c0138a6111c0074d651
BLAKE2b-256 f37b51b17494ef810bc5fb73c99b205480cb264093217bbc0f6a3fd0836e0236

See more details on using hashes here.

Provenance

The following attestation bundles were made for pandas_gbq-0.35.2.tar.gz:

Publisher: google-cloud-sdk-py@oss-exit-gate-prod.iam.gserviceaccount.com

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.
  • Statement: Publication detail:
    • Token Issuer: https://accounts.google.com
    • Service Account: google-cloud-sdk-py@oss-exit-gate-prod.iam.gserviceaccount.com

File details

Details for the file pandas_gbq-0.35.2-py3-none-any.whl.

File metadata

  • Download URL: pandas_gbq-0.35.2-py3-none-any.whl
  • Upload date:
  • Size: 51.9 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/6.2.0 CPython/3.11.2

File hashes

Hashes for pandas_gbq-0.35.2-py3-none-any.whl
Algorithm Hash digest
SHA256 b74187ec91b25ca4818b14343f7a765a7ee8f7b3ed7e8d1e428e9e8a2094b0e8
MD5 3d2fa7a6fba1ecb0f770739aa8c557d2
BLAKE2b-256 dbf38a6d47e44743053eaba0a56c17e6e7660fc913252ebf3b13fc9ea5c2a065

See more details on using hashes here.

Provenance

The following attestation bundles were made for pandas_gbq-0.35.2-py3-none-any.whl:

Publisher: google-cloud-sdk-py@oss-exit-gate-prod.iam.gserviceaccount.com

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.
  • Statement: Publication detail:
    • Token Issuer: https://accounts.google.com
    • Service Account: google-cloud-sdk-py@oss-exit-gate-prod.iam.gserviceaccount.com

Release history Release notifications | RSS feed

This release

0.35.2 This release

2 files

0.35.1

2 files

0.35.0

2 files

0.34.1

2 files

0.34.0

2 files

0.33.0

2 files

0.32.0

2 files

0.31.1

2 files

0.31.0

2 files

0.30.0

2 files

0.29.2

2 files

0.29.1

2 files

0.29.0

2 files

0.28.1

2 files

0.28.0

2 files

0.27.0

2 files

0.26.1

2 files

0.26.0

2 files

0.25.0

2 files

0.24.0

2 files

0.23.2

2 files

0.23.1

2 files

0.23.0

2 files

0.22.0

2 files

0.21.0

2 files

0.20.0

2 files

0.19.2

2 files

0.19.1

2 files

0.19.0

2 files

0.18.1

2 files

0.18.0

2 files

0.17.9

2 files

0.17.8

2 files

0.17.7

2 files

0.17.6

2 files

0.17.5

2 files

0.17.4

2 files

0.17.3

2 files

0.17.2

2 files

0.17.1

2 files

0.17.0

2 files

0.16.0

2 files

0.15.0

2 files

0.14.1

2 files

0.14.0

2 files

0.13.3

2 files

0.13.2

2 files

0.13.1

2 files

0.13.0

2 files

0.12.0

2 files

0.11.0

2 files

0.10.0

2 files

0.9.0

2 files

0.8.0

2 files

0.7.0

2 files

0.6.1

2 files

0.6.0

2 files

0.5.0

2 files

0.4.1

2 files

0.4.0

2 files

0.3.1

2 files

0.3.0

2 files

0.2.1

2 files

0.2.0

2 files

0.1.6

2 files

0.1.4

2 files

0.1.3

2 files

0.1.2

2 files

0.1.1

2 files

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page