我有一本嵌套的词典,如下所示.
my_dic={'CELL1': {'C2': 'LOW', 'C3': 'HIGH', 'C4': 'Pass'}, 'CELL2': {'C2': 'LOW', 'C3': 'HIGH', 'C4': 'Pass'}, 'CELL3': {'C2': 'LOW', 'C3': 'HIGH', 'C4': 'Pass'}, 'CELL4': {'C2': 'LOW', 'C3': 'HIGH', 'C4': 'Pass'}, 'CELL5': {'C2': 'LOW', 'C3': 'HIGH', 'C4': 'Pass'}}
我正在try 以以下格式将数据框打印到控制台上.
C1 C2 C3 C4
0 CELL1 LOW HIGH Pass
1 CELL2 LOW HIGH Pass
2 CELL3 LOW HIGH Pass
3 CELL4 LOW HIGH Pass
4 CELL5 LOW HIGH Pass
5 CELL5 LOW HIGH Pass
但当我try 将列名改写为我想要的内容时.我得到了下面的错误.
ValueError: Length mismatch: Expected axis has 0 elements, new values have 4 elements
我已经try 了下面的代码.有人能帮我解决这个问题吗?
df_my =pd.DataFrame.from_dict(my_dic,orient = 'index').reset_index()
df_my.columns=["C1", "C2", "C3", "C4"]