Creating dictionary from dataframe in python

Question

I want to create a dictionary out of my data frame. Data frame look like this:

Vehical | Brand  | Model Name
car     | Suzuki | abc 
car     | Honda  | def
bike    | Suzuki | xyz
bike    | Honda  | asd

I want my dictionary like:

{car : {Suzuki : abc, Honda : def}, bike : {Suzuki : xyz, Honda : asd}}

MaxU - stand with Ukraine · Accepted Answer · 2016-09-16 10:09:43Z

3

you can do it this way:

In [29]: df.pivot(index='Vehical', columns='Brand', values='Model Name').to_dict('i')
Out[29]:
{'bike': {'Honda': 'asd', 'Suzuki': 'xyz'},
 'car': {'Honda': 'def', 'Suzuki': 'abc'}}

result of pivoting:

In [28]: df.pivot(index='Vehical', columns='Brand', values='Model Name')
Out[28]:
Brand   Honda Suzuki
Vehical
bike      asd    xyz
car       def    abc

answered Sep 16, 2016 at 10:09

MaxU - stand with Ukraine

212k37 gold badges402 silver badges436 bronze badges

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

Collectives™ on Stack Overflow

Creating dictionary from dataframe in python

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