pandas删除不满足条件的数据

train=pd.read_excel('./13.xlsx',sheet_name='gonghuo')

train=train.drop(train[train['sum']<500].index)

train.to_excel('data.xlsx',encoding='utf-8')

print(train)