Writing columns from csv file in a dictionary in python

Question

I have a csv file with data like

Name Cost SKU QTY 
Julia 1    13  10
John  5    23   1
Julia 3    40   5

I would like to return a dictionary as:

{'Julia':'10', 'John':'1', 'Julia':'5'....}

My code is returning no duplicates as of now.

If you can read your `.csv` file using pandas, then you can try either `df.to_json()` or `df.to_dict()`. The problem is a dictionary won't accept duplicate keys. You may refer to this answer for more information: https://stackoverflow.com/questions/10664856/make-a-dictionary-with-duplicate-keys-in-python — Celius Stingher, Dec 02 '19 at 18:00

score 0 · Answer 1 · answered Dec 02 '19 at 18:13

0

Run this:

dict(zip(df.Name,df.QTY)

answered Dec 02 '19 at 18:13

razimbres

4,715
5
23
50

score 0 · Answer 2 · answered Dec 02 '19 at 18:19

check this answer on stackoverflow (Creating a dictionary from a csv file?) first you have to read as dictonary and change values according to that, remember that dictionary contains only distinct keys if key already exists it will be replaced by new values on the fly.

Writing columns from csv file in a dictionary in python

2 Answers2