GCLOUD CONNECTORS

Python utilities to simplify connection with Google APIs

Where to get it

The source code is currently hosted on GitHub at: https://github.com/pualien/py-gcloud-connectors

Binary installers for the latest released version are available at the Python package index.

pip install gcloud-connectors

Usage

Be sure to check out the documentation.

Google Wrappers

• BigQueryConnector: read and cast pandas DataFrame from BigQuery

• GAnalyticsConnector: unsample data and return pandas DataFrame from Google Analytics

• GDriveConnector: download, upload, search and rename files from Google Drive

• GSCConnector: get data from Google Search Console

• GSheetsConnector: read and upload pandas DataFrame from / to Google Spreadsheet

• GStorageConnector: write pandas DataFrame in parquet format to Google Cloud Storage, recursive delete, copy files and folders between buckets

• GAnalytics4Connector: return pandas DataFrame from Google Analytics 4 reports

Bonus

• ForeignExchangeRatesConverter: get currency conversion rates

• LTVCalculator: compute Customer Lifetime Value

• pd_utils: derive quarter, month column from date in pandas DataFrame