Issue in creating dictionary using csv in python

Question

I have a CSV in below format

Where i want to convert it to dictionary in the below format,

    {'Feature': 'Delivery', 'Subfolders': 'Child - 1', 'Child - 2' 'Child - 3' 'Child - 4' 'Child - 5', 'Child - 6'.... till 'Child -13'}

So far I had done the following code but am getting output like this,

    {'Feature': 'Delivery', 'Subfolders': 'Child - 1'}

import csv
with open('features.csv', mode='r') as infile:
    reader = csv.reader(infile)
    mydict = {rows[0]: rows[1] for rows in reader}
print(mydict)

Thoughts?

It should be: 'Subfolders': ['Child - 1', 'Child - 2' 'Child - 3' 'Child - 4' 'Child - 5', 'Child - 6'.... 'Child -13'] — N. Arunoprayoch
– N. Arunoprayoch, Commented Aug 2, 2019 at 3:19
Your code can work if you change row[1] to " ".join(row[1:]). — Henry Yik
– Henry Yik, Commented Aug 2, 2019 at 3:36

N. Arunoprayoch · Accepted Answer · 2019-08-02 05:55:23Z

2

How about this? I just added a filter and list slicing.

with open('test.csv', mode='r') as f:
    reader = csv.reader(f)
    checker = lambda i: bool(i and i.strip()) # Conditions to check whether a string is empty or not
    mydict = {rows[0]: list(filter(checker, rows[1:])) for rows in reader}

    print(mydict)

Results:

{'Feature': ['Delivery'], 'Subfolder': ['Child - 1', 'Child - 2', 'Child - 3', 'Child - 4', 'Child - 5', 'Child - 6', 'Child - 7', 'Child - 8', 'Child - 9', 'Child - 10', 'Child - 11', 'Child - 12', 'Child - 13']}

Additional answer:

According to your comment, if I understand correctly, you'd like to get values from a given key.

If you have one a few keys to deal with, you can simply assign each one of them in a new variable

features = mydict['Feature']
subfolders = mydict['Subfolder']

print(features, subfolders)
# ['Delivery'] ['Child - 1', 'Child - 2', 'Child - 3', 'Child - 4', 'Child - 5', 'Child - 6', 'Child - 7', 'Child - 8', 'Child - 9', 'Child - 10', 'Child - 11', 'Child - 12', 'Child - 13']

edited Aug 2, 2019 at 5:55

answered Aug 2, 2019 at 3:28

N. Arunoprayoch

94213 silver badges22 bronze badges

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

2 Comments

ilexcel Over a year ago

How can I store subfolder's and feature's values alone in seperate variables for each and print?

N. Arunoprayoch Over a year ago

@ilexcel Please check my additional answer

CemreY · Accepted Answer · 2019-08-02 03:40:26Z

1

Just another way of doing it.

import csv
with open('test.csv', mode='r') as infile:
    reader = csv.reader(infile)
    mydict = dict()
    for rows in reader:
        cnt = 0
        for row in rows:
            if cnt == 0:
                mydict[row] = list()
                cnt += 1
            else:
                mydict[rows[0]].append(row)
print(mydict)

Result:

{'this': ['1', '2'], 'That': ['2', 'as']}

answered Aug 2, 2019 at 3:40

CemreY

3944 silver badges13 bronze badges

Comments

Aldair LUNA BUITRON · Accepted Answer · 2019-08-02 04:58:17Z

0

import csv
with open('features.csv', mode='r') as infile:
reader = csv.reader(infile)

mydict = {}

for i in reader:

    if '' in i:
        mydict[i[0]] = i[1:2]

    else:
        mydict[i[0]] = i[1:]

print(mydict)

Result

{'Feature': ['Delivery'], 'subfolders': ['Child – 1', 'Child – 2', 'Child – 3', 'Child – 4', 'Child – 5', 'Child – 6', 'Child – 7', 'Child – 8']}

Then

features = mydict['Feature']
subfolders = mydict['subfolders']

print(features)
print(subfolders)

answered Aug 2, 2019 at 4:58

Aldair LUNA BUITRON

11 bronze badge

Collectives™ on Stack Overflow

Issue in creating dictionary using csv in python

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related