ESR leaderboard code

location ="C:\\Users\\logan\\Downloads\\ESR LeaderBoard S1 - Overal (11).csv"


def getData():
    file = open(location,"r")
    data = file.read()
    data = data.replace("\n",",")
    array = data.split(",")
    #for i in range(0,len(array)):
       #print(array[i])
    return array


class Player:
    currentPlayers =[]
    def __init__(self, name, kills,rounds,average):
        self.stats = [name,kills,rounds,average]

    def __str__(self):
        string = "\n\
        Name : "+self.stats[0]+"\n\
        Kills : "+self.stats[1]+"\n\
        Rounds : "+self.stats[2]+"\n\
        Average : "+self.stats[3]+"\n"

        return string


def generate_Players():
    data = getData()
    lenght = len(data)
    i = 5
    while(i < lenght):
        name = data[i+1]
        kills = data[i+2]
        rounds = data[i+3]
        average = data[i+4]

        newPlayer = Player(name, kills,rounds,average)
        Player.currentPlayers.append(newPlayer)
        i += 5
    for player in Player.currentPlayers:
        #print(player)
        a = 0


#Simple selection sort
def sort_by_column(column):
    List = Player.currentPlayers
    sortedPointer = 0
    lenght = len(List)
    while(sortedPointer < lenght):
        currentMaxPointer = sortedPointer
        currentMax = List[currentMaxPointer].stats[column]
        for i in range(0,lenght-sortedPointer):
            value = List[sortedPointer + i].stats[column]
            if float(value) > float(currentMax):
                currentMax = value
                currentMaxPointer = sortedPointer + i
        List[sortedPointer], List[currentMaxPointer] = List[currentMaxPointer],List[sortedPointer]
        sortedPointer += 1
    for element in List:
        #print(element)
        a=0

def generateRank(column):
    List = Player.currentPlayers
    lenght = len(List)
    rank = 0
    while (rank < lenght-1):
        value = List[rank].stats[column]
        name = List[rank].stats[0]
        string = "#"+str(rank+1)+" "+name
        j = 1
        while (value == List[rank+j].stats[column]):
            string += "/"+List[rank+j].stats[0]
            if (rank+j+1 < lenght):
                j += 1
            else:
                break
        string += " - "+str(value)
        print(string)
        rank += j



generate_Players()
print("--------------------------------")
print("Total Kills")
print(" ")
sort_by_column(1)
generateRank(1)
print("--------------------------------")
print("Total Rounds")
print(" ")
sort_by_column(2)
generateRank(2)
print("--------------------------------")
print("Kills per round")
print(" ")
sort_by_column(3)
generateRank(3)