| | 1.2016 | 1.2016 | 1.2016 | 1.2016 | 1.2016 | 2.2016 | 2.2016 | 2.2016 | 2.2016 | 2.2016 | Unnamed: 0_level_1 | Unnamed: 1_level_1 | Unnamed: 5_level_1 |
|-------|--------|--------|--------|--------|--------|--------|--------|--------|--------|--------|--------------------|--------------------|--------------------|
| | foo | bar | turtl | truck | phon | foo | bar | turtl | truck | phon | Unnamed: 0_level_0 | Unnamed: 1_level_0 | Unnamed: 5_level_0 |
| PIZZA | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 424242 | TOP_PIZZA | 15 |
| PIZZA | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 424243 | TOP_PIZZA | 15 |
| PIZZA | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 424244 | TOP_PIZZA | 15 |
| PIZZA | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 424245 | TOP_PIZZA | 15
|
另一列有一个空的多重索引,但我想保留它们。
我想融化我的数据帧(嗯,融化似乎做了一些接近我想要的),基本上有这样的条目:
| | | | | | | Unnamed: 0_level_1 | Unnamed: 1_level_1 | Unnamed: 5_level_1 | |
|---------|-----|-------|-------|------|--------|--------------------|--------------------|--------------------|-------|
| foo | bar | turtl | truck | phon | date | Unnamed: 0_level_0 | Unnamed: 1_level_0 | Unnamed: 5_level_0 | |
| 9 | 10 | 11 | 12 | 13 | 2.2016 | 424242 | TOP_PIZZA | 15 | PIZZA |
| 10 | 11 | 12 | 13 | 14 | 2.2016 | 424243 | TOP_PIZZA | 15 | PIZZA |
| 5 | 6 | 7 | 8 | 9 | 2.2016 | 424244 | TOP_PIZZA | 15 | PIZZA |
| 8 | 9 | 10 | 11 | 12 | 2.2016 | 424245 | TOP_PIZZA | 15 | PIZZA |
| 4 | 5 | 6 | 7 | 8 | 1.2016 | 424242 | TOP_PIZZA | 15 | PIZZA |
| 5 | 6 | 7 | 8 | 9 | 1.2016 | 424243 | TOP_PIZZA | 15 | PIZZA |
| 0 | 1 | 2 | 3 | 4 | 1.2016 | 424244 | TOP_PIZZA | 15 | PIZZA |
| 3 | 4 | 5 | 6 | 7 | 1.2016 | 424245 | TOP_PIZZA | 15 | PIZZA |
col_level
参数设置为0或1,但我永远不会得到我想要的结果。我还试着把第一层的列传递给
value_vars
参数,但也没有成功。
你知道吗?
