sheet_df
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 envActivate venv
unix
source env/bin/activatewindows
env\Scripts\activate.batInstall Packages
pip install -r requirements.txtTest
make testFormat
make formatmake lintVersion & Release
make bumpversion part=<major/minor/patch>make releasenote Don’t forget to git push with –tags
pre-commit
Setup
pre-commit installRun all
make pre-commit1 maintainer
Metadata
1 maintainer
Release files for sheet-df 0.0.1
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| sheet_df-0.0.1.tar.gz | 5.4 kB | Details |
Release files / sheet_df-0.0.1.tar.gz
| Download URL | sheet_df-0.0.1.tar.gz |
|---|---|
| Size | 5.4 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
aa24e8de99e2b7d346383f4122f454d8c88e9a84e7eaf25813ccfff1f5e69eb9
|
|
BLAKE2b-256 checksum How to use checksums |
1779a169c0b087b2afad0d6ac3e0ffc4cdec5745b73e35c0230ee4f9c489cbec
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/1.14.0 pkginfo/1.9.6 requests/2.28.2 setuptools/58.1.0 requests-toolbelt/0.10.1 tqdm/4.65.0 CPython/3.9.16
|
