CSV File Help

[finndude]

Hi,

I only want to display the first five rows and I also want to sort it from highest to lowest.
not sure what to do so came here.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37

print ("Time for the results!!!") #prints time for results time.sleep(1) #adds a one second break if amount_of_player_1_cards > amount_of_player_2_cards: #if the amount of cards player one has is bigger than the amount player two has     print ("The winner, with " + amount_of_player_1_cards + " is....... " + username_1) #tells you the winner     time.sleep(1) #adds a one seocnd break     print (username_1 + " got the cards: ") #tells you what cards they got     print (player_1_cards) #shows the cards     time.sleep(1) #adds a one second break     print ("That makes " + username_2 + " second place with " + amount_of_player_2_cards + " cards") #tells you who came 2nd     with open("Card Game Scores.csv", "a+", newline = "") as save_score: #looking at what is in the file          save_score.write(player_1_results) #writes in the file what the users results were         save_score.write("\n") #adds a space to make it clearer         save_score.close() #saves and closes the file else:     print ("The winner, with " + amount_of_player_2_cards + " is....... " + username_2) #tells you the winner     time.sleep(1) #adds a one second break     print (username_2 + " got the cards: ") #tells you what cards they got     print (player_2_cards) #shows the cards     time.sleep(2) #adds a one second break     print ("That makes " + username_1 + " second place with " + amount_of_player_1_cards + " cards") #tells you who came 2nd     with open("Card Game Scores.csv", "a+", newline = "") as save_score: #looking at what is in the file          save_score.write(player_2_results) #writes in the file what the users results were         save_score.write("\n") #adds a space to make it clearer         save_score.close() #saves and closes the file          ##################################################################################################### time.sleep(2) #adds a 2 second break print ("This is how your scores compare to other winners of this game: ") #tells you this is how your socres compare to others time.sleep(1) #adds a 2 second break print ("This is these players most recent scores:") #tells you these are there most recent scores time.sleep(1) #adds a 1 second break all_scores = open("Card Game Scores.csv", "r") card_csv = csv.reader(all_scores,delimiter=",") sort_csv = sorted(card_csv,key=operator.itemgetter(1)) for eachline in sort_csv:     print (eachline)

this is the output:

Output:
Time for the results!!!
The winner, with 20 is....... finndude
finndude got the cards: 
['black:10', 'black:07', 'red:08', 'black:02', 'red:09', 'black:06', 'black:04', 'yellow:01', 'red:05', 'black:01', 'yellow:06', 'red:10', 'black:09', 'yellow:08', 'black:08', 'black:03', 'yellow:04', 'red:02', 'red:07', 'black:05']
That makes player2 second place with 10 cards
This is how your scores compare to other winners of this game: 
This is these players most recent scores:
["['finndude'", " '10']"]
["['finndude'", " '12']"]
["['finndude'", " '14']"]
["['finndude'", " '14']"]
["['finndude'", " '16']"]
["['finndude'", " '16']"]
["['player1'", " '18']"]
["['finndude'", " '20']"]
["['player1'", " '22']"]
["['finndude'", " '8']"]

the list of values is all stored in a CSV file

I want the output to be highest to lowest and only show the top 5 scores.

thanks.

[Larz60+]

example you can modify:

1 2 3 4 5 6 7 8 9

import csv   def first_seven_rows(filename):     with open(filename) as csvfile:         reader = csv.reader(csvfile)     for n, row in enumerate(reader):         if n > 6:             break         print(f"{}n: {row}")

[finndude]

When I put this in and replace the filename with what it is I get a syntax error. what to do from here?

[Larz60+]

always include exact error message in code tags.
I didn't test code, but see an error on line 9
change:

1	print(f"{}n: {row}")

To:

1	print(f"{n}: {row}")

[finndude]

With this in

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38

print ("Time for the results!!!") #prints time for results time.sleep(1) #adds a one second break if amount_of_player_1_cards > amount_of_player_2_cards: #if the amount of cards player one has is bigger than the amount player two has     print ("The winner, with " + amount_of_player_1_cards + " is....... " + username_1) #tells you the winner     time.sleep(1) #adds a one seocnd break     print (username_1 + " got the cards: ") #tells you what cards they got     print (player_1_cards) #shows the cards     time.sleep(1) #adds a one second break     print ("That makes " + username_2 + " second place with " + amount_of_player_2_cards + " cards") #tells you who came 2nd     with open("Card Game Scores.csv", "a+", newline = "") as save_score: #looking at what is in the file          save_score.write(player_1_results) #writes in the file what the users results were         save_score.write("\n") #adds a space to make it clearer         save_score.close() #saves and closes the file else:     print ("The winner, with " + amount_of_player_2_cards + " is....... " + username_2) #tells you the winner     time.sleep(1) #adds a one second break     print (username_2 + " got the cards: ") #tells you what cards they got     print (player_2_cards) #shows the cards     time.sleep(2) #adds a one second break     print ("That makes " + username_1 + " second place with " + amount_of_player_1_cards + " cards") #tells you who came 2nd     with open("Card Game Scores.csv", "a+", newline = "") as save_score: #looking at what is in the file          save_score.write(player_2_results) #writes in the file what the users results were         save_score.write("\n") #adds a space to make it clearer         save_score.close() #saves and closes the file           #################################################################################################### time.sleep(2) #adds a 2 second break print ("This is how your scores compare to other winners of this game: ") #tells you this is how your socres compare to others time.sleep(1) #adds a 2 second break print ("This is these players most recent scores: ") #tells you these are there most recent scores time.sleep(1) #adds a 1 second break def first_seven_rows("Card Game Scores.csv"):     with open(Card Game Scores.csv) as csvfile:         reader = csv.reader(csvfile)     for n, row in enumerate(reader):         if n > 6:             break         print(f"{n}: {row}")

I get the error

Error:
invalid syntax 

the error is where I entered my filename I enter ("Card Game Scores.csv")

the error was highlighting the apostrophe



if I remove the apostrophes I get an invalid syntax highlighting the letter G on Card Game Scores.

[Larz60+]

There must be more to the error message. Always include complete, unaltered, error traceback

[finndude]

The error is

Error:
 invalid syntax 

nothing more nothing less

https://imgur.com/a/E6Scghk

[finndude]

Hi,

I only want to display the first five rows and I also want to sort it from highest to lowest.
not sure what to do so came here.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37

print ("Time for the results!!!") #prints time for results time.sleep(1) #adds a one second break if amount_of_player_1_cards > amount_of_player_2_cards: #if the amount of cards player one has is bigger than the amount player two has     print ("The winner, with " + amount_of_player_1_cards + " is....... " + username_1) #tells you the winner     time.sleep(1) #adds a one seocnd break     print (username_1 + " got the cards: ") #tells you what cards they got     print (player_1_cards) #shows the cards     time.sleep(1) #adds a one second break     print ("That makes " + username_2 + " second place with " + amount_of_player_2_cards + " cards") #tells you who came 2nd     with open("Card Game Scores.csv", "a+", newline = "") as save_score: #looking at what is in the file          save_score.write(player_1_results) #writes in the file what the users results were         save_score.write("\n") #adds a space to make it clearer         save_score.close() #saves and closes the file else:     print ("The winner, with " + amount_of_player_2_cards + " is....... " + username_2) #tells you the winner     time.sleep(1) #adds a one second break     print (username_2 + " got the cards: ") #tells you what cards they got     print (player_2_cards) #shows the cards     time.sleep(2) #adds a one second break     print ("That makes " + username_1 + " second place with " + amount_of_player_1_cards + " cards") #tells you who came 2nd     with open("Card Game Scores.csv", "a+", newline = "") as save_score: #looking at what is in the file          save_score.write(player_2_results) #writes in the file what the users results were         save_score.write("\n") #adds a space to make it clearer         save_score.close() #saves and closes the file            ##################################################################################################### time.sleep(2) #adds a 2 second break print ("This is how your scores compare to other winners of this game: ") #tells you this is how your socres compare to others time.sleep(1) #adds a 2 second break print ("This is these players most recent scores:") #tells you these are there most recent scores time.sleep(1) #adds a 1 second break all_scores = open("Card Game Scores.csv", "r") card_csv = csv.reader(all_scores,delimiter=",") sort_csv = sorted(card_csv,key=operator.itemgetter(1)) for eachline in sort_csv:     print (eachline)

this is the output:

Output:
Time for the results!!!
The winner, with 20 is....... finndude
finndude got the cards: 
['black:10', 'black:07', 'red:08', 'black:02', 'red:09', 'black:06', 'black:04', 'yellow:01', 'red:05', 'black:01', 'yellow:06', 'red:10', 'black:09', 'yellow:08', 'black:08', 'black:03', 'yellow:04', 'red:02', 'red:07', 'black:05']
That makes player2 second place with 10 cards
This is how your scores compare to other winners of this game: 
This is these players most recent scores:
["['finndude'", " '10']"]
["['finndude'", " '12']"]
["['finndude'", " '14']"]
["['finndude'", " '14']"]
["['finndude'", " '16']"]
["['finndude'", " '16']"]
["['player1'", " '18']"]
["['finndude'", " '20']"]
["['player1'", " '22']"]
["['finndude'", " '8']"]

the list of values is all stored in a CSV file

I want the output to be highest to lowest and only show the top 5 scores.

thanks.

[anbu23]

1 2 3 4 5 6

all_scores = open("Card Game Scores.csv", "r") card_csv = csv.reader(all_scores,delimiter=",") sort_csv = sorted(card_csv,key=lambda elem: int(elem[1]),reverse=True) for count,eachline in enumerate(sort_csv):     if count<5:        print (eachline)