import pandas as pd
import time

start = time.time()

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

out = pd.DataFrame(columns = ["personId","average"])

for index, row in df.iterrows():
    if row["personId"] not in out.values:
        out = out.append({"personId": row["personId"], "average": row["average"]},
                    ignore_index=True)

out = out.sort_values("average")

print((out.head(10)).to_string(index=False))

print(time.time() - start)