在Python中将列表的字典列表转换为DataFrame表

Question

我有一个要转换成数据帧表的字典列表。我知道题目里的问题有点让人困惑，所以我把字典贴出来：

[{'MESSAGE': ['RECEIVED SUCCESSFULLY AWAITING STOCKING PROCESS'], 'BIN': ['8FHA9D83H 82HG7D9F'], 'INV': 'SSXR   98-20LM NM CORN CREAM'}, {'MESSAGE': ['RECEIVED SUCCESSFULLY AWAITING STOCKING PROCESS', '#2956- INVALID STOCK COUPON CODE (MISSING).', 'RECEIVED SUCCESSFULLY AWAITING STOCKING PROCESS'], 'BIN': ['HA8DHWO2H HAHD0138', '8SHDNAIDU 00AD0123', '938273548 0967HDBR'], 'INV': 'FPBC   *SOUP CANS LENTILS'}]

我尝试过很多Pandas方法，但是因为每个键都有多个值，所以这是一个稍微难解决的问题。我试着改变传统的方法pd数据帧，但我不太明白。我需要df表格在打印时显示此输出：

^{pr2}$

我对Python2.7还是个新手，如果有任何帮助，我将不胜感激：）

Answer 1

假设L是你的字典列表：

pd.concat(pd.DataFrame(l) for l in L)

Out: 
                  BIN                           INV  \
0  8FHA9D83H 82HG7D9F  SSXR   98-20LM NM CORN CREAM   
0  HA8DHWO2H HAHD0138     FPBC   *SOUP CANS LENTILS   
1  8SHDNAIDU 00AD0123     FPBC   *SOUP CANS LENTILS   
2  938273548 0967HDBR     FPBC   *SOUP CANS LENTILS   

                                           MESSAGE  
0  RECEIVED SUCCESSFULLY AWAITING STOCKING PROCESS  
0  RECEIVED SUCCESSFULLY AWAITING STOCKING PROCESS  
1      #2956- INVALID STOCK COUPON CODE (MISSING).  
2  RECEIVED SUCCESSFULLY AWAITING STOCKING PROCESS