为数据框架设置垂直索引



我想将索引'stkcd'带入垂直索引,以便每行显示1,2,3 ....的行。我尝试了许多具有不同索引的转置,但我似乎索引总是转移到水平行,这不是我想要的。我希望我的结果像这样。StkCD在左侧的垂直索引上

这是我得到的,我不希望STKCD在水平线上,原始数据是此Enter Image Description

使用 unstack

给定:

print(df1)
                  value
Stkcd date             
1     2015-12-02     11
      2015-12-03     12
      2015-12-04     12
      2015-12-05     11
      2015-12-06     10
      2015-12-07     12
      2015-12-08     10
      2015-12-09     10
      2015-12-10     11
      2015-12-11     14
      2015-12-12     14
      2015-12-13     12
      2015-12-14     14
2     2015-12-02     13
      2015-12-03     14
      2015-12-04     10
      2015-12-05     12
      2015-12-06     13
      2015-12-07     12
      2015-12-08     11
      2015-12-09     10
      2015-12-10     12
      2015-12-11     12
      2015-12-12     13
      2015-12-13     10
      2015-12-14     11
3     2015-12-02     10
      2015-12-03     11
      2015-12-04     13
      2015-12-05     11
      2015-12-06     12
      2015-12-07     10
      2015-12-08     12
      2015-12-09     11
      2015-12-10     14
      2015-12-11     13
      2015-12-12     12
      2015-12-13     11
      2015-12-14     12
df1.unstack()

输出:

           value                                                                               
date  2015-12-02 2015-12-03 2015-12-04 2015-12-05 2015-12-06 2015-12-07 2015-12-08 2015-12-09   
Stkcd                                                                                           
1             11         12         12         11         10         12         10         10   
2             13         14         10         12         13         12         11         10   
3             10         11         13         11         12         10         12         11   

date  2015-12-10 2015-12-11 2015-12-12 2015-12-13 2015-12-14  
Stkcd                                                         
1             11         14         14         12         14  
2             12         12         13         10         11  
3             14         13         12         11         12 

最新更新