read google sheet dataframe code example

Example: pandas read google sheet

from io import BytesIO
import pandas as pd
import requests
r = requests.get('https://docs.google.com/spreadsheet/ccc?key=0Ak1ecr7i0wotdGJmTURJRnZLYlV3M2daNTRubTdwTXc&output=csv')
data = r.content
df = pd.read_csv(BytesIO(data), index_col=0,parse_dates=['Quradate'])
df.head()