python 对输入的数据进行排序,如何在python中创建的csv文件中按字母顺序对数据进行排序？...

The name of a user and their score from a quiz is entered in a csv file. I want to sort the name of the user alphabetically, however I don't know how to do this. Thanks in advance. Here are snippets of my code.

userName=input('Please enter your full name: ').title()

newrecord = "{user_name},{score_1},{score_2},{score_3}\n".format(user_name=userName, score_1=quiz_scores[0], score_2=quiz_scores[1], score_3=quiz_scores[2])

classa = input("What class are you in? ")

if classa =='1':

file=open('classroom1.csv', "a+")

file.write(newrecord)

file.close()

with open('classroom1.csv') as csvfile:

readCSV = csv.reader(csvfile)

解决方案

Why not use Pandas?

df = pd.read_csv('classroom1.csv', sep = ',', names = ['user_name','score_1','score_2','score_3'])

df = df.sort('user_name')

df.to_csv('classroom1.csv', index = False, header = False)

That should take care of it.