How do I create a dictionary from a csv using python

Question

I have a csv file of the format:

spelling, pronunciation, syllables, tag
head, H-EH-D, 1, NSING
bottle, B-O-T-UH-L, 2, NSING
fall, F-AW-L, 1, VBASE

I would like to convert it into a dictionary of the form: 'head' : ['H-EH-D', '1', 'NSING']

You can't have a dictionary entry that looks like that. I suggest either:- 'head': 'H-EH-D, 1, NSING' or 'head': ['H-EH-D', '1', 'NSING'] — user2668284
– user2668284, Commented Aug 9, 2021 at 13:08
@DarkKnight edited as per your suggestion and to alfinkel24 thank you but it doesn't seem to have exactly what I'm looking for. — Hermit
– Hermit, Commented Aug 9, 2021 at 13:18
Please edit your question to show the code you've tried and we can help you further — user2668284
– user2668284, Commented Aug 9, 2021 at 13:22
I've tried a few things such as using the csv.DictReader module and creating a none-type object in dictionary format but they're all separate implementations. I wanted a fresh implementation, if that makes sense as none of them quite does what I want. — Hermit
– Hermit, Commented Aug 9, 2021 at 13:46

ComteHerappait · Accepted Answer · 2021-08-09 13:31:06Z

1

(using csv library, thank for the suggestion @Serge Ballesta)

This solution may work for you :

import csv
result = {}
# open file
with open("file.csv", "r") as csv_file:
    parsed_csv = csv.reader(csv_file) # parse data with csv library
    next(parsed_csv) # skip first line
    # store line in dictionnary
    for line in parsed_csv:
        result[line[0]] = line[1:]
print(result)

This code will print :

{"head": ["H-EH-D", "1", "NSING"], "bottle": ["B-O-T-UH-L", "2", "NSING"], "fall": ["F-AW-L", "1", "VBASE"]}

for your example.

edited Aug 9, 2021 at 13:31

answered Aug 9, 2021 at 13:18

ComteHerappait

971 silver badge6 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Serge Ballesta Over a year ago

Sigh..., why do you split the line by hand instead of using the csv module from the standard library?

Tomerikoo · Accepted Answer · 2021-08-09 14:33:33Z

1

I had created test.csv file with only two inputs as followed:

head,H-EH-D,1,NSING
bottle,B-O-T-UH-L,2,NSING

My code:

import csv

my_dict = {}
with open('test.csv', mode='r') as infile:
    reader = csv.reader(infile)
    for row in reader:
        key, value = row[0], row[1:]
        # my_dict={rows[0]:rows[1:] for rows in reader}
        my_dict[key] = value

print(my_dict)

The output of the above code looks like:

{'head': ['H-EH-D', '1', 'NSING'], 'bottle': ['B-O-T-UH-L', '2', 'NSING']}

edited Aug 9, 2021 at 14:33

Tomerikoo

19.6k16 gold badges57 silver badges68 bronze badges

answered Aug 9, 2021 at 13:22

Bishikh

112 bronze badges

Collectives™ on Stack Overflow

How do I create a dictionary from a csv using python

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related