ひいい - 経済統計練習帳

f=open("code.csv","r",encoding="utf-8")
x=[]
for line in f:
    line=line.replace("\n","")
    x.append(line)
f.close()
 
univ=[]
dep=[]
code_univ=[]
code_dep=[]
 
for x1 in x:
    x2=x1.split(",")
    univ.append(x2[1])
    dep.append(x2[2])
    code_univ.append(x2[7])
    code_dep.append(x2[8])
 
dic_univ=[]
point_univ=[]
 
for u in range(len(univ)):
    h=0
    if univ[u] in dic_univ:h=100     
    if h<50:dic_univ.append(univ[u])
    if h<50:point_univ.append(code_univ[u])
 
dic_dep=[]
point_dep=[]
 
for u in range(len(dep)):
    h=0
    if dep[u] in dic_dep:h=100     
    if h<50:dic_dep.append(dep[u])
    if h<50:point_dep.append(code_dep[u])
 
f1=open("data2.csv","r",encoding="utf-8")
x1=[]
for line in f1:
    line=line.replace("\n","")
    x1.append(line)
f1.close()
 
for c in x1:
    c1=c.split(",")
    sx=-1
    if c1[1] in dic_univ:sx=dic_univ.index(c1[1])
    q1=""
    if sx>0:q1=point_univ[sx]    
    sx=-1
    if c1[2] in dic_dep:sx=dic_dep.index(c1[2])
    q2=""
    if sx>0:q2=point_dep[sx]  
    print(q1)