Data

Tools

Indexes

Applications

Experiments

Open Source Science

https://github.com/connor-makowski/pythonbq

Python wrapper for easy use of big query

https://github.com/connor-makowski/pythonbq

Science Score: 26.0%

This score indicates how likely this project is to be science-related based on various indicators:

  • ○
    CITATION.cff file
  • ✓
    codemeta.json file
    Found codemeta.json file
  • ✓
    .zenodo.json file
    Found .zenodo.json file
  • ○
    DOI references
  • ○
    Academic publication links
  • ○
    Committers with academic emails
  • ○
    Institutional organization owner
  • ○
    JOSS paper metadata
  • ○
    Scientific vocabulary similarity
    Low similarity (8.9%) to scientific vocabulary
Last synced: 11 months ago · JSON representation

Repository

Python wrapper for easy use of big query

Basic Info
  • Host: GitHub
  • Owner: connor-makowski
  • License: mit
  • Language: Python
  • Default Branch: main
  • Size: 62.5 KB
Statistics
  • Stars: 1
  • Watchers: 1
  • Forks: 0
  • Open Issues: 0
  • Releases: 1
Created over 6 years ago · Last pushed over 1 year ago
Metadata Files
Readme License

README.md

PythonBQ

PyPI version License: MIT

Python wrapper for easy use of big query

Features

  • Easily pull big query data from python

Setup

Make sure you have Python 3.7.x (or higher) installed on your system. You can download it here.

Installation

pip install pythonbq

Example

from pythonbq import pythonbq myProject=pythonbq( bq_key_path='path/to/bq/key.json', project_id='myGoogleProjectID', legacy_sql=False ) output=myProject.query(sql='''select * from myProjectTable''')

Documentation for pythonbq Functions

https://connor-makowski.github.io/pythonbq/pythonbq.html

Output Data

  • Output from the query function is returned as a list of dictionaries
    • This can be modified by specifying the argument out_type in your .query()
    • dict: list of dictionaries
    • list: list of lists (header as the first row)
    • raw: list of lists (with no header row)
    • EG: output=myProject.query(sql='''select * from myProjectTable''', out_type='list')
  • EG: `` query = ''' SELECT name FROMbigquery-public-data.usanames.usa1910_2013` WHERE state = "TX" LIMIT 5 '''

myProject = pythonbq( keypath='./private/bqkey.json', ) output = myProject.query(sql=query) # output = [{'name': 'Mary'}, {'name': 'Roberta'}, {'name': 'Marguerite'}, {'name': 'Katie'}, {'name': 'Eunice'}] ```

Owner

  • Name: Connor Makowski
  • Login: connor-makowski
  • Kind: user
  • Location: Cambridge, MA

Cave Lab Project Manager and Digital Learning Lead at MIT

GitHub Events

Total
  • Release event: 1
  • Delete event: 3
  • Issue comment event: 1
  • Push event: 2
  • Pull request event: 3
  • Create event: 2
Last Year
  • Release event: 1
  • Delete event: 3
  • Issue comment event: 1
  • Push event: 2
  • Pull request event: 3
  • Create event: 2

Committers

Last synced: over 3 years ago

All Time
  • Total Commits: 5
  • Total Committers: 2
  • Avg Commits per committer: 2.5
  • Development Distribution Score (DDS): 0.2
Top Committers
Name Email Commits
Connor c****8@g****m 4
Connor Makowski 3****i@u****m 1

Issues and Pull Requests

Last synced: 11 months ago

All Time
  • Total issues: 0
  • Total pull requests: 15
  • Average time to close issues: N/A
  • Average time to close pull requests: 7 months
  • Total issue authors: 0
  • Total pull request authors: 2
  • Average comments per issue: 0
  • Average comments per pull request: 0.67
  • Merged pull requests: 4
  • Bot issues: 0
  • Bot pull requests: 11
Past Year
  • Issues: 0
  • Pull requests: 2
  • Average time to close issues: N/A
  • Average time to close pull requests: less than a minute
  • Issue authors: 0
  • Pull request authors: 1
  • Average comments per issue: 0
  • Average comments per pull request: 0.0
  • Merged pull requests: 2
  • Bot issues: 0
  • Bot pull requests: 0
View more stats
Top Authors
Issue Authors
Pull Request Authors
  • dependabot[bot] (11)
  • connor-makowski (2)
Top Labels
Issue Labels
Pull Request Labels
dependencies (11)

Packages

  • Total packages: 1
  • Total downloads:
    • pypi 1,153 last-month
  • Total dependent packages: 0
  • Total dependent repositories: 1
  • Total versions: 3
  • Total maintainers: 1
pypi.org: pythonbq

Python wrapper for easy use of big query

  • Versions: 3
  • Dependent Packages: 0
  • Dependent Repositories: 1
  • Downloads: 1,153 Last month
Rankings
Downloads: 4.2%
Dependent packages count: 10.1%
Average: 19.5%
Dependent repos count: 21.6%
Forks count: 29.8%
Stargazers count: 31.9%
Maintainers (1)
connor
Last synced: 11 months ago

Dependencies

requirements.txt pypi
  • cachetools ==3.0.0
  • certifi ==2018.10.15
  • chardet ==3.0.4
  • distance ==0.1.3
  • google-api-core ==1.5.2
  • google-auth ==1.6.1
  • google-auth-oauthlib ==0.2.0
  • google-cloud-bigquery ==1.7.0
  • google-cloud-core ==0.28.1
  • google-resumable-media ==0.3.1
  • googleapis-common-protos ==1.5.5
  • idna ==2.7
  • numpy ==1.15.4
  • oauthlib ==2.1.0
  • pandas ==0.23.4
  • pandas-gbq ==0.8.0
  • protobuf ==3.6.1
  • pyasn1 ==0.4.4
  • pyasn1-modules ==0.2.2
  • python-dateutil ==2.7.5
  • pytz ==2018.7
  • requests ==2.20.1
  • requests-oauthlib ==1.0.0
  • rsa ==4.0
  • six ==1.11.0
  • urllib3 ==1.24.1
setup.py pypi
  • pandas-gbq *
pyproject.toml pypi