Скачать или смотреть Edit and import data in Google Sheet using Python in Colab without making JSON File in Hindi

from google.colab import auth
auth.authenticate_user()

import gspread
from oauth2client.client import GoogleCredentials

gc = gspread.authorize(GoogleCredentials.get_application_default())

wb = gc.open('Marks_1') #"School Marks1" workbook is accessed here
ws=wb.worksheet('Sheet1')
worksheet=ws
rows = ws.get_all_values()
data=ws.get_all_records()
print(data)

print("")

import pandas as pd
pd.DataFrame.from_records(rows)

dfTransactions=pd.DataFrame.from_records(rows[1:],columns=rows[0])
print(dfTransactions)
cell_list = ws.range('A1:G11')
cell=ws.cell(2, 8)

i=2
while i "less than"12: #Use less than symbol here
corrected_marks = float(ws.cell(i, 4).value)+5
ws.update_cell(i, 8,corrected_marks)
i+=1


else:
ws.update_cell(1,10,'No.of Cells updated=')
ws.update_cell(1, 12, i-2)

cell_String = ws.find("BBBB") #Search Word BBBB in worksheet
print("Found your searched string at Row.No.:- %s ,Col.No.:- %s" % (cell_String.row, cell_String.col),", String=",cell_String.value)

ws.update_cell(1,13 ,'=IMPORTRANGE("https://docs.google.com/spreadsheets/...","Sheet1!A13:D25")')
#=IMPORTRANGE("URL","Sheet1!A1:B2") # URL-of file from which data is to be imported

print("No.of cells updated =",i-2)