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

47 votes167 views6 answers
Random float python
Python
-1 vote170 views3 answers
Prime numbers upto n in python
Python
0 vote140 views1 answer
Enumerate() to skip items
Python
0 vote160 views2 answers
To copy a directory from a local to remote system, use the -r option
Python
0 vote161 views1 answer
Return the biggest even fro a list python
Python
0 vote173 views1 answer
How to resolve This typically means that you attempted to use functionality that needed an active HTTP request. Consult the documentation on testing for information about how to avoid this problem. in thread python
Python
12 votes151 views2 answers
Get python version jupyter
Python
3 votes177 views1 answer
Close terminal python
Python
0 vote166 views1 answer
Python tuple to dict
Python
0 vote153 views1 answer
Dtype function with example
Python