我仍然不确定您到底想用 MultiIndex 做什么,但这是一种在多级数组中“展平”字典并将数据正确加载到数据帧中的方法:
将“列表”和“索引”更新为 MultiIndex
In [100]: data = [[{'date_time': Timestamp('2015-05-22 05:37:59'),
.....: 'name': 'Tom',
.....: 'value': '129'},
.....: {'date_time': Timestamp('2015-05-22 05:37:59'),
.....: 'name': 'Kate',
.....: 'value': '0'},
.....: {'date_time': Timestamp('2015-05-22 05:37:59'),
.....: 'name': 'GroupeId',
.....: 'value': '0'}], [{'date_time': Timestamp('2015-05-22 05:37:59'),
.....: 'name': 'Tom',
.....: 'value': '129'},
.....: {'date_time': Timestamp('2015-05-22 05:37:59'),
.....: 'name': 'Kate',
.....: 'value': '0'},
.....: {'date_time': Timestamp('2015-05-22 05:37:59'),
.....: 'name': 'GroupeId',
.....: 'value': '0'}]]
In [101]: df = pd.DataFrame(columns=['list', 'date_time', 'name', 'value'])
In [102]: for idx, each in enumerate(data, 1):
.....: temp = pd.DataFrame(each)
.....: temp['list'] = idx # manually assign "list" index
.....: df = df.append(temp, ignore_index=True)
.....:
In [103]: df = df.reset_index()
In [104]: df.set_index(['list', 'index'])
Out[104]:
date_time name value
list index
1 0 2015-05-22 05:37:59 Tom 129
1 2015-05-22 05:37:59 Kate 0
2 2015-05-22 05:37:59 GroupeId 0
2 3 2015-05-22 05:37:59 Tom 129
4 2015-05-22 05:37:59 Kate 0
5 2015-05-22 05:37:59 GroupeId 0