いちｒｔｔｔ - 経済統計練習帳

delta=[]
 
dic=[]
codex=[]
 
f1=open("t.csv","r",encoding='utf-8')
for line in f1:
    x3=line.split(",")
    dic.append(x3[0])
    codex.append(x3[1])
f1.close()
 
f=open("tv.csv","r",encoding='utf-8')
x=[]
for line in f:
    x.append(line)
f.close()
 
y1=[]
m1=[]
y2=[]
m2=[]
code=[]
t=[]
 
for i in range(len(x)-1):
    x2=x[i+1].split(",")
    y1.append(int(x2[1]))
    m1.append(int(x2[2]))
    y2.append(int(x2[3]))
    m2.append(int(x2[4]))
    t.append(x2[7])
    code.append(x2[9])
 
 
g=open("ar.csv","r",encoding='utf-8')
q=[]
for line in g:
    q.append(line)
g.close()
 
for i in range(len(dic)):
 
    c1=codex[i].replace("\n","")
    a1=dic[i]
 
    tv=[]
    for i in range(len(q)-1):
        x3=q[i+1].split(",")
        h=0
        if x3[4]==c1:h=h+1
        dex=""+x3[5]
        if len(dex)<1:h=h+1    
        if h==2:tv.append(x3[2])
 
    point=[]
    for i in range(480):
        point.append(0)
 
    for t1 in tv:
        for m in range(len(code)):
            if code[m]==t1:
                n1=12*(y1[m]-1980)+m1[m]
                n2=12*(y2[m]-1980)+m2[m]
                for j in range(n1,n2+1):
                    point[j]=point[j]+1
 
    yy1=[]
    yy2=[]
    mm1=[]
    mm2=[]
 
    for i in range(len(q)-1):
        x3=q[i+1].split(",")
        h=0
        if x3[4]==c1:h=h+1
        dex=""+x3[5]
        if len(dex)>1:h=h+1    
        if h==2:yy1.append(x3[5])
        if h==2:mm1.append(x3[6])
        if h==2:yy2.append(x3[7])
        if h==2:mm2.append(x3[8])
 
    for i in range(len(yy1)):
        yyy2=yy2[i]
        mmm2=mm2[i]
        if len(yyy2)==0:mmm2=12
        if len(yyy2)==0:yyy2=2017
        n1=12*(int(yy1[i])-1980)+int(mm1[i])
        n2=12*(int(yyy2)-1980)+int(mmm2)
        for j in range(n1,n2+1):
            point[j]=point[j]+1
 
    px=[]
    for i in range(38):
        n1=12*(i-1)
        n2=n1+12
        z=0
        for j in range(n1,n2):
            if point[j]>z:z=point[j]
        px.append(z)    
 
 
    for i in range(len(px)):
        delta.append(a1+","+c1+","+str(1980+i)+","+str(px[i]))
 
gg=open("pp.csv","w",encoding='utf-8')
for line in delta:
    gg.write(line+"\n")
gg.close()