Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
4. Exercise 3


Looking good! This one might be trickier!


Load the attendance_list.xlsx file. There is only one worksheet, attendance_list. The structure of the worksheet looks like this:

class_date class_date
student_name X

An X indicates that a given student was absent.

Find the total number of times students were absent. Assign the result to the result variable and print it.

Stuck? Here's a hint!

To iterate over all rows and all columns in a sheet you can use the for loops:

for row in ws:
  for cell in row: