create dataframe from nested dictionary

Question

I have a dictionary as given below:-

d = {'Tom'  :{'A' : '25', 'B' : '34'}, 
     'Jim'  : {'A' : '34', 'B' : '19'}, 
     'john' : {'A' :'56' , 'B' : '32'}}

How can I construct the dataframe like this from the above dictionary?

Names	A	B
Tom	25	34
Jim	34	19
John	56	32

Jon Clements · Accepted Answer · 2021-12-08 07:48:07Z

2

Use the pandas.DataFrame.from_dict specifying the orientation of index, eg:

df = pd.DataFrame.from_dict(d, orient='index')

(Then optionally reset your index and give it a name..., eg:)

df = pd.DataFrame.from_dict(d, orient='index').rename_axis('Names').reset_index()

edited Dec 8, 2021 at 7:48

answered Dec 8, 2021 at 7:41

Jon Clements

143k34 gold badges254 silver badges288 bronze badges

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

2 Comments

user12252991 Over a year ago

It gives the dataframe with another index as 0,1,2. Is there a way we can remove that and just get the columns Name, A and B ?

Jon Clements Over a year ago

Umm... don't reset the index then... it makes more sense to have your name as an index anyway... (if you want it named.... then remove the .reset_index() from the 2nd example)

nikeros · Accepted Answer · 2021-12-08 07:58:48Z

0

Just create a DataFrame with d and transpose it:

import pandas as pd

pd.DataFrame(d).transpose()

OUTPUT

       A   B
Tom   25  34
Jim   34  19
john  56  32

answered Dec 8, 2021 at 7:58

nikeros

3,3792 gold badges12 silver badges27 bronze badges

Collectives™ on Stack Overflow

create dataframe from nested dictionary

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related