python：datafram的嵌套字典

Question

我想将嵌套的dic传输到数据帧(数据帧不应嵌套，只有来自dic的最高层应转换为数据帧）

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'}

与

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

我得到：

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

与

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 |
+----+----------------------------------------------------------------------------------------------------------------+--------+--------+--------+

第二个结果就是我想要的。 有没有更好的方法来获得第二个结果而不首先使用序列

Answer 1

用途：

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