Turn Pandas Multi-Index into column
Pandas DataFrame is a two-dimensional size-mutable, potentially heterogeneous tabular data structure with labeled axes (rows and columns). A multi-index dataframe has multi-level, or hierarchical indexing. We can easily convert the multi-level index into the column by the reset_index() method.
DataFrame.reset_index() is used to reset the index to default and make the index a column of the dataframe.
Step 1: Creating a multi-index dataframe.
Let’s see an example by making a multi-index dataframe first.
Step 2: Converting index into the column.
Here we can see the hierarchical indexing, we are going to convert it into a column using the reset_index() method.
Here we can see that the index is default now and our multi-index now becomes columns with the default. We can also select which level of multi-index to reset using parameter level.
Here, we can see that only indx1 is reset becomes a column, not both the indices. Also, notice that there is no default index in this case because there is still an index (indx2) left.