How do you make a leaderboard in python?

Question

I am working on a project for my school and I was wondering if there is a way to make a leaderboard in python? I am fairly new to python and so far, what I have done is get the user's input and store it in a text file. I'm not sure how to continue. Any help is appreciated, thanks!

x = 0

Name = [None]*1000
Class = [None]*1000
Score = [0]*100

# opens the text file called text_file
text_file = open("write.txt","a")

# puts in the values of the highest scores and "saves it" by closing and opening the file
def write_in_file():
    global text_file
    text_file.write(Name[x])
    text_file.write("\n")
    text_file.write(Class[x])
    text_file.write("\n")
    text_file.write(Score[x])
    text_file.write("\n")
    text_file.write("\n")
    text_file.close()
    text_file = open("write.txt","a")

# asks for player data and puts highest value in a file
for i in Name:
    Name[x] = input("Name:")
    Class[x] = input("Class:")
    Score[x] = input("Score:")
    write_in_file()
    print(Score)
    x += 1

Answer 1

You can use pandas for making a leaderboard table. Here is a sample:

import pandas as pd

df = pd.DataFrame({'Name': ['x','y','z'],
                   'Class':  ['B','A','C'],
                    'Score' : [75,92,56]})
print (df)

Out[3]: 
  Class Name  Score
0     B    x     75
1     A    y     92
2     C    z     56


# changing order of columns
df = df.reindex_axis(['Name','Class','Score'], axis=1)

# appending
df.loc[3] = ['a','A', 96]

print (df)

Out[15]: 
  Name Class  Score
1    y     A     92
3    a     A     96
0    x     B     75
2    z     C     56

# sorting
df = df.sort(['Class', 'Score'], ascending=[1, 0])

print (df)

Out[16]: 
  Name Class  Score
3    a     A     96
1    y     A     92
0    x     B     75
2    z     C     56