我有两个数据帧,如下所示(第一个是df(:
索引 | 日期 | 详细信息金额 | |
---|---|---|---|
0 | 2001/01/21 | AAA1 | |
1 | 2001/01/22 | 血脑屏障 | 2 |
2 | 2001/01/23 | CCC3 |
您需要玩set_index
/reset_index
和transpose
:
(df_2
.drop(columns='Index') # drop Index column
.T.reset_index() # reset column header
.set_index(df.columns[1:]) # set names
.T
.reset_index(drop=True) # drop old index
.rename_axis('Index') # set new index name
.reset_index() # set new index as column
)
输出:
Index Date Detail Amount
0 0 2001/01/24 DDD 4
1 1 2001/01/25 EEE 5
2 2 2001/01/26 FFF 6