data - 経済統計練習帳

import requests
 
code="1syzf1A0dGdktDS6rvTduV7fzbRK0UfwUbSUJZD2e3ZI"
 
web="https://spreadsheets.google.com/feeds/cells/"+code+"/od6/public/values"
 
r = requests.get(web)
m=r.text
 
de=m.split("</gs:cell")
 
for i in range(len(de)):
    q1=de[i].find("<gs:cell")
    de[i]=de[i][q1:]
 
y=[]
x=[]
v=[]
 
for i in range(len(de)-1):
    r1=de[i].find("row=")
    r2=de[i].find("'",r1+5)
    r=de[i][r1+5:r2]
    c1=de[i].find("col=")
    c2=de[i].find("'",c1+5)
    c=de[i][c1+5:c2]
    v1=de[i].find(">")
    vv=de[i][v1+1:]
    y.append(int(r))
    x.append(int(c))
    v.append(vv)
 
lastrow=1
for i in range(len(y)):
    if y[i] > lastrow:
       lastrow=y[i]
 
lastcol=1
for i in range(len(x)):
    if x[i] > lastcol:
       lastcol=x[i]
 
print(lastrow)
print(lastcol)
 
for u in v:
    print(u)