しゆ８ - 経済統計練習帳

f=open("data.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("art.csv","r",encoding='utf-8')
q=[]
for line in g:
    q.append(line)
g.close()
 
c1="220850"
 
tv=[]
for i in range(len(q)-1):
    x3=q[i+1].split(",")
    if x3[4]==c1: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]
            print(t[m]+","+str(n1)+","+str(n2))
            for j in range(n1,n2+1):
                point[j]=point[j]+1
 
print(point)