Python Pandas | Create a DataFrame with the levels of the MultiIndex as columns and substitute index level names

Python code to create a DataFrame with the levels of the MultiIndex as columns

# Import the pandas package
import pandas as pd

# Create arrays
employees = [
        ['E101', 'E102', 'E102', 'E103'],
        ['Alex', 'Alvin', 'Deniel', 'Jenny'],
    ]

# create a Multiindex using  from_arrays() 
mi = pd.MultiIndex.from_arrays(employees, names=('emp_id', 'name'))

# display the Multiindex
print("The MultiIndex...\n",mi)
print()

# Get the levels in MultiIndex
print("The levels in MultiIndex...\n",mi.levels)
print()

# Create a DataFrame
df = mi.to_frame(name=['Emp. ID', 'Emp. Name'])

# Print the DataFrame
print("The DataFrame is...\n", df)

Output:

The MultiIndex...
 MultiIndex([('E101',   'Alex'),
            ('E102',  'Alvin'),
            ('E102', 'Deniel'),
            ('E103',  'Jenny')],
           names=['emp_id', 'name'])

The levels in MultiIndex...
 [['E101', 'E102', 'E103'], ['Alex', 'Alvin', 'Deniel', 'Jenny']]

The DataFrame is...
               Emp. ID Emp. Name
emp_id name                    
E101   Alex      E101      Alex
E102   Alvin     E102     Alvin
       Deniel    E102    Deniel
E103   Jenny     E103     Jenny