Sorting information from a file in python

Question

I have a .txt file that has the following information in it that displays a users name and then 3 scores that they have scored in a quiz:

callum,10,7,9
carl,10,10,10
hollie,1,4,7
brad,4,8,3
kyle,7,2,0

I would like to sort it into alphabetical order displaying the users highest score after their name.

I have opened the txt file by using : file = open('scores.txt', 'r') — Neenan37
– Neenan37, Commented Jan 23, 2015 at 9:13
Give more information on input file. callum,10,7,9 and carl,10,10,10 are on same line?? — Vivek Sable
– Vivek Sable, Commented Jan 23, 2015 at 9:15
No each different user is on a separate line, it wont let me post a picture though because i dont have enough rep — Neenan37
– Neenan37, Commented Jan 23, 2015 at 9:16
@Neenan37 It's probably going to flag as unclear what you asking — GLHF
– GLHF, Commented Jan 23, 2015 at 9:18
@Neenan37 Because too many informations are missing. You have to show us some codes here. How is your input-output etc. Instead of trying to explain them in comments, write them in your question please. — GLHF
– GLHF, Commented Jan 23, 2015 at 9:20

Vivek Sable · Accepted Answer · 2015-01-23 09:30:16Z

Read file content.
Use readlines() method to read lines from file.
Use split() to get Name and score.
Add in dictionary: Name is Key and Value is total score.
Get all keys from the result dictionary.
User sort() method to sort list by alphabets.
Print result by alphabets order.

Code

p = "/home/vivek/Desktop/test_input.txt"
result = {}
with open(p, "rb") as fp:
    for i in fp.readlines():
        tmp = i.split(",")
        try:
            result[(tmp[0])] = eval(tmp[1]) + eval(tmp[2]) + eval(tmp[3]) 
        except:
            pass

alphabetical_name =  result.keys()
alphabetical_name.sort()

for i in alphabetical_name:
    print "Name:%s, Highest score: %d"%(i, result[i])

Output:

$ python test.py 
Name:brad, Highest score: 15
Name:callum, Highest score: 26
Name:carl, Highest score: 30
Name:hollie, Highest score: 12
Name:kyle, Highest score: 9

Stefano · Accepted Answer · 2015-01-23 14:42:45Z

0

So i would first of all isolate all the lines:

with open('filename') as f:
    lines = f.readlines()

So i will continue assuming I have a list called lines with the following content:

lines = ["callum,10,7,9","carl,10,10,10","hollie,1,4,7","brad,4,8,3","kyle,7,2,0"]

Then I will firstly sort the line by name

lines = sorted(lines)

Then for each line you want to isolate the marks, sort them and print them back:

for line in lines:
    #name is what there is before the first comma
    name = line[:line.find(",")]
    #marks are what there is after the second comma and are comma separated
    marks = line[line.find(",")+1:].split(",")
    #sort the marks
    marks = sorted(marks,key=int)

    #if you want to print only the highest
    print "%s,%s"%(name,marks[-1])

edited Jan 23, 2015 at 14:42

answered Jan 23, 2015 at 9:28

Stefano

4,0419 gold badges39 silver badges66 bronze badges

6 Comments

Neenan37 Over a year ago

it says invalid syntax name = line.[:line.lfind(",")] on the first square bracket

Stefano Over a year ago

sorry... no . before the bracket... it was just a typo

Neenan37 Over a year ago

fixed that, but its printing their first score in the text file, not their highest score

Stefano Over a year ago

can you print marks just before sorting them and just after and paste the result?

Neenan37 Over a year ago

its printing off: brad,4 callum,7 carl,10 hollie,4 kyle,2

|

Collectives™ on Stack Overflow

Sorting information from a file in python

2 Answers 2

Comments

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related