Reading Analysed Data from Google Spread Sheet's with the help of Google Sheet's API in Python

Please Follow the Video for Proper Instruction and for Code Input Check Below :



import pandas as pd
import gspread
from oauth2client.service_account import ServiceAccountCredentials

scope=['https://spreadsheets.google.com/feeds']
creds=ServiceAccountCredentials.from_json_keyfile_name('cs.json',scope)
client=gspread.authorize(creds)

sheet=client.open('BB').sheet1

Analysed=sheet.get_all_records()


Analysed=pd.DataFrame(Analysed)
print(Analysed)

--End of Code Input--

Have any Doubt Regarding this Please Feel Free to Comment and Please do Share us on Various Social Media Platform.