pygsheets set_dataframe not being recognized

Question

I am trying to write a pandas data frame to a google sheet

# open google sheet where 'test' is the name of the project
sh = gc.open_all('test')

# update the first sheet with df, starting at cell B2 and second sheet with ds
wks = sh[:-1]
wks.set_dataframe(df, (1, 1))

every time I run this app I get this error:

wks.set_dataframe(df, (1, 1))
AttributeError: 'list' object has no attribute 'set_dataframe'

It seems as if set_dataframe is not being recognized within pygsheets

Has anyone encountered this error or know what is the problem?

You have a simple typo: instead of accessing an index, you perform a list copy using slice notation: compare `somelist[1]`, `somelist[:1]`, and `somelist[1:]` — tehhowch, Dec 02 '18 at 15:31

score 1 · Answer 1 · answered Nov 02 '18 at 05:54

1

use gspread_dataframe

you can check it out from here gspread-dataframe

answered Nov 02 '18 at 05:54

Yash Shah

125
13

pygsheets set_dataframe not being recognized

1 Answers1