make index a row code example

Example 1: pandas create a column from index

df.reset_index(level=0, inplace=True)

Example 2: how to make index column as a normal column

>>> df.reset_index(level=['tick', 'obs'])
          tick  obs     val
tag                        
C   2016-02-26    2  0.0139
A   2016-02-27    2  0.5577
C   2016-02-28    6  0.0303