Question

How to set multiple column multiIndex in pandas DataFrame with Python

Answer 1

import pandas as pd
  
df = pd.DataFrame(
    [['Tom', 91, 80, 94],
     ['Emmy', 98, 95, 96],
     ['Rubeus', 87, 81, 87],
     ['Dumbledore', 99, 100, 98],
     ['Axel', 75, 85, 90]],
    columns=['name', 'algebra', 'python', 'java'])
  
df = df.set_index(['algebra', 'python'])

print(df)

   
   
'''
run:
   
                       name  java
algebra python                  
91      80             Tom    94
98      95            Emmy    96
87      81          Rubeus    87
99      100     Dumbledore    98
75      85            Axel    90

'''

 

70+ SQL courses for beginners and professionals