Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR PYTHON

read google sheet from web to pandas python

import pandas as pd
sheet_url = 'https://docs.google.com/spreadsheets/d/1XqOtPkiE_Q0dfGSoyxrH730RkwrTczcRbDeJJpqRByQ/edit#gid=0'
url_1 = sheet_url.replace('/edit#gid=', '/export?format=csv&gid=')
df=pd.read_csv(url_1)
 
PREVIOUS NEXT
Tagged: #read #google #sheet #web #pandas #python
ADD COMMENT
Topic
Name
6+7 =