You should follow jefsummers advice.
(Jan-16-2022, 04:52 PM)jefsummers Wrote: show us your code, what you have done so far!
sean1 Wrote: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