関数 FT - 経済統計練習帳

import requests
 
class ft:
 
  def makedata(self,id):
 
    str1="%20"
    urlx="https://www.googleapis.com/fusiontables/v1/query?sql=SELECT"
    urlx=urlx+str1+"*"+str1+"FROM"+str1+id+str1
    urlx=urlx+"&key=AIzaSyAH0WCAXRIdHdbI-6bnMSN4kVDDZZmGyqY"
 
    r = requests.get(urlx)
    m=r.text
 
    p1=m.index("rows")
    m=m[p1:]
    m=m.replace("rows\": [","")
    m1=m.split("\n")
    m3=""
    for m2 in m1:
        m3=m3+m2
        m3=m3.replace("]}","")
 
    xx=m3.split("],")
 
    don=[]
    for x1 in xx:
        x1=x1.replace("[","")
        x1=x1.replace("]","")
        don.append(x1)
 
    self.x=[]
    self.y=[]
    self.v=[]
 
    n=0
    for d1 in don:
        dx=d1.split(",")
        n=n+1
        m=0 
        for d2 in dx:
            d2=d2.strip()
            d2=d2.replace("\"","")
            m=m+1
            self.y.append(n)
            self.x.append(m)
            self.v.append(d2)