How to create a dictionary from a comma-separated values?

Question

I need to create a dictionary from a text file that contains comma-separated values.
So far I wrote this much.

import csv
pick = open('a.txt','r')
read = csv.reader(pick)
reviews = {}

The sample data in the text file looks like this

Peter,Gravity,4.5,For a Few Dollars More,1.0,Prometheus,4.0
Jack Holmes,Lawrence of Arabia,3.0,Gravity,3.5,The Godfather,1.5,Prometheus,5.0,The Guns of Navarone,3.0

And I want to create a dictionary that should look like this

{'Peter': {'Gravity': 4.5,
          'For a Few Dollars More': 1.0,
          'Prometheus': 4.0},

'Jack Holmes': {'Lawrence of Arabia': 3.0,
                'Gravity': 3.5,
                'The Godfather': 1.5,
                'Prometheus': 5.0,
                'The Guns of Navarone': 3.0,}
}

I looked on these pages: this this this this but didn't help to answer my question.
Could you give me some hints or ideas on how to accomplish this?

@SubbuVidyaSekar,
was a typo. No there won't be a
at the end of each line. — 007mrviper, Apr 18 '20 at 03:21
at the end of each line, any possibility for enter key press or continuous lines? — Subbu VidyaSekar, Apr 18 '20 at 03:30
@SubbuVidyaSekar, continuous lines. Since, a file has to be read so, need for the key press. — 007mrviper, Apr 18 '20 at 03:32

Patrick Haugh · Accepted Answer · 2020-04-18T16:18:54.770

2

This solution uses zip to pair the keys and values for the interior dictionaries.

d = {}

with open('a.txt') as f:
    for line in csv.reader(f):
        it = iter(line)
        key = next(it)
        d[key] = dict(zip(it, it))

If you need float values, you can do something like

d[key] = dict((a, float(b)) for a, b in zip(it, it))

edited Apr 18 '20 at 16:18

answered Apr 18 '20 at 03:43

Patrick Haugh

59,226
13
88
96

change to **key = next(it)** its a typo – Subbu VidyaSekar Apr 18 '20 at 04:08
@Patrick Haugh, your solution worked. This is what I wanted. Thank you! Btw, please edit the part key = next(it). – 007mrviper Apr 18 '20 at 04:12
@007mrviper: validate your result. still some work is there. the whole list is coming as value for the key – Subbu VidyaSekar Apr 18 '20 at 04:31
@SubbuVidyaSekar I already did. That's why I accepted his answer. – 007mrviper Apr 18 '20 at 04:45
{'Peter': {'Gravity': '4.5', 'For a Few Dollars More': '1.0', 'Prometheus': '4.0', 'Jack Holmes': 'Lawrence of Arabia', '3.0': 'Gravity', '3.5': 'The Godfather', '1.5': 'Prometheus', '5.0': 'The Guns of Navarone'}} this is the result you might get.. – Subbu VidyaSekar Apr 18 '20 at 04:47

score 0 · Answer 2 · answered Apr 18 '20 at 04:05

Here is a not so great but simple solution:

import csv

mydict = {}
with open('file.csv', mode='r') as infile:
    reader = csv.reader(infile)
    mylist = list(reader)
    for i in range(len(mylist)):
        z = iter(mylist[i][1:])
        mydict[mylist[i][0]] = dict(zip(z, z))

print(mydict)

How to create a dictionary from a comma-separated values?

2 Answers2