Excel
数据-数据验证-(设置验证条件)-圈释无效数据
pandas
import pandas as pd
def score_validation(row):
try:
assert 0<=row.Score<=100
except:
print(f'#{row.ID}\tstudent{row.Name}\thas an invalid score{row.Score}')
students=pd.read_excel('017/Students.xlsx')
students.apply(score_validation,axis=1)
students.apply(score_validation,axis=1)#从左到右读取数据
DataFrame的axis有两个值
0指从上到下的轴,1指从左到右
打印数据的方法
f !!才能显示{row.ID}
print(f'#{row.ID}\tstudent{row.Name}\thas an invalid score{row.Score}')
结果: