how do I return Max Test result + corresponding student name from an excel dataset?

[snippsat]

You should follow jefsummers advice.

show us your code, what you have done so far!

yes in pandas, converted the excel file to list using pandas as pd

It should no be converted a list,maybe you mean DataFrame?

import pandas as pd

df = df.to_excel('file_name.xlsx', index=False)

Ok to show a example that can help,as you see it easy to make example code that other can run.

import pandas as pd
from io import StringIO

data = StringIO('''\
Movie,Year
The Godfather,1972
Seven,1995
Jaws,1975
Lawrence of Arabia,1962''')

df = pd.read_csv(data, sep=',')

# A DataFrame this is what all data that comes into Pandas become
>>> df
                Movie  Year
0       The Godfather  1972
1               Seven  1995
2                Jaws  1975
3  Lawrence of Arabia  1962
>>> 
>>> year_max = df['Year']
>>> year_max.max()
1995
>>> 
>>> # To get max value and whole row
>>> year = df[df['Year']==df['Year'].max()]
>>> year
   Movie  Year
1  Seven  1995