Import data from Google Sheets into pandas df in Colab

PHOTO EMBED

Wed Jan 12 2022 18:43:04 GMT+0000 (Coordinated Universal Time)

Saved by @jmbenedetto #python

from google.colab import auth
auth.authenticate_user()

import gspread
from oauth2client.client import GoogleCredentials

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

worksheet = gc.open('My cool spreadsheet').sheet1

# get_all_values gives a list of rows.
rows = worksheet.get_all_values()
print(rows)

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

https://colab.research.google.com/notebooks/snippets/sheets.ipynb#scrollTo=6d0xJz3VzLOo