将字典的嵌套列表转换为pandas DataFram

Question

有谁能给我一个有效的方法来把字典列表转换成熊猫数据帧吗？在

Input = [[{'name':'tom','roll_no':1234,'gender':'male'},
          {'name':'sam','roll_no':1212,'gender':'male'}],
          [{'name':'kavi','roll_no':1235,'gender':'female'},
          {'name':'maha','roll_no':1211,'gender':'female'}]]

字典键在提供的示例输入中是相同的，预期输出是

^{pr2}$

Answer 1

您将需要使用itertools.chain展开输入，然后可以调用pd.DataFrame构造函数。在

from itertools import chain
pd.DataFrame(list(chain.from_iterable(data)))

   gender  name  roll_no
0    male   tom     1234
1    male   sam     1212
2  female  kavi     1235
3  female  maha     1211