Python Forum

SOLVED: I was trying
if maxScore == 'None':
continue

I needed to write

if str(maxScore) == 'None':
continue

The situation is this:

1. I am using openpyxl to insert scores to my target excel table, then copy over all the old data from the source file.
2. I reach the stage where I have copied all the old scores into the new table successfully.
3. Now I want to calculate the % scores and put them in the column left of the column 'score' . I look along row 3 of my table and look for the string 'score'.
4. Above 'score', in row 1 is a number. This is the maximum score for this test, maxScore.
5. Use maxScore and the students score in each column to calculate the % score for each score in that column.

Easy. This works fine when maxScore is not 'None'

The trouble comes when the content of the maxScore cell is 'None'. Sometimes, for that sheet, for that class, there is nothing that week.

I need a condition to ignore that column and look for the next column with 'score' if the cell in row 1 above 'score' has content 'None'. So I need 2 conditions: 1. row 3 cell contains 'score'. 2. row 1 above 'score' is not 'None'. I've tried various things without success so far.

Grateful for any tips!

for sheet in targetFileSheetNames:
    targetFileActiveSheet = targetFile.get_sheet_by_name(sheet)
    maxRow = targetFileActiveSheet.max_row
    maxCol = targetFileActiveSheet.max_column
    print('sheet is ' + sheet)
    for colNum in range(8, maxCol + 1):
        if targetFileActiveSheet.cell(row=3, column=colNum).value == 'score':
            maxScore = targetFileActiveSheet.cell(row=1, column=colNum).value
            print('The maximum score is ' + str(maxScore))
            for rowNum in range(4, maxRow + 1):
                value = targetFileActiveSheet.cell(row=rowNum, column=colNum).value
                print('value is ' + str(value))
                percentScore = int(value / maxScore) * 100
                print('The percent score is ' + str(percentScore))
                targetFileActiveSheet.cell(row=rowNum, column=colNum - 1, value=percentScore)

Quote: SOLVED: I was trying
if maxScore == 'None':
continue

I needed to write

if str(maxScore) == 'None':
continue

Don't use str() like this, just refer to None itself, instead of a string which happens to contain "None".

>>> x = None
>>> x == "None"
False
>>> x is "None"
False
>>> x == None
True
>>> x is None
True