Answers for "get df from sheets"

0

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()
Posted by: Guest on November-20-2020

Python Answers by Framework

Browse Popular Code Answers by Language