うういういう - 経済統計練習帳

from scipy.stats import rankdata
import numpy as np
 
f = open('t.csv', 'r',encoding="UTF-8")
 
x=[]
for line in f:
    x.append(line)
 
y=[]
m=[]
d=[]
t=[]
c=[]
p=[]
 
for i in range(len(x)-1):
    sig=x[i+1].split(",")
    y.append(sig[0])
    m.append(sig[1])
    d.append(sig[2])
    t.append(sig[3])
    c.append(sig[4])
    p.append(sig[5])
 
pon=[]
for p1 in p:
    p2=p1.replace("\n","")
    pon.append(int(p2))
 
dic=[]
for t1 in t:
    h=0 
    if t1 in dic:h=100
    if h<50:dic.append(t1)   
 
point=[]
for i in range(len(dic)):
    point.append(0)    
 
for i in range(len(t)):
    sx=dic.index(t[i])
    point[sx]=point[sx]+pon[i]   
 
a = np.array(point)
r = rankdata(a)
 
for i in range(len(dic)):
    r1=len(dic)-r[i]
    if r1<100:print(dic[i]+","+str(point[i]))