おおお９９９ - 経済統計練習帳

f=open("data.txt","r",encoding="utf-8")
x=[]
for line in f:
    x.append(line)
f.close()
 
univ=[]
dep=[]
point=[]
sig=[]
 
for x1 in x:
    strx=x1
    strx=strx.replace("\n","")
    p1=strx.index(",")
    p2=strx.index("[")
    p3=strx.index("]")
    u=strx[p1+1:p2]
    d=strx[p3+1:]
    sigx=strx[0:p1]
    n=len(d)
    px=d[n-2:]
    pon=0
    try:pon=int(px)
    except ValueError:pon=0
    if pon>0:d=d[0:n-2]
    point.append(pon)
    univ.append(u)
    dep.append(d)
    sig.append(sigx)
 
g=open("data2.csv","w",encoding="utf-8")
for i in range(len(univ)):
        g.write(sig[i])
        g.write(",")
        g.write(univ[i])
        g.write(",")
        g.write(dep[i])
        g.write(",")
        g.write(str(point[i]))
        g.write("\n")
g.close()