How do I prevent uploading my index to Google Sheets when uploading a pandas DataFrame using df2gspread?

Question

I'm trying to upload a DataFrame to Google Sheets using the df2gspread library. The upload is successful, however, it also uploads the index of my DataFrame. Is there anyway to not have the index of my dataframe be included in the upload?

My code:

spreadsheet_key = '1Rg1AUhwz771Rt8LYNtmdgTfeXZdYVNT5o8sW3nlkUQg'
wks_name = 'Master'
d2g.upload(df_result, spreadsheet_key, wks_name, row_names=True)

My Spreadsheet:

https://gyazo.com/492838f2c5f8d8b05df3365e5f206186

did you try row_names=False

Chris
– Chris

2020-07-03 18:14:12 +00:00
Commented Jul 3, 2020 at 18:14 — Chris
– Chris, Commented Jul 3, 2020 at 18:14

erb13020 · Accepted Answer · 2020-07-03 18:46:20Z

2

Thank you to @Chris for your comment. I needed to set row_names to False.

answered Jul 3, 2020 at 18:46

erb13020

3751 gold badge4 silver badges7 bronze badges

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

Collectives™ on Stack Overflow

How do I prevent uploading my index to Google Sheets when uploading a pandas DataFrame using df2gspread?

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