BigQuery DataFrames (also known as BigFrames) provides a Pythonic DataFrame and machine learning (ML) API powered by the BigQuery engine. It provides modules for many use cases, including:
bigframes.pandas is a pandas API for analytics. Many workloads can be migrated from pandas to bigframes by just changing a few imports.
bigframes.ml is a scikit-learn-like API for ML.
bigframes.bigquery.ai are a collection of powerful AI methods, powered by Gemini.
BigQuery DataFrames is an open-source package.
Getting started with BigQuery DataFrames
The easiest way to get started is to try the BigFrames quickstart in a notebook in BigQuery Studio.
To use BigFrames in your local development environment,
Run pip install --upgrade bigframes to install the latest version.
Setup Application default credentials for your local development environment enviroment.
Use the bigframes package to query data.
import bigframes.pandas as bpd
bpd.options.bigquery.project = your_gcp_project_id # Optional in BQ Studio.
bpd.options.bigquery.ordering_mode = "partial" # Recommended for performance.
df = bpd.read_gbq("bigquery-public-data.usa_names.usa_1910_2013")
print(
df.groupby("name")
.agg({"number": "sum"})
.sort_values("number", ascending=False)
.head(10)
.to_pandas()
)Documentation
To learn more about BigQuery DataFrames, visit these pages
License
BigQuery DataFrames is distributed with the Apache-2.0 license.
It also contains code derived from the following third-party packages:
For details, see the third_party directory.
Contact Us
For further help and provide feedback, you can email us at bigframes-feedback@google.com.
5 maintainers
Metadata
5 maintainers
Release files for bigframes 2.49.0
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| bigframes-2.49.0.tar.gz | 3.1 MB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| bigframes-2.49.0-py2.py3-none-any.whl | Python 2, Python 3 | none | any | Details |
Total release size: 5.2 MB
Release files / bigframes-2.49.0.tar.gz
| Download URL | bigframes-2.49.0.tar.gz |
|---|---|
| Size | 3.1 MB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
b0c43bf91f22e2dfd5beaa283c59d31d2f8a9004aec410fa6658b982cc8325e7
|
|
BLAKE2b-256 checksum How to use checksums |
dc7c4760af03bc5ba86359f41408fa0306a42c2c08d1090c05be11a5fa839160
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.14.3
|
Release files / bigframes-2.49.0-py2.py3-none-any.whl
| Download URL | bigframes-2.49.0-py2.py3-none-any.whl |
|---|---|
| Size | 2.0 MB |
| Tags | Python 2 Python 3 |
|
SHA-256 checksum How to use checksums |
5efda2d6574a7b9396d78e1b30ecb2c388b746badd9991da27857eea901d104a
|
|
BLAKE2b-256 checksum How to use checksums |
eaec8420ba7a5803cad89203276d30c2654eab50508b01a6ca693e1dce4743e4
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.14.3
|
