import Google Sheet Dataset using Pandas on your Machine Learning Project || Google Cloud Api
#jabedkhanjb
https://console.cloud.google.com/
Step by Step:
Google Cloud
[ ] create a new project
[ ] enable google drive api
[ ] enable google sheet api
[ ] credentials
[ ] create credentials
[ ] service account
[ ] service account name
[ ] copy email address below service account id
[ ] create & continue (Service Account)
[ ] select “Done”
[ ] service account details
[ ] manage service account
[ ] actions
[ ] manage keys
[ ] add key
[ ] create new key
[ ] select json
[ ] create
[ ] download json file
[ ] now share the email that we’ve copied to the google sheet as a viewer
[ ] now need some coding to import google sheet on the Jupyter Notebook
[ ] import gspread
[ ] gc = gspread.service_account(filename=“file.json")
[ ] sheet = gc.open_by_url(“sheet file url”)
[ ] ws = sheet.worksheet(“sheet name“)
[ ] df = pd.DataFrame(ws.get_all_records())
[ ] Done 💜