Ibis BigQuery backend
Project description
This package provides a [BigQuery](https://cloud.google.com/bigquery) backend for [Ibis](https://ibis-project.org/).
Installation
Supported Python Versions
Python >= 3.7, < 3.10
Unsupported Python Versions
Python < 3.7
Install with conda:
conda install -c conda-forge ibis-bigquery
Install with pip:
pip install ibis-bigquery
Usage
Connecting to BigQuery
Recommended usage (Ibis 2.x, only [not yet released]):
import ibis
conn = ibis.bigquery.connect(
project_id=YOUR_PROJECT_ID,
dataset_id='bigquery-public-data.stackoverflow'
)
Using this library directly:
import ibis
import ibis_bigquery
conn = ibis_bigquery.connect(
project_id=YOUR_PROJECT_ID,
dataset_id='bigquery-public-data.stackoverflow'
)
Running a query
edu_table = conn.table(
'international_education',
database='bigquery-public-data.world_bank_intl_education')
edu_table = edu_table['value', 'year', 'country_code', 'indicator_code']
country_table = conn.table(
'country_code_iso',
database='bigquery-public-data.utility_us')
country_table = country_table['country_name', 'alpha_3_code']
expression = edu_table.join(
country_table,
[edu_table.country_code == country_table.alpha_3_code])
print(conn.execute(
expression[edu_table.year == 2016]
# Adult literacy rate.
[edu_table.indicator_code == 'SE.ADT.LITR.ZS']
.sort_by([ibis.desc(edu_table.value)])
.limit(20)
))
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
ibis-bigquery-0.1.1.tar.gz
(53.0 kB
view hashes)
Built Distribution
Close
Hashes for ibis_bigquery-0.1.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | e90992a1616df4524781e67b6571a00cf37cda6635df2daa353015de9de26a59 |
|
MD5 | 8bdd28b0713eb36f5b4272e644265ee9 |
|
BLAKE2b-256 | a8c56c438686e5c8fe694ffd4b34911370e6d779d775c02506e163d1ffc5e3e5 |