Google sheet to dataframe
Project description
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
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
sheet_df-0.0.1rc2.tar.gz
(5.1 kB
view hashes)