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
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 bigframes-2.49.0.tar.gz.
File metadata
- Download URL: bigframes-2.49.0.tar.gz
- Upload date:
- Size: 3.1 MB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via:
twine/7.0.0 CPython/3.14.3
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
b0c43bf91f22e2dfd5beaa283c59d31d2f8a9004aec410fa6658b982cc8325e7
|
|
| MD5 |
85e28cff407a6b0fc0995adb58e43497
|
|
| BLAKE2b-256 |
dc7c4760af03bc5ba86359f41408fa0306a42c2c08d1090c05be11a5fa839160
|
File details
Details for the file bigframes-2.49.0-py2.py3-none-any.whl.
File metadata
- Download URL: bigframes-2.49.0-py2.py3-none-any.whl
- Upload date:
- Size: 2.0 MB
- Tags: Python 2, Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via:
twine/7.0.0 CPython/3.14.3
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
5efda2d6574a7b9396d78e1b30ecb2c388b746badd9991da27857eea901d104a
|
|
| MD5 |
30170413a0cb173ee4e26964ee2448d2
|
|
| BLAKE2b-256 |
eaec8420ba7a5803cad89203276d30c2654eab50508b01a6ca693e1dce4743e4
|
