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-gbqInstall latest development version
$ pip install git+https://github.com/googleapis/google-cloud-python.gitUsage
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.
4 maintainers
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file pandas_gbq-0.35.1.tar.gz.
File metadata
- Download URL: pandas_gbq-0.35.1.tar.gz
- Upload date:
- Size: 81.1 kB
- Tags: Source
- Uploaded using Trusted Publishing? Yes
- Uploaded via: twine/6.2.0 CPython/3.11.2
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
83045209ec006c1bd98f6f56e88982beddfd29bdfbf58fef1de39309bde5be99
|
|
| MD5 |
cf64ed71370720a22850b8c00c2573a6
|
|
| BLAKE2b-256 |
5b239f321a360d4814c4890a9cc711fe53b3d8a0d66e29c20bd6e4e8553ca841
|
Provenance
The following attestation bundles were made for pandas_gbq-0.35.1.tar.gz:
Publisher:
google-cloud-sdk-py@oss-exit-gate-prod.iam.gserviceaccount.com
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
pandas_gbq-0.35.1.tar.gz -
Subject digest:
83045209ec006c1bd98f6f56e88982beddfd29bdfbf58fef1de39309bde5be99 - Sigstore transparency entry: 2361769065
- Sigstore integration time:
-
Token Issuer:
https://accounts.google.com -
Service Account:
google-cloud-sdk-py@oss-exit-gate-prod.iam.gserviceaccount.com
-
Statement type:
File details
Details for the file pandas_gbq-0.35.1-py3-none-any.whl.
File metadata
- Download URL: pandas_gbq-0.35.1-py3-none-any.whl
- Upload date:
- Size: 51.7 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? Yes
- Uploaded via: twine/6.2.0 CPython/3.11.2
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
d197bf5172bc89f50bec52fa0a3e18e3c6c095f10bb5be677c1998c48b50ea4a
|
|
| MD5 |
918e6e47a066790642999f432bb3ada7
|
|
| BLAKE2b-256 |
4186802e0a4979c85d83d884eba4f77f5c2a57d9e986b56e3f7b7eba8b49fc06
|
Provenance
The following attestation bundles were made for pandas_gbq-0.35.1-py3-none-any.whl:
Publisher:
google-cloud-sdk-py@oss-exit-gate-prod.iam.gserviceaccount.com
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
pandas_gbq-0.35.1-py3-none-any.whl -
Subject digest:
d197bf5172bc89f50bec52fa0a3e18e3c6c095f10bb5be677c1998c48b50ea4a - Sigstore transparency entry: 2361769063
- Sigstore integration time:
-
Token Issuer:
https://accounts.google.com -
Service Account:
google-cloud-sdk-py@oss-exit-gate-prod.iam.gserviceaccount.com
-
Statement type:
