Convert dictionary of dictionaries into DataFrame Python

Question

I am trying to convert the following dictionary of dictionaries into pandas DataFrame.

My dictionary looks like this:

mydata = {1965:{1:52, 2:54, 3:67, 4:45}, 
          1966:{1:34, 2:34, 3:35, 4:76}, 
          1967:{1:56, 2:56, 3:54, 4:34}}

And I need to get a resulting dataframe that looks like this:

 Sector  1965  1966 1967
   1      52    34   56
   2      54    34   56
   3      67    35   54
   4      45    76   34

I was using something like this, but I'm not getting the result that I need.

df = pd.DataFrame([[col1,col2,col3] for col1, d in test.items() for col2, col3 in d.items()])enter code here

Thanks a lot for your help!!!

jezrael · Accepted Answer · 2016-06-15 15:04:56Z

5

You can use DataFrame.from_records:

import pandas as pd

ydata = {1965:{1:52, 2:54, 3:67, 4:45}, 
          1966:{1:34, 2:34, 3:35, 4:76}, 
          1967:{1:56, 2:56, 3:54, 4:34}} 

print (pd.DataFrame.from_records(ydata))
   1965  1966  1967
1    52    34    56
2    54    34    56
3    67    35    54
4    45    76    34

print (pd.DataFrame.from_records(ydata).reset_index().rename(columns={'index':'Sector'}))
   Sector  1965  1966  1967
0       1    52    34    56
1       2    54    34    56
2       3    67    35    54
3       4    45    76    34

answered Jun 15, 2016 at 15:04

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

Collectives™ on Stack Overflow

Convert dictionary of dictionaries into DataFrame 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