df2gspread provides possibility to transport table-data between Google Spreadsheets and Pandas DataFrame for further management or processing.

It can be useful in all cases, when you need to handle the data located in Google Drive.

Install

pip install df2gspread

Usage

import pandas as pd

from df2gspread import df2gspread as d2g


d = [pd.Series([1., 2., 3.], index=['a', 'b', 'c']),
    pd.Series([1., 2., 3., 4.], index=['a', 'b', 'c', 'd'])]
df = pd.DataFrame(d)

# use full path to spreadsheet file
spreadsheet = '/some/folder/New Spreadsheet'
# or spreadsheet file id
# spreadsheet = '1cIOgi90...'

wks_name = 'New Sheet'

d2g.upload(df, spreadsheet, wks_name)
# if spreadsheet already exists, all data of provided worksheet 
# (or first as default)
# will be replaced with data of given DataFrame, 
# make sure that this is what you need!