そうぜん - 経済統計練習帳

import requests
 
class google:
 
    def worksh(self,code,num):
 
        web="https://spreadsheets.google.com/feeds/worksheets/"+code+"/public/basic"
        r = requests.get(web)
        m=r.text
 
        xx=m.split("</entry>")
 
        str=xx[num]
 
        p1=str.index("<entry>")
        str=str[p1:]
 
        p1=str.index("<id>")
        p2=str.index("</id>")
        str=str[p1:p2]
        p1=str.index("/basic/")
        z=str[p1:]
        ws=z.replace("/basic/","")
 
        return ws
 
    def catchdata(self,code,ws):
 
        web="https://spreadsheets.google.com/feeds/cells/"+code+"/"+ws+"/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:]
 
 
        self.x=[]
        self.y=[]
        self.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:]
           self.y.append(int(r))
           self.x.append(int(c))
           self.v.append(vv)
 
        self.lastrow=1
        for i in range(len(self.y)):
            if self.y[i] > self.lastrow:
               self.lastrow=self.y[i]
 
        self.lastcol=1
        for i in range(len(self.x)):
           if self.x[i] > self.lastcol:
              self.lastcol=self.x[i]