Sorting integers in a csv file - python -

i have csv file looks this:

tom,10 jack,10 alice,10 ben,9 

i need able sort second column highest lowest. have tried following code:

import csv  file = open("bestscores.csv","r") reader = csv.reader(file, delimiter = ' ')  sort = sorted(reader,key=lambda x: int(x[1]), reverse=true) print(sort) 

this results in following error:

valueerror: invalid literal int() base 10: 'tom,10' 

how can solve this?

you using wrong delimiter , sorting wrong index. should work you:

import csv  open("bestscores.csv","r") fh   reader = csv.reader(fh, delimiter = ',')    sort = sorted(reader, key=lambda x: int(x[1]), reverse=true)   print(sort)