pppp - 経済統計練習帳

import os
import shutil
import requests
 
str1="%20"
id="1l8Jo-zLPNTdefqhhVcD3c_I2ypzVeDvur7974Xq0"
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("]}","")
 
x=m3.split("],")
 
don=[]
for x1 in x:
    x1=x1.replace("[","")
    x1=x1.replace("]","")
    don.append(x1)
 
for d1 in don:
    dx=d1.split(",")
    for d2 in dx:
        d2=d2.strip()
        d2=d2.replace("\"","")
        print(d2)