Append new row in google spreadsheet with existing rows using pandas

Question

I am trying to append new row in googlespreadsheet for that i have usied below script

import gspread
from oauth2client.service_account import ServiceAccountCredentials
from gspread_dataframe import get_as_dataframe, set_with_dataframe
import pandas as pd

ws = gc.open("test_submit").worksheet("Oct-2019")       

d = {'Name': ['T', 'Z'], 'ID': [3, 4]}
df = pd.DataFrame(data=d)
existing = get_as_dataframe(ws)
existing = existing.dropna(how='all')
updated = existing.append(df)
set_with_dataframe(ws, updated)

but it creates the unnecessary column in the blank column header with name unnamed0, unnamed1 ....unnamed. Moreover, it, not append row in the proper format of the existing column name. Any help is appreciated

I could know that my answer was not suitable for your question. So I have to delete my answer, because I don't want to confuse other users. I deeply apologize for my poor skill. I would like to study more. — Tanaike
– Tanaike, Commented Nov 3, 2019 at 23:03

Zaynul Abadin Tuhin · Accepted Answer · 2019-11-01 19:25:35Z

1

i have solved my problem using below script

import gspread
from oauth2client.service_account import ServiceAccountCredentials
from gspread_dataframe import get_as_dataframe, set_with_dataframe
import pandas as pd

ws = gc.open("test_submit").worksheet("Oct-2019")  

d = {'Name': ['T', 'Z'], 'ID': [3, 4]}
df = pd.DataFrame(data=d)
existing = get_as_dataframe(ws)
existing = existing.dropna(how='all')
new_df= pd.DataFrame()
new_df = new_df.append(existing)
new_df = new_df.append(df)
set_with_dataframe(ws, new_df,row=1, col=1, include_index=False, include_column_header=True,
                       resize=False, allow_formulas=True)

answered Nov 1, 2019 at 19:25

Zaynul Abadin Tuhin

32.1k6 gold badges37 silver badges66 bronze badges

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

Collectives™ on Stack Overflow

Append new row in google spreadsheet with existing rows using pandas

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