Students11.xlsx

    1. import pandas as pd
    4. # def score_validation(row):
    5. #     try:
    6. #         assert 0 <= row.Score <= 100
    7. #     except:
    8. #         print(f'#{row.ID}\tstudents{row.Name} has an invalidation score {row.Score}')
    9. def score_validation(row):
    10.     if not 0 <= row.Score <= 100:
    11.         print(f'#{row.ID}\tstudents{row.Name} has an invalidation score {row.Score}')
    14. students = pd.read_excel('tmp1\Students11.xlsx')
    15. students.apply(score_validation, axis=1)  # 1表从左到右的轴  0表示从上到下的轴
    16. # 1表示横轴，方向从左到右；0表示纵轴，方向从上到下。
    17. """
    18. #1    studentsStudent_001 has an invalidation score -40
    19. #2    studentsStudent_002 has an invalidation score -30
    20. #3    studentsStudent_003 has an invalidation score -20
    21. #4    studentsStudent_004 has an invalidation score -10
    22. #16    studentsStudent_016 has an invalidation score 110
    23. #17    studentsStudent_017 has an invalidation score 120
    24. #18    studentsStudent_018 has an invalidation score 130
    25. #19    studentsStudent_019 has an invalidation score 140
    26. #20    studentsStudent_020 has an invalidation score 150
    27. """