creating dict out of CSV file without the headers

[ranbarr]

Hi all,
Im pretty new to python and Im learing how to import CSV and make it a dictionary
I made it but I dont know how to remove the headers and the values are in a list and I need them not to lol
this is the code:

noc_dict = {}
def read_file_noc(file):
    with open("noc_countries.csv", "r") as my_csv:
        for line in my_csv:
            line = line.replace('\n', '')
            line = line.split(',')
            noc_dict[line[0]] = line[1:] 
   

return noc_dict
this is my output:

Output:
{'NOC': ['region'], 'AFG': ['Afghanistan'], 'ALB': ['Albania'], 'ALG': ['Algeria'], 'ASA': ['American Samoa'], 'AND': ['Andorra'], 'ANG': ['Angola'],

While it should be:

Output:
{'AFG': 'Afghanistan', 'ALB': 'Albania', 'ALG': 'Algeria', 'ASA': 'American Samoa', 'AND': 'Andorra', 'ANG': 'Angola',

I tried to find it online and solve it myself but I couldnt find the answer.. appreciate any help!

[Yoriz]

Try using next to skip the first line of the file and index 1 to not have the values in a list.

noc_dict = {}
def read_file_noc():
    with open("noc_countries.csv", "r") as my_csv:
        next(my_csv)
        for line in my_csv:
            line = line.replace('\n', '')
            line = line.split(',')
            noc_dict[line[0]] = line[1]

[ranbarr]

Try using next to skip the first line of the file and index 1 to not have the values in a list.

noc_dict = {}
def read_file_noc():
    with open("noc_countries.csv", "r") as my_csv:
        next(my_csv)
        for line in my_csv:
            line = line.replace('\n', '')
            line = line.split(',')
            noc_dict[line[0]] = line[1]

that worked! btw any idea how to remove the values from the lists? I didnt even tried to put them in list but they are

[Yoriz]

What values?.
what does your csv file look like and how does your output differ from your expected output?

[ranbarr]

What values?.
what does your csv file look like and how does your output differ from your expected output?

---

Added an Image of the CSV
the output I get is:

Output:
{'AFG': ['Afghanistan'], 'ALB': ['Albania'], 'ALG': ['Algeria'], 'ASA': ['American Samoa'], 'AND': ['Andorra'], 'ANG': ['Angola'],

which the values of the keys are in a list []

while the output it should be:

Output:
{'AFG': 'Afghanistan', 'ALB': 'Albania', 'ALG': 'Algeria', 'ASA': 'American Samoa', 'AND': 'Andorra', 'ANG': 'Angola',

which the key values are not in a list

[Yoriz]

Cannot see the csv but please don't use pictures in the future just cut and pasted a sample of the csv.
As I said before you need to change your indexing to 1
you have

noc_dict = {}
line = 'AFG, Afghanistan'

line = line.replace('\n', '')
line = line.split(',')
noc_dict[line[0]] = line[1:]
print(noc_dict)

which will output

Output:
{'AFG': [' Afghanistan']}

because [1:] is a list of the 1 index and all the rest of the items if there are any

---

you just want to use 1 as the index to get the item on its own

noc_dict = {}
line = 'AFG, Afghanistan'

line = line.replace('\n', '')
line = line.split(',')
noc_dict[line[0]] = line[1]
print(noc_dict)

Output:
{'AFG': ' Afghanistan'}

[ranbarr]

sorry didnt noticed, Thank you very much!