import pandas as pd
df = pd.read_csv('Nowcoder.csv') #去重 df.drop_duplicates(['Level','Name'],inplace=True) df1 = df.groupby('Level').size() #获取人数大于5的数据并按索引升序排序 print(df1[df1>5].sort_index())