Skip to content

Instantly share code, notes, and snippets.

@amankharwal

amankharwal/googlesheets.py Secret

Created Feb 2, 2021
Embed
What would you like to do?
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