List index out of range when turning CSV into dict

[ranbarr]

It's an Excel but I saved it as CSV

If it is saved as CSV UTF-8 (Comma delimited) (.csv) it should have commas (or other separator) between values. Sample data you provided doesn't have commas. Empty values should be also be present between commas.

Its saved as CSV (comma delimited), not UTF - 8

[ibreeden]

@ranbarr: About your code: although there is room for improvement your code should work. The problem is in the data.

About saving your data as CSV: I don't have Excel so I cannot check, but when saving your data as CSV, is there an option to choose a separator? It seems a space is chosen as separator.
If there is no option to choose a separator, please read How to change the delimiter when exporting CSV from Excel.

[ranbarr]

Excel so I canno

I tried to save the file as CSV UTF and just as CSV after changing the delimeter and list seperation as the guide said.. still getting the same output

Output:
{'1': {'Gold': '1', 'Silver': '1', 'Bronze': '1', 'Total': '1'},

[perfringo]

CSV UTF-8 (Comma delimited) (.csv)

Its saved as CSV (comma delimited), not UTF - 8

My up-to-date Excel under macOS has this exact option to save as csv. There are other options as well (Comma Separated Values (.csv), Macintosh Comma Separated (.csv), MS-DOS Comma Separated (.csv)) but this one should be preferred as 'universal encoding'. However, regardless of saved encoding separator must be present anyway.

For those of us who use Mac and have ; as separator:

For Mac OS the chosen value separator depends on Region and region's default number separators. To change them, go to “System Preferences” > “Language & Region”. Then you need to verify the number separators in “Advanced …” > “General”.

Here are the rules Excel uses to determine how it saves CSV files:

1. If your language / region / locale uses comma (,) for decimal separation then Excel will save using semi-colons (;)
2. If it uses a dot (.) full stop or period, then it will delimit with commas (,).

[ibreeden]

I tried to save the file as CSV UTF and just as CSV after changing the delimeter and list seperation as the guide said.. still getting the same output

Output:
{'1': {'Gold': '1', 'Silver': '1', 'Bronze': '1', 'Total': '1'},

Not so hasty, programming is a matter of stepwise refinement . First look at the CSV file. Use NOTEPAD.EXE or vi to inspect it. Does it contain separators as it should?
Second: ajust your code to match the field separator and show us your code. And then also show the output. The complete output, not the line ending with a comma as you did. And if there are errors we want to see the complete error message.

[ranbarr]

I tried to save the file as CSV UTF and just as CSV after changing the delimeter and list seperation as the guide said.. still getting the same output

Output:
{'1': {'Gold': '1', 'Silver': '1', 'Bronze': '1', 'Total': '1'},

Not so hasty, programming is a matter of stepwise refinement . First look at the CSV file. Use NOTEPAD.EXE or vi to inspect it. Does it contain separators as it should?
Second: ajust your code to match the field separator and show us your code. And then also show the output. The complete output, not the line ending with a comma as you did. And if there are errors we want to see the complete error message.

Yeah hasty is indeed my problem lol... I did all this and changed the code and it worked! TY!