semvec/pypi-packages huggingface dataset:
sheet-df 0.0.1
Google sheet to dataframe
License: MIT license
Requires Python: >=3.6
Keywords: sheet_df

============
sheet_df
============

Google sheet to dataframe

.. image:: https://img.shields.io/pypi/v/sheet_df?style=for-the-badge
   :target: https://pypi.org/project/sheet_df/

Overview
----------

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

Usage
-----

.. code-block:: python

   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
-----------

.. code-block:: bash

    python -m venv env

Activate venv
-------------

- unix

.. code-block:: bash

    source env/bin/activate

- windows

.. code-block:: bash

    env\Scripts\activate.bat

Install Packages
----------------

.. code-block:: bash

    pip install -r requirements.txt

Test
----

.. code-block:: bash

    make test

Format
------

.. code-block:: bash

    make format

.. code-block:: bash

    make lint

Version & Release
-----------------

.. code-block:: bash

    make bumpversion part=<major/minor/patch>

.. code-block:: bash

    make release

**note** Don't forget to `git push` with `--tags`

pre-commit
----------

Setup
-----

.. code-block:: bash

    pre-commit install

Run all
-------

.. code-block:: bash

    make pre-commit