parse CSV file into dictionary with multiple values per key

Question

I want to create a simple config CSV file for my python script that will be loaded into a dictionary. Every line should represent a dictionary key with a list of values.

The structure will look like this:

key, value1, value2, value3, value4
key, value1, value2, value3, value4
key, value1, value2, value3, value4

A print (list) looks like this:

['key,value1,value2,value3,value4','key,value1,value2,value3,value4','key,value1,value2,value3,value4']

My function for reading input file gives me back a list with element per line. Here I try to build the dictionary with the split string function in a loop. But I cannot get the syntax right. I have found some similar examples, but they don't seem to work in python 3.

result = dict(line.split(",")[0],[line.split(",")[1:] for line in list)

Can you please provide some sample input?

Kurt Kline
– Kurt Kline

2020-05-16 12:56:28 +00:00
Commented May 16, 2020 at 12:56 — Kurt Kline
– Kurt Kline, Commented May 16, 2020 at 12:56

mechanical_meat · Accepted Answer · 2020-05-16 12:59:20Z

2

Use a dict comprehension.
Oh, and try to avoid calling variables the same name as built-ins (so I've called it lst instead):

result = {line.split(',')[0]: line.split(',')[1:] for line in lst}

answered May 16, 2020 at 12:59

mechanical_meat

170k25 gold badges238 silver badges231 bronze badges

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

Collectives™ on Stack Overflow

parse CSV file into dictionary with multiple values per key

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related