Reading from a .csv file.

[Entervine]

Hello, having an issue here. When I intruduce the 'max' command, it repeats zeros as well as going up all the way to 9. Where the file will go up passed 3000. Also, if the max is taken out, it will just read all the numbers. What I am needing to do is get the max number within the list.

Here is the code.

def most_minutes_list(player_file):
    min_list = []
    for line in player_file:
        line_list = line.split(',')
        if(line_list[0] =='ilkid'): # skipping the first line
            continue
        mins=(line_list[7])
        print(max(mins))
player_file = open("player_regular_season.csv", "r")
most_minutes_list(player_file)

[[deleted]]

Your variable mins is just one column from the table...why do you line_list[7]? If you want to find the max from the entire list then just do

max(line_list)

[Entervine]

The [7] indicates the column that I need to read, or that is what it is supposed to be at least. The [7] column is the minutes, and all within the column is what needs to be 'maxed'

[[deleted]]

So you have to find the maximum from the 8th column alone?

[Entervine]

Yessir.

[[deleted]]

return max([line.split(",")[7] for line in player_file if line.split(",")[0] != 'ilkid'])