Adding and reading Pandas DataFRame to Google sheets

Creating Google sheets

Create one folder inside your google drive, give the name as python-test.
Give Share authorization ( Share with people and group ) to Google API service account you are using.
Google API authorization and Share at Part 1 here
Creating one new File my_sheet1 ( google sheet ) inside python-test directory.

import pygsheets
path='G:\\My drive\\testing\\google-sheet\\creds1.json'
gc=pygsheets.authorize(service_account_file=path)
sh=gc.create('my_sheet1',folder_name='python-test')

set_dataframe

set_dataframe(df, start, copy_index=False, copy_head=True, 
	extend=False, fit=False, escape_formulae=False, **kwargs)

Options	Details
df	Pandas DataFrame
start	Staring Point tuple ( row, column). It is (1,1) in below example
copy_index	Default False, Copy Index data from DataFrame
copy_head	True ( default ), column headers of Pandas DataFrame is copied.
extend	False( default) If required add columns and rows ( see example )
fit	False(default), Resize to fit all data in DataFrame if required
escape_formulae	How to handle formula ( value with = or +- sign )
nan	Replace NaN values with

Create Pandas DataFrame and then store the same inside our google sheets my_sheet1.

wk1=sh[0] # first worksheet 
import pandas as pd  # importing Pandas library
my_dict={
	'NAME':['Ravi','Raju','Alex'],
	'ID':[1,2,3],'MATH':[30,40,50],
	'ENGLISH':[20,30,40]
	}
df = pd.DataFrame(data=my_dict) # creating DataFrame
wk1.set_dataframe(df,(1,1))

All String methods tuple Python- Tutorials

Subhendu Mohapatra

Author & Instructor at plus2net

I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.

About the author Watch on YouTube

Connect:

Subscribe to our YouTube Channel here

Pandas DataFrame & Google sheets

Creating Google sheets

set_dataframe

Subhendu Mohapatra