python pandas: nested dictionary to dataframe

Question

I want to transfer a nested dic to a dataframe. (The dataframe should not be nested, only the highest layer from the dic should be converted to a dataframe).

dic =  {'Key1': 
                  {'Key1_1': [],
                   'Key1_2': 
                            {'Key1_2_1':
                                    {'Key1_2_1_1': 'value1_2_1_1'},
                              'Key1_2_2': ['listelement1value1_2_2']}},
        'Key2': 'value2', 
        'Key3': 'value3', 
        'Key4': 'value4'}

with

df = pd.DataFrame(dic, index=[0])

i get:

+----+--------+--------+--------+--------+
|    |   Key1 | Key2   | Key3   | Key4   |
|----+--------+--------+--------+--------|
|  0 |    nan | value2 | value3 | value4 |
+----+--------+--------+--------+--------+

with

series = pd.Series(dic)
df = series.to_frame().T

+----+----------------------------------------------------------------------------------------------------------------+--------+--------+--------+
|    | Key1                                                                                                           | Key2   | Key3   | Key4   |
|----+----------------------------------------------------------------------------------------------------------------+--------+--------+--------|
|  0 | {'Key1_1': [], 'Key1_2': {'Key1_2_1': {'Key1_2_1_1': 'value1_2_1_1'}, 'Key1_2_2': ['listelement1value1_2_2']}} | value2 | value3 | value4 |
+----+----------------------------------------------------------------------------------------------------------------+--------+--------+--------+

and the second result is that what i want. Is there a better way to get the second result without using a series first ?

I don't think there's anything wrong with your approach, looks fine! — user3483203
– user3483203, Commented Jun 12, 2018 at 5:31

jezrael · Accepted Answer · 2018-06-12 05:55:21Z

1

Use:

df = pd.DataFrame([dic])
print (df)
                                                Key1    Key2    Key3    Key4
0  {'Key1_1': [], 'Key1_2': {'Key1_2_1': {'Key1_2...  value2  value3  value4

answered Jun 12, 2018 at 5:55

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

python pandas: nested dictionary to dataframe

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