辞書作成 - 経済統計練習帳

g=open("ar.csv","r",encoding='utf-8')
q=[]
for line in g:
    q.append(line)
g.close()
 
 
a=[]
c=[]
for i in range(len(q)-1):
    x3=q[i+1].split(",")
    a.append(x3[3])
    c.append(x3[4])
 
dic=[""]
code=[""]
for  i in range(len(c)):
    h=0     
    if c[i] in code:h=100   
    if h<50:dic.append(a[i])
    if h<50:code.append(c[i])  
 
n=len(dic)
 
point=[]
for i in range(n):
    point.append(0)
 
for c1 in c:
    sx=code.index(c1)
    point[sx]=point[sx]+1
 
sig=[]
for i in range(n):
    if point[i]>4:sig.append(dic[i]+","+code[i])
 
print(sig)        
 
f=open("t.csv","w",encoding='utf-8')
for line in sig:
    f.write(line+"\n")
f.close()