Nested dictionary to dataframe

Nested dict to df

user_dict = {12: {'Category 1': {'att_1': 1, 'att_2': 'whatever'},
                  'Category 2': {'att_1': 23, 'att_2': 'another'}},
             15: {'Category 1': {'att_1': 10, 'att_2': 'foo'},
                  'Category 2': {'att_1': 30, 'att_2': 'bar'}}}

pd.DataFrame.from_dict({(i,j): user_dict[i][j] 
                           for i in user_dict.keys() 
                           for j in user_dict[i].keys()},
                       orient='index')


               att_1     att_2
12 Category 1      1  whatever
   Category 2     23   another
15 Category 1     10       foo
   Category 2     30       bar

Source: grepper.com

Similar codes

7 votes204 views3 answers
Python flask access-control-allow-origin
Python Flask
14 votes181 views2 answers
Python tim script
Python
56 votes147 views2 answers
Convert date string to date time string python
Python
48 votes176 views6 answers
Assembly
Python
10 votes160 views3 answers
Python click on screen
Python
0 vote159 views1 answer
Python get unique pairs from two lists
Python
0 vote156 views2 answers
Cron job python
Python
0 vote160 views1 answer
Video timestamp opencv python
Python
0 vote160 views1 answer
Pvm python
Python
4 votes149 views2 answers
Pandas normalize df
Python