python对二代测序流程中物种去重

import pandas as pd
df1=pd.read_csv(r'classify_abundance_result.anno.xls',sep='\t')
print(df1)

df1=df1[df1['Name']!='Spirometra erinaceieuropaei'].reset_index(drop=True)
print(df1)
df1=df1.drop_duplicates(subset=['G_name'],keep='first').reset_index(drop=True)
print(df1)

sum_info=sum(df1['G_Count'].tolist())
print(sum_info)