Skip to content

Instantly share code, notes, and snippets.

@lakshay-arora

lakshay-arora/add_sheet.py

Last active Jul 28, 2020
Embed
What would you like to do?
# add a sheet with 20 rows and 2 columns
sheet.add_worksheet(rows=20,cols=2,title='runs')
# get the instance of the second sheet
sheet_runs = sheet.get_worksheet(1)
# get the total number of columns
sheet_instance.col_count
## >> 26
# get the value at the specific cell
sheet_instance.cell(col=3,row=2)
## >> <Cell R2C3 '63881'>
# get the instance of the Spreadsheet
sheet = client.open('commentary data')
# get the first sheet of the Spreadsheet
sheet_instance = sheet.get_worksheet(0)
# convert the json to dataframe
records_df = pd.DataFrame.from_dict(records_data)
# view the top records
records_df.head()
# get all the records of the data
records_data = sheet_instance.get_all_records()
# view the data
records_data
sheet_runs.insert_rows(runs.values.tolist())
sheet_instance = sheet.get_worksheet(0)
# importing the required libraries
import gspread
import pandas as pd
from oauth2client.service_account import ServiceAccountCredentials
# define the scope
scope = ['https://spreadsheets.google.com/feeds','https://www.googleapis.com/auth/drive']
# add credentials to the account
creds = ServiceAccountCredentials.from_json_keyfile_name('add_json_file_here.json', scope)
# authorize the clientsheet
client = gspread.authorize(creds)
# number of runs by each batsman
runs = records_df.groupby(['Batsman_Name'])['Runs'].count().reset_index()
runs
# define the scope
scope = ['https://spreadsheets.google.com/feeds','https://www.googleapis.com/auth/drive']
# add credentials to the account
creds = ServiceAccountCredentials.from_json_keyfile_name('My Sample Project-61da96a5184b.json', scope)
# authorize the clientsheet
client = gspread.authorize(creds)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.