Read/write gspread worksheets using pandas DataFrames
Project description
gspread-dataframe
If you have pandas (>= 0.14.0) installed, the gspread_dataframe module offers get_as_dataframe and set_with_dataframe functions to return a worksheet’s contents as a DataFrame object, or set a worksheet’s contents using a DataFrame.
import pandas as pd
from gspread_dataframe import get_as_dataframe, set_with_dataframe
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)
Installation
Requirements
Python 2.6+ or Python 3+
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
Close
Hashes for gspread_dataframe-1.0.0-py2.py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | f6d626bdd0c2fde30a34b745f9572117ed1fc4e2e7b3e952cc59ed7da960ad8e |
|
MD5 | acedb4ad4aac0e40c17f6241bdbede32 |
|
BLAKE2b-256 | 577e9f22a0a031e0b56360e9645af0cdc5b57c5870fc50c0c2b122f10b734df0 |