Python csv file to data dictionary multiple keys

Question

I have a huge csv file with 4 columns. i'm trying to convert them into a data dictionary. the first column [0] should be the master key. when i try to use the dictionary i get a key error.

columns in csv file:Code Description Category Detail

csv file

with open('sample.csv') as f:
reader = csv.reader(f)
next(reader,None)
code= {}
description= {}
category = {}
detail = {} 
for row in reader:
    code = {row[0]:row[1]}
    description =  {row[0]:row[2]}
    category = {row[0]:row[3]}
    detail = {row[0]:row[4]}

output: {101:'pen', 102:'' 103:'book' 104:'paper' }

{ 101:'Writing', 102:'stuff', 103:'school', 104:'office' }

{ 101:'stuff', 102:'stuff', 103:'', 104:'' }

Have you consider reading it with pandas and then transforming it into a dictionary DataFrame to dict? — luis.galdo
– luis.galdo, Commented Feb 20, 2019 at 16:54

luis.galdo · Accepted Answer · 2019-02-20 16:57:57Z

1

You could do the following:

import pandas as pd

df = pd.read_csv("sample.csv")
df.to_dict('records')

You would first import it as a DataFrame from Pandas and then transfrom it into a dict with the argument records. Here you can see how to to_dict works.

answered Feb 20, 2019 at 16:57

luis.galdo

6036 silver badges20 bronze badges

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

1 Comment

luis.galdo Over a year ago

if you think the answer is correct, you can select is the right one. Thanks!

Collectives™ on Stack Overflow

Python csv file to data dictionary multiple keys

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related