testmultiindex
Overview
single_column_name
mi_column
mi_index
both
mi_column_name
name_with_int
mi_index_name
both_name
both_name_skiprows
Sheet 1: single_column_name
| c1 | a | b | c | d |
| 0 | 1 | 2.5 | 2015-01-01 00:00:00 | 1 |
| 1 | 2 | 3.5 | 2015-01-02 00:00:00 | 0 |
| 2 | 3 | 4.5 | 2015-01-03 00:00:00 | 0 |
| 3 | 4 | 5.5 | 2015-01-04 00:00:00 | 1 |
Sheet 2: mi_column
| foo | bar |
| a | b | a | b |
|
|
|
|
|
| 0 | 1 | 2.5 | 2015-01-01 00:00:00 | 1 |
| 1 | 2 | 3.5 | 2015-01-02 00:00:00 | 0 |
| 2 | 3 | 4.5 | 2015-01-03 00:00:00 | 0 |
| 3 | 4 | 5.5 | 2015-01-04 00:00:00 | 1 |
Sheet 3: mi_index
|
| a | b | c | d |
| foo | a | 1 | 2.5 | 2015-01-01 00:00:00 | 1 |
| b | 2 | 3.5 | 2015-01-02 00:00:00 | 0 |
| bar | a | 3 | 4.5 | 2015-01-03 00:00:00 | 0 |
| b | 4 | 5.5 | 2015-01-04 00:00:00 | 1 |
Sheet 4: both
|
| foo | bar |
|
| a | b | a | b |
|
|
|
|
|
|
| foo | a | 1 | 2.5 | 2015-01-01 00:00:00 | 1 |
| b | 2 | 3.5 | 2015-01-02 00:00:00 | 0 |
| bar | a | 3 | 4.5 | 2015-01-03 00:00:00 | 0 |
| b | 4 | 5.5 | 2015-01-04 00:00:00 | 1 |
Sheet 5: mi_column_name
| c1 | foo | bar |
| c2 | a | b | a | b |
| 0 | 1 | 2.5 | 2015-01-01 00:00:00 | 1 |
| 1 | 2 | 3.5 | 2015-01-02 00:00:00 | 0 |
| 2 | 3 | 4.5 | 2015-01-03 00:00:00 | 0 |
| 3 | 4 | 5.5 | 2015-01-04 00:00:00 | 1 |
Sheet 6: name_with_int
| c1 | foo | bar |
| c2 | 1 | 2 | 1 | 2 |
| 0 | 1 | 2.5 | 2015-01-01 00:00:00 | 1 |
| 1 | 2 | 3.5 | 2015-01-02 00:00:00 | 0 |
| 2 | 3 | 4.5 | 2015-01-03 00:00:00 | 0 |
| 3 | 4 | 5.5 | 2015-01-04 00:00:00 | 1 |
Sheet 7: mi_index_name
| ilvl1 | ilvl2 | a | b | c | d |
| foo | a | 1 | 2.5 | 2015-01-01 00:00:00 | 1 |
| b | 2 | 3.5 | 2015-01-02 00:00:00 | 0 |
| bar | a | 3 | 4.5 | 2015-01-03 00:00:00 | 0 |
| b | 4 | 5.5 | 2015-01-04 00:00:00 | 1 |
Sheet 8: both_name
| c1 | foo | bar |
| c2 | a | b | a | b |
| ilvl1 | ilvl2 |
|
|
|
|
| foo | a | 1 | 2.5 | 2015-01-01 00:00:00 | 1 |
| b | 2 | 3.5 | 2015-01-02 00:00:00 | 0 |
| bar | a | 3 | 4.5 | 2015-01-03 00:00:00 | 0 |
| b | 4 | 5.5 | 2015-01-04 00:00:00 | 1 |
Sheet 9: both_name_skiprows
| c1 | foo | bar |
| c2 | a | b | a | b |
| ilvl1 | ilvl2 |
|
|
|
|
| foo | a | 1 | 2.5 | 2015-01-01 00:00:00 | 1 |
| b | 2 | 3.5 | 2015-01-02 00:00:00 | 0 |
| bar | a | 3 | 4.5 | 2015-01-03 00:00:00 | 0 |
| b | 4 | 5.5 | 2015-01-04 00:00:00 | 1 |