df2gspread Type Error when uploading DF to Google sheets

Question

I'm getting the following error when trying to use d2g.upload() to save a DF back to a Google sheet:

TypeError: '<' not supported between instances of 'str' and 'int'

It is saving the index and the DF column names to the Google sheet, but not actually populating the data into the sheet.

No idea what's causing it, has anyone else encountered this same problem? Below is the code I'm using to save the DF back to Google sheets. I've used the same code for several other DF's and it works, I just don't know what's unique and this specific DF that's causing the issue. The Dtypes are all object / float. Any help would be greatly apprecaited!

from df2gspread import df2gspread as d2g 
wks_name = 'Linkedin_Campaign_Ad_Daily_Clean'

d2g.upload(li_ad_link_clicks, spreadsheet_key, wks_name, credentials=credentials, row_names=True)

Nicholas Jernigan · Accepted Answer · 2021-03-11 23:34:52Z

2

I fixed this by deleting duplicate columns in my dataframe:

df = df.loc[:,~df.columns.duplicated()]

answered Mar 11, 2021 at 23:34

Nicholas Jernigan

212 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

df2gspread Type Error when uploading DF to Google sheets

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related