import pandas as pd
import time
from operator import itemgetter

start = time.time()

df = pd.read_csv("WCAdbNEW/WCA_export_Results.tsv",delimiter="\t")
df = df[["eventId","personId","average"]]
df = df.loc[df["eventId"]=="333bf"]
df = df.loc[df["average"]>0]

out = [[],[]]

for index, row in df.iterrows():
    if row["personId"] not in out[0]:
        out[0].append(row["personId"])
        out[1].append(row["average"])

out = sorted(list(zip(out[0],out[1])), key=itemgetter(1))

print(out[0:20])

print(time.time() - start)