How do you open a file using python, split rows into lists and then search for the row with the highest value in the third list

Question

My script wont work, any suggestions appreciated...

The .txt file has 30 rows of data containing first name, second name, and a test mark which is a double digit number...

file = open ("testmarks.txt", "r")

for i in file:
    list = i.split()

#Get highest mark and print name

for(i) in list[2]:
    max_value = max(i)
    print('Highest mark was', max_value, 'achieved by', list[0], list[1])

question from:https://stackoverflow.com/questions/66052758/how-do-you-open-a-file-using-python-split-rows-into-lists-and-then-search-for-t

Answer 1

You can try something like

input_file = open ("testmarks.txt", "r")

lists = [row.split() for row in input_file.readlines()]

lists = sorted(lists, key=lambda row: row[2], reverse=True)

print(f'Highest mark was {lists[0][2]} achieved by {lists[0][0]} {lists[0][1]}')