擅长:python、mysql、java
<pre><code>import pandas as pd
data = pd.read_csv(your_path.txt, sep="\t")
data["Tot Points"] = data.groupby("Name")["Points"].transform(sum)
data.sort_values(by="Tot Points", ascending=False, inplace=True)
data.drop_duplicates(subset=["Name"], inplace=True)
data.drop(columns="Points", inplace=True)
data = data.head(n=10)
data.to_csv("output_path.txt", sep="\t", index=False)
</code></pre>