python展开面_python – 将多索引数据帧展开到pandas中的平面数据框

使用

pandas.DataFrame.to_records().

例：

import pandas as pd

import numpy as np

arrays = [['Monday','Monday','Tursday','Tursday'],

['Morning','Noon','Morning','Evening']]

tuples = list(zip(*arrays))

index = pd.MultiIndex.from_tuples(tuples, names=['Weekday', 'Time'])

df = pd.DataFrame(np.random.randint(5, size=(4,2)), index=index)

In [39]: df

Out[39]:

0 1

Weekday Time

Monday Morning 1 3

Noon 2 1

Tursday Morning 3 3

Evening 1 2

In [40]: pd.DataFrame(df.to_records())

Out[40]:

Weekday Time 0 1

0 Monday Morning 1 3

1 Monday Noon 2 1

2 Tursday Morning 3 3

3 Tursday Evening 1 2