Read/write gspread worksheets using pandas DataFrames
Project description
gspread-dataframe
This package allows easy data flow between a worksheet in a Google spreadsheet and a Pandas DataFrame. Any worksheet you can obtain using the gspread package can be retrieved as a DataFrame with get_as_dataframe; DataFrame objects can be written to a worksheet using set_with_dataframe:
import pandas as pd
from gspread_dataframe import get_as_dataframe, set_with_dataframe
worksheet = some_worksheet_obtained_from_gspread_client
df = pd.DataFrame.from_records([{'a': i, 'b': i * 2} for i in range(100)])
set_with_dataframe(worksheet, df)
df2 = get_as_dataframe(worksheet)
The get_as_dataframe function supports the keyword arguments that are supported by your Pandas version’s text parsing readers, such as pandas.read_csv. Consult your Pandas documentation for a full list of options; since the 'python' engine in Pandas is used for parsing, only options supported by that engine are acceptable:
import pandas as pd
from gspread_dataframe import get_as_dataframe
worksheet = some_worksheet_obtained_from_gspread_client
df = get_as_dataframe(worksheet, parse_dates=True, usecols=[0,2], skiprows=1, header=None)
Installation
Requirements
Python 2.6+ or Python 3.2+
gspread (>=3.0.0; to use older versions of gspread, use gspread-dataframe releases of 2.1.1 or earlier)
Pandas >= 0.14.0
From PyPI
pip install gspread-dataframe
From GitHub
git clone https://github.com/robin900/gspread-dataframe.git
cd gspread-dataframe
python setup.py install
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
Built Distribution
Hashes for gspread_dataframe-3.0.5-py2.py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 813ff3c2030268507d93cea066f9c3e588468eb4ef48268c6ac44a0e4a5f0e08 |
|
MD5 | 30a400f55a868ca0eb927185d0d1baf6 |
|
BLAKE2b-256 | 43a16f94d5c4a91ecbfc90fc8a5f8029e8acd9c9174638fb2b918dd377c118d3 |