将列表和词典的混合物倒入XLSX文件

Question

D = [{"abc":[{1: "True", 2:"True", 3:"False"}]},{"bcd":[{1:"False",2:"True",3:"True" }]}]

如何将此列表转储到XLSX中？

        1.       2.       3
ABC.    True.    True.    False
Bcd.    False.   True.    True. 

Answer 1

真的很丑陋，这可能会起作用：

row_index = [list(x.keys())[0] for x in D]
column_index = list(list(D[0].values())[0][0].keys())
data = [list(list(x.values())[0][0].values()) for x in D]
df = pd.DataFrame(data=data, columns=column_index, index=row_index)
df.to_excel("some_name.xlsx")