sheet-df 0.0.1

Google sheet to dataframe

Google sheet to dataframe

Overview

This Python program connects to the google sheets api and creates a pandas dataframe from the target sheet.

Usage

df = read_google_sheet_into_dataframe(sheet_id, range_name, credentials_path)

Config

You must have SHEET_ID` and RANGE_NAME` env vars. You will also need a credentials.json from google. The credentials_path arg defaults to “credentials.json”

DEV

Create venv

python -m venv env

Activate venv

• unix

source env/bin/activate

• windows

env\Scripts\activate.bat

Install Packages

pip install -r requirements.txt

Test

make test

Format

make format

make lint

Version & Release

make bumpversion part=<major/minor/patch>

make release

note Don’t forget to git push with –tags

pre-commit

Setup

pre-commit install

Run all

make pre-commit