Skip to content

Instantly share code, notes, and snippets.

@amankharwal

amankharwal/googlesheets.py Secret

Created February 2, 2021 06:54
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save amankharwal/94d88c2421db56e2628ec8e17c7c37d8 to your computer and use it in GitHub Desktop.
Save amankharwal/94d88c2421db56e2628ec8e17c7c37d8 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
googlesheets.py
import pandas as pd
sheetname="enrollment" # Enter Sheet name without using extention
sh = gc.open(sheetname)
worksheet = sh.sheet1
values_list = worksheet.get_all_values()
df = pd.DataFrame(values_list)
df.head()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment